List the first and last names of all students that never got a C grade
Find the number of distinct movies played in Chicago, IL. Output a table consisting of one record and one column headed Number of Movies.
. For each student, find the number of courses taken by this student. Output a table consisting of three columns: FirstName, LastName, Number of Courses.
Find all students who take at least three courses. Output a table consisting of three columns: FirstName, LastName, Number of Courses.
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.
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.