Bummer! You have been redirected as the page you requested could not be found.
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 teachers sorted alphabetically.
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
Also, we'd like to only see the first and
last names of each teacher.
0:00
For this question,
0:04
we wanna get a list of all the teachers
sorted alphabetically by last name.
0:05
And we only wanna show the first and
last names.
0:09
So first, let's check out the teacher's
table to see what those columns are named.
0:12
Okay, it looks like,
just like the student's table,
0:17
it's named first name, and last name.
0:20
So, back in the query,
let's select FIRST_NAME and
0:23
LAST_NAME from the teachers table.
0:29
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