Note all the queries are for the STUDENT schema, and you need to test

your statements to make sure they have no syntax errors and work as expected.

1. Write a SELECT statement to list city data with the first 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 first four characters of the first name of each instructor.

4. Write a SELECT statement to list student first and last names, where each first 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

.6. Write a SELECT statement to list the last names of instructors, where a last name contains no more than seven characters.

7. Write a SELECT statement to list each students last name, followed by a comma and a space, followed by the students first name, all in a single column in the result set.

8. Write a SELECT statement that changes the phrase Today is Monday to Today is Tuesday

.9. What is the DUAL table? Does it belong to the STUDENT schema?

10. A calculation with a null always yields another null; which function can be used to avoid such a case?