Part 2 – Construct your Warehouse SQL
Part 2 – Construct your Warehouse SQL statements
This is where you start to turn things in. To turn in your assignment, delete the preceding pages and start with this one. Make sure to put your name up top.
Construct SQL to answer each of the following questions. For each query, paste your SQL code below, and also paste a screenshot of the first 10 or so rows the query gives you.
Give an answer to the question based only on what you see in your MySQL database. (Do not use Excel or other tools to answer these questions; since we are trying to learn MySQL here, you should do these exercises in MySQL.)
You will eventually submit this document as part of your week’s homework.
After you have completed your first draft of this document, you will use the online quiz to verify your answers. The online quiz uses the same numbering system given here, so you can quickly find the question you need.
You are welcome to update your homework document with results from the online quiz, and submit the homework document after you’ve checked your homework online.
1. [SQL Week 2 Question 200-501] For every shipment in the shipment table, you want to know its shipment details, the customer information, and the employee information.
a. Include exactly and only all the records for which a shipment ID exists.
b. Sort it ascending by Scantag.
c. Your output should look a little like this. Note the “shipment information” will be in the form of several distinct columns. (Hint: look up the “ Select * ” command to select several columns at once.)