.read spec.sql

SELECT * FROM students;

SELECT first_name, last_name FROM students;

SELECT student_id, last_name 
FROM students WHERE first_name='John';

SELECT * FROM courses;

SELECT * FROM courses
WHERE course_title LIKE '%systems%';

SELECT * FROM courses JOIN students;

SELECT * FROM enrollments;

SELECT * FROM enrollments 
JOIN students 
USING (student_id);

SELECT * FROM enrollments 
JOIN students USING (student_id)
JOIN courses USING (department_code, course_number);

SELECT first_name, last_name, course_title FROM enrollments 
JOIN students USING (student_id)
JOIN courses USING (department_code, course_number);

SELECT first_name, last_name, course_title FROM enrollments 
JOIN students USING (student_id)
JOIN courses USING (department_code, course_number)
WHERE course_title LIKE '%programming%';