SQL

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.