Query 1

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.

Place Similar Order Now!

  • Our Support Staff are online 24/7
  • Our Writers are available 24/7
  • Most Urgent order is delivered with 6 Hrs
  • 100% Original Assignment Plagiarism report can be sent to you upon request.
[order_calculator]