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