Lab 11

 Objective

SQL Script required → LAB SQL Script

Using some of the SQL commands you have learned, create a SQL statement to answer the following questions. Once you have created the SQL command, copy and paste your Query and results and submit via a word document (copy-paste results)

Using the Customers table of sql_store

1. Use the SQL command to join orders table on order_statuses table. (Note - accomplish the join on the order.status = order_status_id).

2. Use the SQL command to join orders table on customer table.

3. Limit the attributes of the second query only to show the order-date, ship_date, first-name, last-name in your results.