Write Ten SQL SELECT statements to query the STUDENT schema you
created for practice lab 1. Your Select Statements should run error-
free and should be valid.
Submit two separate files: one plain text file (.txt or .sql file) with
your SELECT statements only; and the other document (doc/docx/pdf)
include both your SELECT 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.
1. Show the number of instructors who have a zip of 10025 and a the
street number of 518.
2. Display all students who live in the state of MA. List first name, last
name, zip, and city. Sort by city (descending), zip (ascending), and
last name (ascending).
3. List all zipcodes where at least three students AND at least four
instructors reside. Show zip, state and city.
4. List all cities that have 10 or more students and instructors
combined. Show city, state, number of student residents, number of