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.
 
 
 

 

 

 

    • 11 years ago
    A+ Work
    NOT RATED

    Purchase the answer to view it

    • csot_ateabassystems.zip