PracticeLab5_OUTPUT.docx - 1 Show the number of instructors...

This preview shows page 1 - 2 out of 3 pages.

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 instructor residents, and total student/instructor residents in that city. Sort by total in descending order. 5.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture