Honors 1000, Productive Data Manipulation in Python and SQL (Fall 2018)

Assignment 2 - MySQL Queries (Due: Wednesday, September 26, 2018)

Consider the database that was created in Homework 1. Write SQL queries to answer the following:

1. Retrieve names of "Professors" who teach courses numbered less than 4000.
2. Retrieve the total number of courses offered during Fall 2018.
3. For each rank of teacher, retrieve rank and number of courses taught by teachers with that rank.
4. For courses that have multiple sections, retrieve cno and starttime of earliest section.
5. For courses that have multiple sections, retrieve cno and count of sections.

File to submit: queries.sql