The Solutions2:05 with Andrew Chalkley
Here are some examples of ways to solve the challenges.
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