Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Preview
Start a free Courses trial
to watch this video
What's Yvette Levy's student ID number?
This video doesn't have any notes.
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
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 upYou need to sign up for Treehouse in order to set up Workspace
Sign up