SQL



This homework assignment uses Homework Database that contains all tables from both Movie Database and University Database (you used Homework Database in HW-2). Write, run, and save the following SQL queries in this database.

Query 1 (2 pts)

List the first and last names of all students that never got a C grade.

Query 2 (2 pts)

Find the number of distinct movies played in Chicago, IL. Output a table consisting of one record and one column headed Number of Movies.