# 1 Write a SELECT statement to list city data with the frst letter of a word capitalized and state data in

uppercase.

#2 Write a SELECT statement that removes all the zeros from this number: 0008954210000

#3 Write a SELECT statement to list the frst four characters of the frst name of each instructor.

#4 Write a SELECT statement to list student frst and last names, where each frst name must contain a

letter z, and also orders the result set based on the length of students last name

#5 Write a SELECT statement that shows only the smallest integer from this arithmetic operation:

19/7

student schema