Finding the ID0:43 with Ben Deitch
What's Yvette Levy's student ID number?
You're doing great. 0:00 Just three more to go. 0:01 Can you tell me Yvette Levy's student ID number? 0:03 For starters, Yvette Levy is a student. 0:06 So we'll need to use the student's table. 0:09 Let's start by selecting everything from the student's table. 0:11 Then, let's add WHERE clause, and let's make sure that the FIRST_NAME, 0:16 Which is a column in the student's table, is = to Yvette. 0:22 And let's make sure that the LAST_NAME, 0:27 which is another column in the student's table, is = to Levy. 0:30 Then let's run the query. 0:37 And it looks like our ID is 10509. 0:39
You need to sign up for Treehouse in order to download course files.Sign up