7th Grade Science1:57 with Ben Deitch
Which teacher teaches 7th grade science?
Great, he's just ordered them all a fruit basket. 0:00 Also, the principal has been hearing some really good things 0:03 about the new seventh grade science teacher. 0:06 Can you figure out who teaches seventh grade science so 0:08 he can get them a fruit basket too? 0:10 >> This query is gonna be pretty similar to the last one. 0:13 So to make it seem a little different, I'm going to do this from 0:16 the perspective of the subjects table instead of the teachers table. 0:19 So let's start by selecting everything from the subjects table and 0:23 then join to the classes table. 0:28 And we'll join it on SUBJECTS.ID = CLASSES.SUBJECT_ID. 0:30 Then from here, we'll need to 0:37 JOIN TEACHERS ON TEACHERS.ID = CLASSES.TEACHER_ID. 0:41 Then in the where clause we need to make sure that we're only looking at seventh 0:49 grade science classes, and that information is in the subjects table. 0:54 So WHERE, and 0:58 let's look in the subjects table to see what those columns are called. 0:59 And so we're going to say subjects name is equal to science. 1:03 And subject's grade is equal to seven. 1:08 So WHERE NAME = 'Science' AND 1:11 GRADE = 7. 1:19 And it looks like you need to have a FROM keyword. 1:22 And that’s true, you need to have the FROM keyword. 1:25 And it needs to be before the table that you’re selecting from. 1:30 And then just like the last table, we'll wanna bring in the distinct keyword on 1:37 the ID, and select just the first and last name columns. 1:41 And remember, we wanna use the teacher's ID column and 1:44 then first name and last name, and there we go. 1:49 Isabella Little is the 7th grade science teacher. 1:54
You need to sign up for Treehouse in order to download course files.Sign up