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 only students in 8th grade?
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
First, the principal wants to do something
nice for the eighth grade teachers.
0:00
If you could get them a list of
which teachers teach eighth grade,
0:02
that would be awesome.
0:05
To figure out which teachers teach
only students in eighth grade,
0:07
let's start by looking
at the teachers table.
0:11
Unfortunately, it doesn't look like
we have any great information here.
0:14
So we're going to have to join out to some
other tables to get that information.
0:18
Looking at the classes table,
0:22
this would be a good table to
join to with our teacher ID.
0:24
And it also gives us access to
the subject ID of the class.
0:27
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