tee 2025_9_29_sql_log.txt

SELECT major
FROM student;

SELECT DISTINCT major
FROM student;

SELECT DISTINCT fname
FROM student
WHERE major = 'CSCI';

# max ach
SELECT MAX(ach) AS max_ach
FROM student;

SELECT DISTINCT s.stuId, s.ach,
    (max_student.max_ach - s.ach) AS `delta ach from the max student`
FROM student AS s,
    (SELECT MAX(ach) AS max_ach
     FROM student) AS max_student;