Deliverables
• Lab Report( Answer Sheet) containing both the student-created SQL command( s) for each exercise, and the output showing the results obtained. Be sure your name is on the file.
LAB STEPS: Complete each of the exercises below:
1. Use the JOIN ON syntax to write a query to display the order id, order date, customer name formatted as a single field( i. e. ― Tom Jones ‖) with a heading of Customer, and customer _ city for customers residing in the state of OHIO. Sort the output to display the newest orders first.
2. Use the JOIN USING syntax to display the order _ id, order date, and shipdate for orders to Karina Lacy that have shipped.
3. Use the implicit join syntax( the WHERE clause) to display the last name, city, order date and ship date for all orders shipped in 2012.
4. Use any join syntax EXCEPT NATURAL JOIN to list the customer _ first _ name and customer _ last _ name concatenated with an intervening space as Customer, customer city and state formatted as a single column in the format of ― city, ST ‖ with a heading of Location, order _ id and order date for orders that have not shipped.
5. List the customer name, order date, zipcode for any customer( s) placing an order for the item titled ‗ Etcetera ‖.
6. Write a query to list the title and artist of ONLY the items that have been ordered. Only list each title once.
7. Write a query to list the title and price of all items that have been ordered by customer Millerton.