Q9 list all zipcodes where at least three students

This preview shows page 8 - 10 out of 10 pages.

Q9: List all zipcodes where at least three students AND at least four instructor reside. Show zip, state and city. )>= 3 )>= 4
Q10: List all cities that have 10 or more students and instructor 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. I would upload the student schema file that's used with this assignment ) as Select where from 10

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture