Exercise 6.1

Write queries on the grading database to:

  1. Get a list of student names along with their mentor name. Include all students, even those without a mentor.

  2. Modify the previous query to list all mentors without mentees as well.

Exercise 6.2

Write queries on the grading database to:

  1. Compute the minimum, maximum and average scores for all sections of CS 108 lab 1.

  2. Retrieve the enrollment for each section. Order the results by descending enrollment. You can ignore empty sections. When that is complete, modify the query to:

    1. retrieve sections that have less than 2 students.
    2. retrieve only sections for 100-level courses.
    3. include the full course name (e.g., “MATH156A”).

    As challenges, try to handle empty sections or to get only the fullest section.