1 00:00:00,300 --> 00:00:02,900 First off, we'd like you to generate a list of 2 00:00:02,900 --> 00:00:05,840 all the subjects they teach at Jefferson Middle School. 3 00:00:05,840 --> 00:00:08,850 So pause me and go ahead and watch the SQL Playground. 4 00:00:08,850 --> 00:00:10,960 It includes the database we'll be working with and 5 00:00:10,960 --> 00:00:12,860 is where you'll be writing your queries. 6 00:00:12,860 --> 00:00:15,370 Once you've written the query, unpause the video and 7 00:00:15,370 --> 00:00:16,770 I'll show you how I solved the problem. 8 00:00:18,580 --> 00:00:19,290 Okay, so 9 00:00:19,290 --> 00:00:23,270 we need to figure out which subjects are taught at Jefferson Middle School. 10 00:00:23,270 --> 00:00:27,000 To start, we first need to figure out which table we need to use. 11 00:00:27,000 --> 00:00:29,680 For this one, it's pretty clear that we need to use the SUBJECTS table. 12 00:00:31,120 --> 00:00:34,920 So, let's start by selecting everything, 13 00:00:34,920 --> 00:00:38,120 which is represented as a star, and from the SUBJECTS table. 14 00:00:39,960 --> 00:00:42,846 Then let's add a semicolon to end the statement, and 15 00:00:42,846 --> 00:00:44,586 you use shift-enter to run it. 16 00:00:44,586 --> 00:00:47,314 And there we go, all the subjects that are taught at Jefferson Middle School.