Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Preview
Start a free Courses 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
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