Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.
Finding the ID0:43 with Ben Deitch
What's Yvette Levy's student ID number?
You're doing great.
Just three more to go.
Can you tell me Yvette Levy's student ID number?
For starters, Yvette Levy is a student.
So we'll need to use the student's table.
Let's start by selecting everything from the student's table.
Then, let's add WHERE clause, and let's make sure that the FIRST_NAME,
Which is a column in the student's table, is = to Yvette.
And let's make sure that the LAST_NAME,
which is another column in the student's table, is = to Levy.
Then let's run the query.
And it looks like our ID is 10509.
You need to sign up for Treehouse in order to download course files.Sign up