the Shore to Shore Shipping case study for SQL

1 Find all manufacturers who have built fewer than 2 ships that have shipped Concrete Forms and have never shipped Toyota Camrys.

2.List out the total of each item carried by a shipment piloted by each captain/

3.For each month of 2016, show the total items shipped as well as the total number of items shipped in each month as well as the total number shipped in the prior month.

Lname ———– Fname ——- Description

Smith ———— John ——— Concrete Forms

Smith ————- John ———– Toyota Camry

table