"Database Foundations" was retired on March 22, 2017. You are now viewing the recommended replacement.
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