Query 1

| October 27, 2015

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.

Get a 5 % discount on an order above $ 150
Use the following coupon code :
2020Discount
Indent code
Java

Category: Homework Help

Our Services:
Order a customized paper today!
Open chat
Hello, we are here to help with your assignments
Powered by