MariaDB [(none)]> use toyu
Database changed
MariaDB [toyu]> 
MariaDB [toyu]> 
MariaDB [toyu]> SELECT CONCAT(s.fName, ' ', s.lName) AS student,
    ->    COUNT(e.classId) as num_classes
    -> FROM student AS s LEFT JOIN enroll AS e ON (s.stuId = e.stuId)
    -> WHERE s.major = 'CSCI'
    -> GROUP BY s.stuId, student
    -> ORDER BY s.lName, s.fName;
+------------+-------------+
| student    | num_classes |
+------------+-------------+
| David Hawk |           3 |
| Mary Hawk  |           2 |
| Tony Hawk  |           6 |
+------------+-------------+
3 rows in set (0.010 sec)

MariaDB [toyu]> notee