Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll

Practice Column Selection and Aliasing with SQL

Well done!

You have completed Practice Column Selection and Aliasing with SQL!

Sign up for Treehouse Back to Library

The Solutions

2:05 with Andrew Chalkley

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 up

    Related Discussions

    Have questions about this video? Start a discussion with the community and Treehouse staff.

    Sign up

    How did you do? Don't worry if you struggled or 0:00
    failed to complete any of the tasks. 0:03
    Here are my solutions. 0:05
    Compare them with your SQL statements. 0:06
    It doesn't matter if they're slightly different. 0:09
    Often there are a number of ways you can do the same thing in SQL. 0:11
    challenge one was to select all information from the products table. 0:15
    This is a simple select star, meaning all columns from the products table. 0:19
    Challenge two, was to create a mailing list for emailing customers. 0:26
    I did this by selecting the first name, the last name, and 0:30
    email columns from the customers table. 0:35
    Now the marketing department can send emails to all of our customers and 0:38
    personalize it with their names. 0:42
    Challenge three was to create a physical mailing list for all the customers. 0:45
    Instead of the email column, we have the columns street, 0:50
    city, state, zip, and country. 0:53
    This way the marketing department can send out mailers with coupons in. 0:58
    Challenge four, was to get the names and 1:02
    addresses from all the sales to create labels for packing up the orders. 1:04
    I did this by selecting the customer name and 1:09
    the delivery address columns from the sales table. 1:12
    The final challenge was to select all relevant information from the sales table 1:16
    and practice a-listing the column names to be something more friendly for 1:21
    the report reader. 1:25
    I selected the item name, the price at the time of sale, 1:27
    and the sale_date. 1:31
    I then used the AS key words with the aliases to give it a user friendly name. 1:34
    I hope you were able to complete this practice session successfully and 1:45
    create similar reports. 1:48
    If not why not reset each of the coding area in the SQL playground and 1:50
    start again without looking at my solutions. 1:55
    It's okay if we need more practice doing a few more times will help you memorize 1:57
    the SQL syntax. 2:01
    Keep up the good work and I'll see you again. 2:03

    You need to sign up for Treehouse in order to download course files.

    Sign up

      You need to sign up for Treehouse in order to set up Workspace

      Sign up