A. Show the Shipper Name, Shipment ID, and Departure Date of all shipments that have an item that was purchased in Singapore. Use a join using JOIN ON syntax. Present results sorted by Shipper Name in...

A. Show the Shipper Name, Shipment ID, and Departure Date of all shipments that have an item that was purchased in Singapore. Use a join using JOIN ON syntax. Present results sorted by Shipper Name in ascending order and then Departure Date in descending order.

B. Show the Shipper Name, Shipment ID, the Departure Date of the shipment, and Value for items that were purchased in Singapore. Use a combination of a join and a sub query. Present results sorted by Shipper Name in ascending order and then Departure Date in descending order.

C. Show the Shipper Name, Shipment ID, the Departure Date of the shipment, and Value for items that were purchased in Singapore. Also show the Shipper Name, Shipment ID, and Departure Date for all other shipments. Present results sorted by Value in ascending order, then Shipper Name in ascending order, and then Departure Date in descending order.