Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.
Listing Subjects0:49 with Ben Deitch
Generate a list of all the subjects taught at Jefferson Middle School.
First off, we'd like you to generate a list of
all the subjects they teach at Jefferson Middle School.
So pause me and go ahead and watch the SQL Playground.
It includes the database we'll be working with and
is where you'll be writing your queries.
Once you've written the query, unpause the video and
I'll show you how I solved the problem.
we need to figure out which subjects are taught at Jefferson Middle School.
To start, we first need to figure out which table we need to use.
For this one, it's pretty clear that we need to use the SUBJECTS table.
So, let's start by selecting everything,
which is represented as a star, and from the SUBJECTS table.
Then let's add a semicolon to end the statement, and
you use shift-enter to run it.
And there we go, all the subjects that are taught at Jefferson Middle School.
You need to sign up for Treehouse in order to download course files.Sign up