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
Generate a list of all the subjects taught at Jefferson Middle School.
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
It includes the database
we'll be working with and
0:00
is where you'll be writing your queries.
0:01
Once you've written the query,
unpause the video and
0:03
I'll show you how I solved the problem.
0:06
Okay, so
0:09
we need to figure out which subjects
are taught at Jefferson Middle School.
0:10
To start, we first need to figure
out which table we need to use.
0:14
For this one, it's pretty clear that
we need to use the SUBJECTS table.
0:18
So, let's start by selecting everything,
0:22
which is represented as a star,
and from the SUBJECTS table.
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