Query 1
List the first and last names of all students that never got a C grade
Query 2
Find the number of distinct movies played in Chicago, IL. Output a table consisting of one record and one column headed Number of Movies.
Query 3
. For each student, find the number of courses taken by this student. Output a table consisting of three columns: FirstName, LastName, Number of Courses.
Query 4
Find all students who take at least three courses. Output a table consisting of three columns: FirstName, LastName, Number of Courses.
Query 5
For each theatre, find the lowest and highest ratings of the movies played in this theatre. Output a table consisting of three columns: Theatre, Lowest, Highest.
Query 6
Find the course(s) offered in the maximum number of terms. Output a table consisting of two columns: Name (the name of the course from Courses Table, not its CourseId!), Number of Terms.
