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
First off,
we'd like you to generate a list of
0:00
all the subjects they teach
at Jefferson Middle School.
0:02
So pause me and go ahead and
watch the SQL Playground.
0:05
It includes the database
we'll be working with and
0:08
is where you'll be writing your queries.
0:10
Once you've written the query,
unpause the video and
0:12
I'll show you how I solved the problem.
0:15
Okay, so
0:18
we need to figure out which subjects
are taught at Jefferson Middle School.
0:19
To start, we first need to figure
out which table we need to use.
0:23
For this one, it's pretty clear that
we need to use the SUBJECTS table.
0:27
So, let's start by selecting everything,
0:31
which is represented as a star,
and from the SUBJECTS table.
0:34
Then let's add a semicolon
to end the statement, and
0:39
you use shift-enter to run it.
0:42
And there we go, all the subjects that
are taught at Jefferson Middle School.
0:44
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