Need help with SQL database questions!!!?

Write a SQL statement that gives the average of the grades in table GRADE.

Write a SQL statement that counts the number of cities in table ZIPCODE; each city is counted only once.

Write a SQL statement to show course description in alphabetical order.

Write a SQL statement to list zipcodes and cities in state CT sorted by zipcode.

Write a SQL statement to list first and last names of all instructors sorted by last name.

Write a SQL statement to show course descriptions that have the course number 20 as a prerequisite.

Write a SQL statement to list the IDs of students that are hired by New York Pop.

Write a SQL statement to list first and last names of students that live in zip code 11434 or 11435.

Write a SQL statement that removes all the zeros from this number: 000123450000.

Write a SQL statement to list the first four characters of the first name of each instructor.

Write a SQL statement to list student first and last names, where each first name must begin with a letter 'A', and also orders the result set based on the length

 of students' last name.

Write a SQL statement that shows the result of this arithmetic operation: 8/5 + 6.

Write a SQL statement to list the last names of instructors, where a last name contains exactly six characters.

Write a SQL statement to count the number of instructors with a letter 'n' in their last name.

Attachment image
There are no answers yet.
Be the first to answer this question.