Finding the ID0:43 with Ben Deitch
What's Yvette Levy's student ID number?
This video doesn't have any notes.
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