SQL Lab

Select all students

Return every row and column from the students table.

Filter with WHERE

Find students with a GPA greater than or equal to 3.5.

ORDER BY and LIMIT

Show the top 3 students by GPA.

GROUP BY with COUNT

Count how many students are in each major.

HAVING with AVG

Show majors whose average GPA is above 3.6.

INSERT a row

Add a new student to the database.

UPDATE a row

Raise a student's GPA by 0.1.

DELETE a row

Remove a student by name.

MIN, MAX, SUM

Show the minimum, maximum and total credits of all courses.

INNER JOIN

List student names and the courses they are enrolled in.

LEFT JOIN

List all professors and their courses, including professors with no courses.

Multiple JOINs

Show each student's name, course, and grade.