(Solved) : 1 Show Number Instructors Zip 10025 Street Number 518 2 Display Students Live State Ma Lis Q32989098 . . . .

1. Show the number of instructors who have a zip of 10025 and astreet number of 518.

2. Display all students who live in the state of MA. List firstname, 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 leastfour instructors reside. Show zip, state and city.

4. List all cities that have 10 or more students and instructorscombined. Show city, state, number of student residents, number ofinstructor residents, and total student/instructor residents inthat city. Sort by total in descending order.

5. List the instructor id and name