Use the Shore to Shore Shipping Case Study to write the following queries:

List all shipments that contained Building Materials, arrived in London and had either Cliff Walker or John Smith as the captain.

List all captains who were captains of shipments that left Boston on or after 2011

List all items shipped out of Seattle as well as the weight of each item

List all ships that have ever carried rice.

List all captains who were captains of shipments that carried rice

List all captains who were captains of ships that carried rice. The captain may not necessarily been the captain of the shipment that carried the rice

For each origin, display the origin as well as the number of unique captains who have been captains of shipments which left that port.

Relationships for shoretoshore ship no SHIP NO SHIPMENT_DATE ORIGIN grade ufacturer id ARRIVAL DATE manufacturer Manufacturer ID Name SHIPMENT ID ITEM NO QUANTITY DESTINATION DAYS Bid Preference item no type weight Relationships for shoretoshore ship no SHIP NO SHIPMENT_DATE ORIGIN grade ufacturer id ARRIVAL DATE manufacturer Manufacturer ID Name SHIPMENT ID ITEM NO QUANTITY DESTINATION DAYS Bid Preference item no type weight