Write 10 SQL statements against the STUDENT schema. Your statements should run error-free and
should be valid. Submit two separate files: one plain text file (.txt or .sql file) with your statements only;
and the other document (doc/docx/pdf) include both your statements and your query results (copy and
paste text or screen shots). The instructor and TA should be able to run your plain text source file as
script and generate the same output as shown in your result document.
Q1. List all instructors. Show salutation in all lower cases, last name in all upper cases and phone number
in the format of '(xxx) xxx-xxxx'. (HINT: use LOWER, UPPER and SUBSTR function)
Q2. List all students (display student_id, first name, last name, street address, zipcode, city, and state)
who live in New York, NY. Sort results by last name, and then first name, in descending order.
Q3. Display the city in which each instructor lives. List first name, last name, zip, city, and state. Display