Preview
Video Player
00:00
00:00
Listing Subjects
0:49Generate a list of all the subjects taught at Jefferson Middle School.
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