How did you do? Don't worry if you struggled or

failed to complete any of the tasks.

Here are my solutions.

Compare them with your SQL statements.

It doesn't matter if they're slightly different.

Often there are a number of ways you can do the same thing in SQL.

challenge one was to select all information from the products table.

This is a simple select star, meaning all columns from the products table.

Challenge two, was to create a mailing list for emailing customers.

I did this by selecting the first name, the last name, and

email columns from the customers table.

Now the marketing department can send emails to all of our customers and

personalize it with their names.

Challenge three was to create a physical mailing list for all the customers.

Instead of the email column, we have the columns street,

city, state, zip, and country.

This way the marketing department can send out mailers with coupons in.

Challenge four, was to get the names and

addresses from all the sales to create labels for packing up the orders.

I did this by selecting the customer name and

the delivery address columns from the sales table.

The final challenge was to select all relevant information from the sales table

and practice a-listing the column names to be something more friendly for

the report reader.

I selected the item name, the price at the time of sale,

and the sale_date.

I then used the AS key words with the aliases to give it a user friendly name.

I hope you were able to complete this practice session successfully and

create similar reports.

If not why not reset each of the coding area in the SQL playground and

start again without looking at my solutions.

It's okay if we need more practice doing a few more times will help you memorize

the SQL syntax.

Keep up the good work and I'll see you again.