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 Practice Column Selection and Aliasing with SQL!
You have completed Practice Column Selection and Aliasing with SQL!
Preview
Here are some examples of ways to solve the challenges.
Please Provide Feedback
We’re looking for feedback on this new type of practice workshop. When you’re finished, could you please review the workshop by filling out this short form?
Course
Resources
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
Compare them with your SQL statements.
0:00
It doesn't matter if
they're slightly different.
0:00
Often there are a number of ways
you can do the same thing in SQL.
0:02
challenge one was to select all
information from the products table.
0:06
This is a simple select star, meaning
all columns from the products table.
0:10
Challenge two, was to create a mailing
list for emailing customers.
0:17
I did this by selecting the first name,
the last name, and
0:21
email columns from the customers table.
0:26
Now the marketing department can send
emails to all of our customers and
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