1 00:00:00,400 --> 00:00:03,020 How did you do? Don't worry if you struggled or 2 00:00:03,020 --> 00:00:05,270 failed to complete any of the tasks. 3 00:00:05,270 --> 00:00:06,880 Here are my solutions. 4 00:00:06,880 --> 00:00:09,050 Compare them with your SQL statements. 5 00:00:09,050 --> 00:00:11,240 It doesn't matter if they're slightly different. 6 00:00:11,240 --> 00:00:15,100 Often there are a number of ways you can do the same thing in SQL. 7 00:00:15,100 --> 00:00:19,370 challenge one was to select all information from the products table. 8 00:00:19,370 --> 00:00:26,000 This is a simple select star, meaning all columns from the products table. 9 00:00:26,000 --> 00:00:30,140 Challenge two, was to create a mailing list for emailing customers. 10 00:00:30,140 --> 00:00:35,200 I did this by selecting the first name, the last name, and 11 00:00:35,200 --> 00:00:38,300 email columns from the customers table. 12 00:00:38,300 --> 00:00:42,350 Now the marketing department can send emails to all of our customers and 13 00:00:42,350 --> 00:00:43,890 personalize it with their names. 14 00:00:45,420 --> 00:00:49,140 Challenge three was to create a physical mailing list for all the customers. 15 00:00:50,220 --> 00:00:53,965 Instead of the email column, we have the columns street, 16 00:00:53,965 --> 00:00:58,320 city, state, zip, and country. 17 00:00:58,320 --> 00:01:02,590 This way the marketing department can send out mailers with coupons in. 18 00:01:02,590 --> 00:01:04,770 Challenge four, was to get the names and 19 00:01:04,770 --> 00:01:09,100 addresses from all the sales to create labels for packing up the orders. 20 00:01:09,100 --> 00:01:12,960 I did this by selecting the customer name and 21 00:01:12,960 --> 00:01:16,680 the delivery address columns from the sales table. 22 00:01:16,680 --> 00:01:21,470 The final challenge was to select all relevant information from the sales table 23 00:01:21,470 --> 00:01:25,390 and practice a-listing the column names to be something more friendly for 24 00:01:25,390 --> 00:01:27,010 the report reader. 25 00:01:27,010 --> 00:01:31,498 I selected the item name, the price at the time of sale, 26 00:01:31,498 --> 00:01:34,720 and the sale_date. 27 00:01:34,720 --> 00:01:41,340 I then used the AS key words with the aliases to give it a user friendly name. 28 00:01:45,190 --> 00:01:48,730 I hope you were able to complete this practice session successfully and 29 00:01:48,730 --> 00:01:50,335 create similar reports. 30 00:01:50,335 --> 00:01:55,125 If not why not reset each of the coding area in the SQL playground and 31 00:01:55,125 --> 00:01:57,615 start again without looking at my solutions. 32 00:01:57,615 --> 00:02:01,865 It's okay if we need more practice doing a few more times will help you memorize 33 00:02:01,865 --> 00:02:03,535 the SQL syntax. 34 00:02:03,535 --> 00:02:05,505 Keep up the good work and I'll see you again.