WK 2 – DATA 620 QUIZ 2.5B
WK 2 – DATA 620 QUIZ 2.5B – Multi-Table SQL Queries
SQL Week 2 Assignment 2.5B Questions
Question 1 (1 point)
Question 1 options:
[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. Include exactly and only all the records for which a shipment ID exists. Sort it ascending by Scantag.
What is the idShipment of your first record?
What is the idCustomer of the first row returned?
What is the first name (EmpFirstName) of the employee in the first row returned?
(Make sure to type the first name only.)