Question
10. Show the ShipperName and DepartureDate of all shipments that have an item that was purchased in Singapore. Use a (inner) join. Present the results
10. Show the ShipperName and DepartureDate of all shipments that have an item that was purchased in Singapore. Use a (inner) join. Present the results sorted by ShipperName in ascending order and then DepartureDate in descending order.
11. Show the ShipperName, DepartureDate of shipment, and Value for items greater than or equal to $1500 and were purchased in Singapore. Use a combination of (inner) join and subquery. Present the results sorted by ShipperName in ascending order and then DepartureDate in descending order.
12. List the ShipmentID, ShipperName, and ShipperInvoiceNumber of all shipments.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started