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 don't have a class during 1st period?
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
They're having trouble unloading
the buses on time, and
0:00
are wondering if they can get
some of the teachers to help out.
0:01
To figure out which teachers don't
have a class during first period,
0:04
we can actually do
something pretty clever.
0:08
Instead of trying to solve
this question directly,
0:10
we can figure out which teachers do
have a class during first period, and
0:13
just subtract those teachers away
from all the other teachers.
0:17
So let's start by figuring out,
0:21
which teachers do have
a class during first period.
0:22
So let's SELECT* FROM TEACHERS, And
then to get the period information,
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