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