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 a class during all 7 periods?
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
The management team's been looking
into teacher compensation, and
0:00
they've got a lot of questions
they'd like answered.
0:01
First, they'd like to know which
teachers are doing the most teaching.
0:04
Could you figure out which
teachers teach all seven periods?
0:08
For this query we'll need to start
with the teacher's table and
0:12
then join out to the classes table.
0:15
So let's start by selecting everything
from the teacher's table and
0:17
then joining to the classes table on
teachers.id = classes.teacher ID.
0:23
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