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 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 up