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
Generate a list of students with last names from A to M.
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
If you could get a list of students
with last names from A to M,
0:00
that would be really helpful.
0:01
For this query, let's start by
selecting a list of all the students.
0:04
SELECT* FROM STUDENTS.
0:08
Then, lets add a WHERE clause.
0:10
And in this WHERE clause,
0:12
we need to limit our students to only
the ones with last names from A to M.
0:13
But before we do that,
I'm gonna real quick add the ORDER BY and
0:18
we want to do it by LAST_NAME ASCENDING.
0:22
Okay, getting back to the WHERE clause,
if you google for
0:25
this answer,
one thing you might come across is this.
0:27
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