1. Write a SELECT statement to list course data sorted by course number. 2. Write a SELECT statement to list zipcodes and their cities in New York State sorted by zipcode. 3. Write a SELECT statement to list first and last names of all instructors sorted by last name. 4. Write a SELECT statement to list courses that have the course number 20 as a prerequisite. 5. Write a SELECT statement to list the last and first names in last name order of students that are currently employed by the firm Electronic Engineers and have last names starting with "G". 6. Write the same SELECT statement as #5 but include students who are Electronic Engineers employees with the last name beginning with S or B. (Hint: Use parentheses in the WHERE clause to isolate the OR logic). 7. Write a SELECT statement to list students that live either in zip code 11433,11434 , or 11435. 8. Write a SELECT statement to list the courses that cost $1095 or less. 9. Write a SELECT statement to list the first and last name of students that do not have the salutation of "Dr.". 10. Write a SELECT statement to list courses that do not have a prerequisite. 11. Count the number of students with a " s " in their last name. Use INSTR to produce the answer. 12. Show the average cost of a course with no prerequisites 13. Display the course number, number of sections and total capacity for courses having more than 2 sections. 14. List all instructors and how many sections they teach. 15. Do \#14 but limit it to instructors te aching more than 9 sections. 16. Create a list of courses, sections and their capacity. Produce the result in the following format: Report - Each student will create her his own lab02notes and own report. - Submit Lab02.doc and a copy of your worksheet output image/s document using your blackboard account