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.