Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed SQL Reporting by Example!
You have completed SQL Reporting by Example!
Preview
Which teachers teach elective courses?
This video doesn't have any notes.
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
And they'd like to start by getting
the opinions of the elective teachers.
0:00
Could you generate a list
of the elective teachers?
0:02
This query is going to be a lot
like the previous two queries.
0:05
We're going to need to start with
the TEACHERS or SUBJECTS table and
0:08
use the CLASSES table to
join to the other one.
0:11
So let's start by selecting DISTINCT.
0:13
And it's TEACHERS.ID and
FIRST_NAME and LAST_NAME.
0:18
FROM TEACHERS JOIN CLASSES ON TEACHERS.ID
0:25
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up