Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Based on the SHIPMENT table, list the ShipmentID, ShipperName, and ShipperInvoiceNumber of all shippers whose name starts with AB. Based on the ITEM table, show
- Based on the SHIPMENT table, list the ShipmentID, ShipperName, and ShipperInvoiceNumber of all shippers whose name starts with AB.
- Based on the ITEM table, show ItemID, Description, Store, and a calculated column named StdCurrencyAmount that is equal to LocalCurrencyAmt times the ExchangeRate for all the items purchased from Singapore,.
- Based on the SHIPMENT table, calculate and report the total amount of InsuredValue for each Shipper. Present results sorted by the total amount of InsuredValue in ascending order.
- Show the ShipmentID, ShipperName, and DepartureDate of all shipments that have an item with a value of 5,000 or more. Use a subquery. Present results sorted by ShipperName in ascending order and then DepartureDate in descending order.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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