CSC455 Chapter 5 Lab 4

Using the University database, complete the following queries. Copy and paste the SQL into a document to print or submit to BB.

Check your answers here

1. Find the names of faculty who teach in room H225. Do not display duplicates. (Use IN)

2. Find the class number, schedule, and room for all classes that Smith of the History department teaches.

3. Find the names of all the teachers that Ann Chin has, along with all her classes and grades from each.

4. Find the name and major of the student with the most number of credits.

5. Find the number of students who are currently enrolled in a course. Do not count the same student twice.

6. Find the names of all students who have fewer than average number of credits.

7. For each student, find the number of classes he or she is enrolled in. Include the student’s name.

8. Find Classes for which no students are enrolled.