Most Popular Teacher4:28 with Ben Deitch
Which elective teacher is the most popular?
Using the WITH keyword
Want to learn and practice more about using the
WITH keyword? Check out our workshop on it: Common Table Expressions Using WITH
Elective teachers query:
SELECT DISTINCT TEACHERS.ID, FIRST_NAME, LAST_NAME FROM TEACHERS JOIN CLASSES ON TEACHERS.ID = CLASSES.TEACHER_ID JOIN SUBJECTS ON CLASSES.SUBJECT_ID = SUBJECTS.ID WHERE GRADE IS NULL;
You need to sign up for Treehouse in order to download course files.Sign up