Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed SQL Reporting by Example!
You have completed SQL Reporting by Example!
Preview
Which students have last names starting with 'A'?
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
For this query,
we're getting back to the students table.
0:00
So let's start by selecting all of
the students, SELECT * FROM STUDENTS.
0:01
Then we need to add
a where clause to give us
0:07
only the students with last
names starting with A.
0:10
So let's add WHERE, and
then the last name column.
0:13
And all that's left is we need
to find a way to filter this
0:17
to only show the last
names starting with A.
0:19
To do this, we can use the LIKE keyword.
0:22
And we wanna show last names
that are like the following, A%.
0:26
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