Preppin Data Challenge - Week 7, Sql Server

Preppin Data Challenge - Week 7

-- prepare input data tables for PreppinChallenge Week 7
CREATE TABLE W7_DepartureDetails(ShipID NVARCHAR(20), DepartureDate DATE, MaxWeight INT, MaxVolume INT)

INSERT INTO W7_DepartureDetails
SELECT ShipID, DepartureDate, MaxWeight, MaxVolume FROM 
(
    SELECT 'Freighter-01' AS ShipID, '4/6/2019' AS DepartureDate, '5000' AS MaxWeight, '500' AS MaxVolume UNION ALL 
    SELECT 'Freighter-01' AS ShipID, '6/18/2019' AS DepartureDate, '5000' AS MaxWeight, '500' AS MaxVolume UNION ALL 
    SELECT 'Freighter-02' AS ShipID, '4/10/2019' AS DepartureDate, '5000' AS MaxWeight, '500' AS MaxVolume UNION ALL 
    SELECT 'Freighter-02' AS ShipID, '4/19/2019' AS DepartureDate, '5000' AS MaxWeight, '500' AS MaxVolume UNION ALL 
    SELECT 'Freighter-02' AS ShipID, '5/26/2019' AS DepartureDate, '5000' AS MaxWeight, '500' AS MaxVolume UNION ALL 
    SELECT 'Freighter-02' AS ShipID, '6/3/2019' AS DepartureDate, '5000' AS MaxWeight, '500' AS MaxVolume UNION ALL 
    SELECT 'Freighter-02' AS ShipID, '6/11/2019' AS DepartureDate, '5000' AS MaxWeight, '500' AS MaxVolume UNION ALL 
    SELECT 'Freighter-03' AS ShipID, '4/1/2019' AS DepartureDate, '5000' AS MaxWeight, '500' AS MaxVolume UNION ALL 
    SELECT 'Freighter-03' AS ShipID, '4/10/2019' AS DepartureDate, '5000' AS MaxWeight, '500' AS MaxVolume UNION ALL 
    SELECT 'Freighter-04' AS ShipID, '3/31/2019' AS DepartureDate, '5000' AS MaxWeight, '500' AS MaxVolume UNION ALL 
    SELECT 'Freighter-04' AS ShipID, '4/12/2019' AS DepartureDate, '5000' AS MaxWeight, '500' AS MaxVolume UNION ALL 
    SELECT 'Freighter-04' AS ShipID, '4/27/2019' AS DepartureDate, '5000' AS MaxWeight, '500' AS MaxVolume UNION ALL 
    SELECT 'Freighter-04' AS ShipID, '5/26/2019' AS DepartureDate, '5000' AS MaxWeight, '500' AS MaxVolume UNION ALL 
    SELECT 'Freighter-04' AS ShipID, '6/19/2019' AS DepartureDate, '5000' AS MaxWeight, '500' AS MaxVolume UNION ALL 
    SELECT 'Freighter-05' AS ShipID, '5/23/2019' AS DepartureDate, '5000' AS MaxWeight, '500' AS MaxVolume UNION ALL 
    SELECT 'Freighter-05' AS ShipID, '5/26/2019' AS DepartureDate, '5000' AS MaxWeight, '500' AS MaxVolume UNION ALL 
    SELECT 'Freighter-05' AS ShipID, '6/6/2019' AS DepartureDate, '5000' AS MaxWeight, '500' AS MaxVolume UNION ALL 
    SELECT 'Freighter-05' AS ShipID, '6/10/2019' AS DepartureDate, '5000' AS MaxWeight, '500' AS MaxVolume UNION ALL 
    SELECT 'Freighter-05' AS ShipID, '6/19/2019' AS DepartureDate, '5000' AS MaxWeight, '500' AS MaxVolume UNION ALL 
    SELECT 'Freighter-05' AS ShipID, '6/26/2019' AS DepartureDate, '5000' AS MaxWeight, '500' AS MaxVolume UNION ALL 
    SELECT 'Tanker-01' AS ShipID, '5/11/2019' AS DepartureDate, '1000' AS MaxWeight, '200' AS MaxVolume UNION ALL 
    SELECT 'Tanker-01' AS ShipID, '5/12/2019' AS DepartureDate, '1000' AS MaxWeight, '200' AS MaxVolume UNION ALL 
    SELECT 'Tanker-01' AS ShipID, '6/4/2019' AS DepartureDate, '1000' AS MaxWeight, '200' AS MaxVolume UNION ALL 
    SELECT 'Tanker-02' AS ShipID, '4/7/2019' AS DepartureDate, '1000' AS MaxWeight, '200' AS MaxVolume UNION ALL 
    SELECT 'Tanker-02' AS ShipID, '6/11/2019' AS DepartureDate, '1000' AS MaxWeight, '200' AS MaxVolume UNION ALL 
    SELECT 'Tanker-03' AS ShipID, '4/30/2019' AS DepartureDate, '1000' AS MaxWeight, '200' AS MaxVolume UNION ALL 
    SELECT 'Tanker-04' AS ShipID, '4/10/2019' AS DepartureDate, '1000' AS MaxWeight, '200' AS MaxVolume UNION ALL 
    SELECT 'Tanker-04' AS ShipID, '4/21/2019' AS DepartureDate, '1000' AS MaxWeight, '200' AS MaxVolume UNION ALL 
    SELECT 'Tanker-04' AS ShipID, '4/27/2019' AS DepartureDate, '1000' AS MaxWeight, '200' AS MaxVolume UNION ALL 
    SELECT 'Tanker-04' AS ShipID, '6/27/2019' AS DepartureDate, '1000' AS MaxWeight, '200' AS MaxVolume UNION ALL 
    SELECT 'Tanker-05' AS ShipID, '5/2/2019' AS DepartureDate, '1000' AS MaxWeight, '200' AS MaxVolume UNION ALL 
    SELECT 'Tanker-05' AS ShipID, '5/3/2019' AS DepartureDate, '1000' AS MaxWeight, '200' AS MaxVolume UNION ALL 
    SELECT 'Tanker-05' AS ShipID, '5/4/2019' AS DepartureDate, '1000' AS MaxWeight, '200' AS MaxVolume UNION ALL 
    SELECT 'Tanker-05' AS ShipID, '5/20/2019' AS DepartureDate, '1000' AS MaxWeight, '200' AS MaxVolume UNION ALL 
    SELECT 'Tanker-05' AS ShipID, '5/27/2019' AS DepartureDate, '1000' AS MaxWeight, '200' AS MaxVolume UNION ALL 
    SELECT 'Tanker-05' AS ShipID, '6/8/2019' AS DepartureDate, '1000' AS MaxWeight, '200' AS MaxVolume UNION ALL 
    SELECT 'Tanker-05' AS ShipID, '6/17/2019' AS DepartureDate, '1000' AS MaxWeight, '200' AS MaxVolume UNION ALL 
    SELECT 'Tug-01' AS ShipID, '4/23/2019' AS DepartureDate, '500' AS MaxWeight, '50' AS MaxVolume UNION ALL 
    SELECT 'Tug-01' AS ShipID, '4/29/2019' AS DepartureDate, '500' AS MaxWeight, '50' AS MaxVolume UNION ALL 
    SELECT 'Tug-01' AS ShipID, '4/30/2019' AS DepartureDate, '500' AS MaxWeight, '50' AS MaxVolume UNION ALL 
    SELECT 'Tug-01' AS ShipID, '6/4/2019' AS DepartureDate, '500' AS MaxWeight, '50' AS MaxVolume UNION ALL 
    SELECT 'Tug-01' AS ShipID, '6/7/2019' AS DepartureDate, '500' AS MaxWeight, '50' AS MaxVolume UNION ALL 
    SELECT 'Tug-01' AS ShipID, '6/13/2019' AS DepartureDate, '500' AS MaxWeight, '50' AS MaxVolume UNION ALL 
    SELECT 'Tug-02' AS ShipID, '4/25/2019' AS DepartureDate, '500' AS MaxWeight, '50' AS MaxVolume UNION ALL 
    SELECT 'Tug-02' AS ShipID, '5/11/2019' AS DepartureDate, '500' AS MaxWeight, '50' AS MaxVolume UNION ALL 
    SELECT 'Tug-03' AS ShipID, '4/14/2019' AS DepartureDate, '500' AS MaxWeight, '50' AS MaxVolume UNION ALL 
    SELECT 'Tug-03' AS ShipID, '4/15/2019' AS DepartureDate, '500' AS MaxWeight, '50' AS MaxVolume UNION ALL 
    SELECT 'Tug-03' AS ShipID, '4/17/2019' AS DepartureDate, '500' AS MaxWeight, '50' AS MaxVolume UNION ALL 
    SELECT 'Tug-03' AS ShipID, '5/4/2019' AS DepartureDate, '500' AS MaxWeight, '50' AS MaxVolume UNION ALL 
    SELECT 'Tug-04' AS ShipID, '5/3/2019' AS DepartureDate, '500' AS MaxWeight, '50' AS MaxVolume UNION ALL 
    SELECT 'Tug-04' AS ShipID, '6/11/2019' AS DepartureDate, '500' AS MaxWeight, '50' AS MaxVolume UNION ALL 
    SELECT 'Tug-04' AS ShipID, '6/12/2019' AS DepartureDate, '500' AS MaxWeight, '50' AS MaxVolume UNION ALL 
    SELECT 'Tug-04' AS ShipID, '6/18/2019' AS DepartureDate, '500' AS MaxWeight, '50' AS MaxVolume UNION ALL 
    SELECT 'Tug-04' AS ShipID, '6/21/2019' AS DepartureDate, '500' AS MaxWeight, '50' AS MaxVolume UNION ALL 
    SELECT 'Tug-05' AS ShipID, '3/27/2019' AS DepartureDate, '500' AS MaxWeight, '50' AS MaxVolume UNION ALL 
    SELECT 'Tug-05' AS ShipID, '4/10/2019' AS DepartureDate, '500' AS MaxWeight, '50' AS MaxVolume UNION ALL 
    SELECT 'Tug-05' AS ShipID, '5/22/2019' AS DepartureDate, '500' AS MaxWeight, '50' AS MaxVolume UNION ALL 
    SELECT 'Tug-05' AS ShipID, '5/26/2019' AS DepartureDate, '500' AS MaxWeight, '50' AS MaxVolume
) As d1

CREATE TABLE W7_AllocationDetails(Salesperson NVARCHAR(50), DepartureID NVARCHAR(50), DateLogged DATE, ProductType NVARCHAR(50),
                                  WeightAllocated INT, VolumeAllocated INT)
                               
INSERT INTO W7_AllocationDetails                               
SELECT Salesperson, DepartureID, DateLogged, ProductType, WeightAllocated, VolumeAllocated FROM
(
    SELECT 'Daisy Steiner' AS Salesperson, 'Tanker-05-04-05-2019' AS DepartureID, '2/21/2019' AS DateLogged, 'Spurs Jerseys' AS ProductType, '111' AS WeightAllocated, '10' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Freighter-01-18-06-2019' AS DepartureID, '1/14/2019' AS DateLogged, 'Phone Catalogues' AS ProductType, '756' AS WeightAllocated, '48' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tanker-04-27-04-2019' AS DepartureID, '1/26/2019' AS DateLogged, 'Oil' AS ProductType, '220' AS WeightAllocated, '28' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Freighter-02-10-04-2019' AS DepartureID, '3/11/2019' AS DateLogged, 'Rubber Ducks' AS ProductType, '536' AS WeightAllocated, '20' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tanker-05-20-05-2019' AS DepartureID, '1/27/2019' AS DateLogged, 'Vinyl Records' AS ProductType, '148' AS WeightAllocated, '30' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tanker-05-03-05-2019' AS DepartureID, '2/22/2019' AS DateLogged, 'Legumes' AS ProductType, '221' AS WeightAllocated, '10' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tanker-05-08-06-2019' AS DepartureID, '1/17/2019' AS DateLogged, 'Tiny Violins' AS ProductType, '68' AS WeightAllocated, '2' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tug-01-29-04-2019' AS DepartureID, '1/13/2019' AS DateLogged, 'University Textbooks' AS ProductType, '99' AS WeightAllocated, '10' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tug-04-18-06-2019' AS DepartureID, '2/11/2019' AS DateLogged, 'Rubber Ducks' AS ProductType, '61' AS WeightAllocated, '7' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tug-04-12-06-2019' AS DepartureID, '2/4/2019' AS DateLogged, 'C&BS Co Soap' AS ProductType, '95' AS WeightAllocated, '1' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tug-04-18-06-2019' AS DepartureID, '1/11/2019' AS DateLogged, 'Shipping Containers' AS ProductType, '43' AS WeightAllocated, '10' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tanker-05-04-05-2019' AS DepartureID, '4/25/2019' AS DateLogged, 'Tiny Violins' AS ProductType, '61' AS WeightAllocated, '36' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Freighter-04-12-04-2019' AS DepartureID, '2/20/2019' AS DateLogged, 'White Goods' AS ProductType, '432' AS WeightAllocated, '72' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tug-01-04-06-2019' AS DepartureID, '2/25/2019' AS DateLogged, 'Tiny Violins' AS ProductType, '87' AS WeightAllocated, '5' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tanker-01-04-06-2019' AS DepartureID, '3/28/2019' AS DateLogged, 'Motor vehicles' AS ProductType, '91' AS WeightAllocated, '20' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Freighter-02-11-06-2019' AS DepartureID, '2/26/2019' AS DateLogged, 'DM Paper' AS ProductType, '888' AS WeightAllocated, '82' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tanker-05-20-05-2019' AS DepartureID, '2/26/2019' AS DateLogged, 'Vinyl Records' AS ProductType, '218' AS WeightAllocated, '40' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Freighter-03-01-04-2019' AS DepartureID, '3/3/2019' AS DateLogged, 'Sneakers' AS ProductType, '396' AS WeightAllocated, '34' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Freighter-02-10-04-2019' AS DepartureID, '3/9/2019' AS DateLogged, 'Oil' AS ProductType, '252' AS WeightAllocated, '54' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tug-05-22-05-2019' AS DepartureID, '1/17/2019' AS DateLogged, 'Oil' AS ProductType, '22' AS WeightAllocated, '7' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Freighter-05-26-06-2019' AS DepartureID, '3/11/2019' AS DateLogged, 'C&BS Co Soap' AS ProductType, '252' AS WeightAllocated, '82' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tug-02-25-04-2019' AS DepartureID, '3/5/2019' AS DateLogged, 'Gold Bullion' AS ProductType, '27' AS WeightAllocated, '12' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Freighter-04-19-06-2019' AS DepartureID, '2/12/2019' AS DateLogged, 'Phone Catalogues' AS ProductType, '872' AS WeightAllocated, '70' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tug-05-27-03-2019' AS DepartureID, '1/3/2019' AS DateLogged, 'Spices' AS ProductType, '42' AS WeightAllocated, '9' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tug-05-22-05-2019' AS DepartureID, '3/21/2019' AS DateLogged, 'University Textbooks' AS ProductType, '44' AS WeightAllocated, '3' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Freighter-02-26-05-2019' AS DepartureID, '3/12/2019' AS DateLogged, 'Oil' AS ProductType, '280' AS WeightAllocated, '44' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tug-03-14-04-2019' AS DepartureID, '2/26/2019' AS DateLogged, 'Spurs Jerseys' AS ProductType, '35' AS WeightAllocated, '5' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tug-05-27-03-2019' AS DepartureID, '3/29/2019' AS DateLogged, 'Spurs Jerseys' AS ProductType, '21' AS WeightAllocated, '4' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tug-05-22-05-2019' AS DepartureID, '3/27/2019' AS DateLogged, 'Livestock' AS ProductType, '56' AS WeightAllocated, '11' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tanker-02-07-04-2019' AS DepartureID, '1/11/2019' AS DateLogged, 'DVD Boxsets' AS ProductType, '239' AS WeightAllocated, '24' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tug-02-25-04-2019' AS DepartureID, '3/8/2019' AS DateLogged, 'University Textbooks' AS ProductType, '27' AS WeightAllocated, '5' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Freighter-01-18-06-2019' AS DepartureID, '4/2/2019' AS DateLogged, 'Phone Catalogues' AS ProductType, '980' AS WeightAllocated, '94' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tanker-04-21-04-2019' AS DepartureID, '2/15/2019' AS DateLogged, 'Timber' AS ProductType, '216' AS WeightAllocated, '34' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tug-04-18-06-2019' AS DepartureID, '4/13/2019' AS DateLogged, 'Spices' AS ProductType, '74' AS WeightAllocated, '8' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tanker-05-03-05-2019' AS DepartureID, '3/4/2019' AS DateLogged, 'Livestock' AS ProductType, '188' AS WeightAllocated, '2' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tug-03-14-04-2019' AS DepartureID, '1/7/2019' AS DateLogged, 'University Textbooks' AS ProductType, '4' AS WeightAllocated, '12' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Freighter-03-10-04-2019' AS DepartureID, '2/17/2019' AS DateLogged, 'Oil' AS ProductType, '864' AS WeightAllocated, '46' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tug-01-30-04-2019' AS DepartureID, '1/18/2019' AS DateLogged, 'Sneakers' AS ProductType, '14' AS WeightAllocated, '1' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Freighter-02-10-04-2019' AS DepartureID, '3/2/2019' AS DateLogged, 'Cheese' AS ProductType, '524' AS WeightAllocated, '48' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tug-04-03-05-2019' AS DepartureID, '1/12/2019' AS DateLogged, 'Legumes' AS ProductType, '85' AS WeightAllocated, '6' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tug-01-13-06-2019' AS DepartureID, '3/13/2019' AS DateLogged, 'Luxury Goods' AS ProductType, '61' AS WeightAllocated, '6' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tug-03-14-04-2019' AS DepartureID, '4/19/2019' AS DateLogged, 'Shipping Containers' AS ProductType, '68' AS WeightAllocated, '12' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Freighter-03-10-04-2019' AS DepartureID, '3/16/2019' AS DateLogged, 'C&BS Co Soap' AS ProductType, '20' AS WeightAllocated, '90' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tug-01-13-06-2019' AS DepartureID, '3/8/2019' AS DateLogged, 'Phone Catalogues' AS ProductType, '4' AS WeightAllocated, '13' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Freighter-05-26-06-2019' AS DepartureID, '4/22/2019' AS DateLogged, 'Oil' AS ProductType, '780' AS WeightAllocated, '16' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Freighter-04-19-06-2019' AS DepartureID, '4/23/2019' AS DateLogged, 'DM Paper' AS ProductType, '268' AS WeightAllocated, '2' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Freighter-02-03-06-2019' AS DepartureID, '2/5/2019' AS DateLogged, 'Motor vehicles' AS ProductType, '516' AS WeightAllocated, '2' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Freighter-04-31-03-2019' AS DepartureID, '4/9/2019' AS DateLogged, 'Motor vehicles' AS ProductType, '444' AS WeightAllocated, '68' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tanker-05-03-05-2019' AS DepartureID, '1/19/2019' AS DateLogged, 'Shipping Containers' AS ProductType, '15' AS WeightAllocated, '36' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tanker-04-10-04-2019' AS DepartureID, '1/27/2019' AS DateLogged, 'Legumes' AS ProductType, '65' AS WeightAllocated, '24' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tanker-01-11-05-2019' AS DepartureID, '4/19/2019' AS DateLogged, 'Knickknacks' AS ProductType, '120' AS WeightAllocated, '22' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tug-01-29-04-2019' AS DepartureID, '4/12/2019' AS DateLogged, 'Oil' AS ProductType, '98' AS WeightAllocated, '5' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tug-04-03-05-2019' AS DepartureID, '4/5/2019' AS DateLogged, 'Spices' AS ProductType, '72' AS WeightAllocated, '11' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Freighter-02-19-04-2019' AS DepartureID, '3/4/2019' AS DateLogged, 'Motor vehicles' AS ProductType, '612' AS WeightAllocated, '62' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Freighter-01-18-06-2019' AS DepartureID, '3/9/2019' AS DateLogged, 'University Textbooks' AS ProductType, '200' AS WeightAllocated, '76' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tug-05-27-03-2019' AS DepartureID, '3/23/2019' AS DateLogged, 'Gold Bullion' AS ProductType, '77' AS WeightAllocated, '4' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Freighter-05-10-06-2019' AS DepartureID, '1/1/2019' AS DateLogged, 'Legumes' AS ProductType, '568' AS WeightAllocated, '60' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tug-01-30-04-2019' AS DepartureID, '3/12/2019' AS DateLogged, 'Cheese' AS ProductType, '42' AS WeightAllocated, '10' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tug-05-27-03-2019' AS DepartureID, '4/15/2019' AS DateLogged, 'Spurs Jerseys' AS ProductType, '40' AS WeightAllocated, '3' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tanker-05-27-05-2019' AS DepartureID, '2/9/2019' AS DateLogged, 'Tiny Violins' AS ProductType, '50' AS WeightAllocated, '2' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tug-04-03-05-2019' AS DepartureID, '1/28/2019' AS DateLogged, 'Legumes' AS ProductType, '62' AS WeightAllocated, '4' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tug-02-25-04-2019' AS DepartureID, '4/1/2019' AS DateLogged, 'Cheese' AS ProductType, '68' AS WeightAllocated, '12' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tug-01-30-04-2019' AS DepartureID, '3/14/2019' AS DateLogged, 'Spurs Jerseys' AS ProductType, '87' AS WeightAllocated, '5' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tug-05-10-04-2019' AS DepartureID, '4/10/2019' AS DateLogged, 'Livestock' AS ProductType, '43' AS WeightAllocated, '7' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Freighter-01-18-06-2019' AS DepartureID, '4/20/2019' AS DateLogged, 'Timber' AS ProductType, '248' AS WeightAllocated, '74' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tanker-04-27-06-2019' AS DepartureID, '4/23/2019' AS DateLogged, 'Gold Bullion' AS ProductType, '124' AS WeightAllocated, '4' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Freighter-02-26-05-2019' AS DepartureID, '1/11/2019' AS DateLogged, 'Produce' AS ProductType, '232' AS WeightAllocated, '58' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tug-05-10-04-2019' AS DepartureID, '4/14/2019' AS DateLogged, 'Tiny Violins' AS ProductType, '59' AS WeightAllocated, '8' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Freighter-05-23-05-2019' AS DepartureID, '4/14/2019' AS DateLogged, 'Luxury Goods' AS ProductType, '844' AS WeightAllocated, '40' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Freighter-03-01-04-2019' AS DepartureID, '2/19/2019' AS DateLogged, 'Livestock' AS ProductType, '272' AS WeightAllocated, '16' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tanker-03-30-04-2019' AS DepartureID, '3/6/2019' AS DateLogged, 'Knickknacks' AS ProductType, '57' AS WeightAllocated, '48' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Freighter-04-27-04-2019' AS DepartureID, '2/1/2019' AS DateLogged, 'Phone Catalogues' AS ProductType, '852' AS WeightAllocated, '4' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Freighter-02-10-04-2019' AS DepartureID, '4/24/2019' AS DateLogged, 'Oil' AS ProductType, '8' AS WeightAllocated, '48' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Freighter-04-27-04-2019' AS DepartureID, '3/10/2019' AS DateLogged, 'Vinyl Records' AS ProductType, '300' AS WeightAllocated, '56' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Freighter-02-03-06-2019' AS DepartureID, '1/20/2019' AS DateLogged, 'Shipping Containers' AS ProductType, '628' AS WeightAllocated, '10' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tug-04-21-06-2019' AS DepartureID, '2/1/2019' AS DateLogged, 'C&BS Co Soap' AS ProductType, '23' AS WeightAllocated, '4' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tug-01-13-06-2019' AS DepartureID, '4/18/2019' AS DateLogged, 'Motor vehicles' AS ProductType, '46' AS WeightAllocated, '2' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tanker-04-21-04-2019' AS DepartureID, '2/18/2019' AS DateLogged, 'Timber' AS ProductType, '186' AS WeightAllocated, '40' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Freighter-05-26-05-2019' AS DepartureID, '2/27/2019' AS DateLogged, 'DVD Boxsets' AS ProductType, '236' AS WeightAllocated, '90' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tug-04-18-06-2019' AS DepartureID, '4/19/2019' AS DateLogged, 'Vinyl Records' AS ProductType, '52' AS WeightAllocated, '3' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tanker-02-11-06-2019' AS DepartureID, '1/26/2019' AS DateLogged, 'Rubber Ducks' AS ProductType, '95' AS WeightAllocated, '6' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Freighter-01-18-06-2019' AS DepartureID, '3/27/2019' AS DateLogged, 'Motor vehicles' AS ProductType, '748' AS WeightAllocated, '68' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tanker-05-04-05-2019' AS DepartureID, '3/20/2019' AS DateLogged, 'Cheese' AS ProductType, '142' AS WeightAllocated, '2' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tug-05-26-05-2019' AS DepartureID, '2/14/2019' AS DateLogged, 'University Textbooks' AS ProductType, '68' AS WeightAllocated, '2' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tug-02-11-05-2019' AS DepartureID, '2/26/2019' AS DateLogged, 'Produce' AS ProductType, '1' AS WeightAllocated, '9' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Freighter-02-26-05-2019' AS DepartureID, '2/2/2019' AS DateLogged, 'Electronics' AS ProductType, '864' AS WeightAllocated, '36' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tug-04-18-06-2019' AS DepartureID, '4/21/2019' AS DateLogged, 'Luxury Goods' AS ProductType, '31' AS WeightAllocated, '6' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tanker-02-11-06-2019' AS DepartureID, '1/23/2019' AS DateLogged, 'Knickknacks' AS ProductType, '186' AS WeightAllocated, '44' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tanker-04-27-06-2019' AS DepartureID, '1/19/2019' AS DateLogged, 'Legumes' AS ProductType, '111' AS WeightAllocated, '46' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Freighter-04-12-04-2019' AS DepartureID, '2/17/2019' AS DateLogged, 'Oil' AS ProductType, '352' AS WeightAllocated, '68' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Freighter-01-06-04-2019' AS DepartureID, '1/13/2019' AS DateLogged, 'Phone Catalogues' AS ProductType, '972' AS WeightAllocated, '64' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tanker-01-04-06-2019' AS DepartureID, '4/18/2019' AS DateLogged, 'Luxury Goods' AS ProductType, '201' AS WeightAllocated, '8' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Freighter-03-10-04-2019' AS DepartureID, '4/5/2019' AS DateLogged, 'White Goods' AS ProductType, '36' AS WeightAllocated, '6' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tug-05-27-03-2019' AS DepartureID, '3/22/2019' AS DateLogged, 'Timber' AS ProductType, '66' AS WeightAllocated, '8' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tug-02-25-04-2019' AS DepartureID, '1/9/2019' AS DateLogged, 'C&BS Co Soap' AS ProductType, '5' AS WeightAllocated, '10' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tug-03-15-04-2019' AS DepartureID, '3/20/2019' AS DateLogged, 'Spurs Jerseys' AS ProductType, '39' AS WeightAllocated, '8' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tanker-04-27-06-2019' AS DepartureID, '4/23/2019' AS DateLogged, 'Cheese' AS ProductType, '96' AS WeightAllocated, '30' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tanker-03-30-04-2019' AS DepartureID, '3/30/2019' AS DateLogged, 'Sneakers' AS ProductType, '211' AS WeightAllocated, '2' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Freighter-05-23-05-2019' AS DepartureID, '3/4/2019' AS DateLogged, 'Vinyl Records' AS ProductType, '504' AS WeightAllocated, '70' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tug-01-04-06-2019' AS DepartureID, '1/21/2019' AS DateLogged, 'Oil' AS ProductType, '61' AS WeightAllocated, '5' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tanker-01-04-06-2019' AS DepartureID, '1/15/2019' AS DateLogged, 'University Textbooks' AS ProductType, '25' AS WeightAllocated, '12' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tanker-04-27-04-2019' AS DepartureID, '2/28/2019' AS DateLogged, 'Shipping Containers' AS ProductType, '244' AS WeightAllocated, '32' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tanker-01-04-06-2019' AS DepartureID, '3/17/2019' AS DateLogged, 'Luxury Goods' AS ProductType, '15' AS WeightAllocated, '16' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Freighter-05-26-05-2019' AS DepartureID, '1/20/2019' AS DateLogged, 'Rubber Ducks' AS ProductType, '624' AS WeightAllocated, '42' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tug-02-11-05-2019' AS DepartureID, '2/8/2019' AS DateLogged, 'Sneakers' AS ProductType, '82' AS WeightAllocated, '6' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Freighter-02-10-04-2019' AS DepartureID, '2/28/2019' AS DateLogged, 'Cheese' AS ProductType, '956' AS WeightAllocated, '52' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tanker-01-11-05-2019' AS DepartureID, '3/13/2019' AS DateLogged, 'White Goods' AS ProductType, '199' AS WeightAllocated, '20' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Freighter-05-23-05-2019' AS DepartureID, '2/19/2019' AS DateLogged, 'Produce' AS ProductType, '368' AS WeightAllocated, '58' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tug-04-21-06-2019' AS DepartureID, '3/18/2019' AS DateLogged, 'Knickknacks' AS ProductType, '14' AS WeightAllocated, '12' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tug-01-04-06-2019' AS DepartureID, '1/24/2019' AS DateLogged, 'Gold Bullion' AS ProductType, '34' AS WeightAllocated, '2' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tug-01-07-06-2019' AS DepartureID, '2/6/2019' AS DateLogged, 'Tiny Violins' AS ProductType, '75' AS WeightAllocated, '5' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Freighter-02-26-05-2019' AS DepartureID, '4/24/2019' AS DateLogged, 'Shipping Containers' AS ProductType, '540' AS WeightAllocated, '20' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tug-01-29-04-2019' AS DepartureID, '3/5/2019' AS DateLogged, 'Cheese' AS ProductType, '82' AS WeightAllocated, '9' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tanker-01-11-05-2019' AS DepartureID, '3/29/2019' AS DateLogged, 'DVD Boxsets' AS ProductType, '0' AS WeightAllocated, '12' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tanker-01-04-06-2019' AS DepartureID, '2/7/2019' AS DateLogged, 'Timber' AS ProductType, '8' AS WeightAllocated, '42' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tug-05-27-03-2019' AS DepartureID, '1/26/2019' AS DateLogged, 'Knickknacks' AS ProductType, '70' AS WeightAllocated, '10' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tug-05-26-05-2019' AS DepartureID, '4/14/2019' AS DateLogged, 'Timber' AS ProductType, '85' AS WeightAllocated, '11' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tanker-04-27-04-2019' AS DepartureID, '3/11/2019' AS DateLogged, 'Produce' AS ProductType, '30' AS WeightAllocated, '40' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tanker-05-03-05-2019' AS DepartureID, '1/24/2019' AS DateLogged, 'Tiny Violins' AS ProductType, '237' AS WeightAllocated, '6' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tug-01-07-06-2019' AS DepartureID, '3/1/2019' AS DateLogged, 'Motor vehicles' AS ProductType, '92' AS WeightAllocated, '7' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tug-03-17-04-2019' AS DepartureID, '4/2/2019' AS DateLogged, 'Knickknacks' AS ProductType, '29' AS WeightAllocated, '12' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tanker-02-11-06-2019' AS DepartureID, '4/14/2019' AS DateLogged, 'Spurs Jerseys' AS ProductType, '84' AS WeightAllocated, '26' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Freighter-04-12-04-2019' AS DepartureID, '3/2/2019' AS DateLogged, 'White Goods' AS ProductType, '88' AS WeightAllocated, '22' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tanker-05-27-05-2019' AS DepartureID, '4/17/2019' AS DateLogged, 'White Goods' AS ProductType, '180' AS WeightAllocated, '6' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Freighter-04-19-06-2019' AS DepartureID, '2/21/2019' AS DateLogged, 'Gold Bullion' AS ProductType, '436' AS WeightAllocated, '62' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Freighter-04-26-05-2019' AS DepartureID, '4/11/2019' AS DateLogged, 'Cheese' AS ProductType, '112' AS WeightAllocated, '18' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Freighter-05-10-06-2019' AS DepartureID, '1/18/2019' AS DateLogged, 'Motor vehicles' AS ProductType, '760' AS WeightAllocated, '82' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tug-01-30-04-2019' AS DepartureID, '1/30/2019' AS DateLogged, 'Produce' AS ProductType, '98' AS WeightAllocated, '5' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tanker-04-27-06-2019' AS DepartureID, '2/8/2019' AS DateLogged, 'Knickknacks' AS ProductType, '175' AS WeightAllocated, '42' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Freighter-05-23-05-2019' AS DepartureID, '4/25/2019' AS DateLogged, 'Vinyl Records' AS ProductType, '776' AS WeightAllocated, '24' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Freighter-02-03-06-2019' AS DepartureID, '2/9/2019' AS DateLogged, 'University Textbooks' AS ProductType, '852' AS WeightAllocated, '36' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tug-02-25-04-2019' AS DepartureID, '3/6/2019' AS DateLogged, 'Spices' AS ProductType, '51' AS WeightAllocated, '3' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tug-01-07-06-2019' AS DepartureID, '1/14/2019' AS DateLogged, 'Luxury Goods' AS ProductType, '26' AS WeightAllocated, '8' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tug-05-22-05-2019' AS DepartureID, '3/9/2019' AS DateLogged, 'Knickknacks' AS ProductType, '42' AS WeightAllocated, '6' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tanker-05-03-05-2019' AS DepartureID, '3/28/2019' AS DateLogged, 'Beanie Babies' AS ProductType, '101' AS WeightAllocated, '38' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tanker-01-11-05-2019' AS DepartureID, '1/10/2019' AS DateLogged, 'Legumes' AS ProductType, '105' AS WeightAllocated, '22' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tug-02-25-04-2019' AS DepartureID, '1/27/2019' AS DateLogged, 'Cheese' AS ProductType, '100' AS WeightAllocated, '6' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tanker-05-20-05-2019' AS DepartureID, '1/22/2019' AS DateLogged, 'Knickknacks' AS ProductType, '220' AS WeightAllocated, '8' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Freighter-02-10-04-2019' AS DepartureID, '2/2/2019' AS DateLogged, 'Spices' AS ProductType, '708' AS WeightAllocated, '90' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Freighter-05-10-06-2019' AS DepartureID, '2/26/2019' AS DateLogged, 'Luxury Goods' AS ProductType, '200' AS WeightAllocated, '70' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tug-02-11-05-2019' AS DepartureID, '2/18/2019' AS DateLogged, 'Luxury Goods' AS ProductType, '52' AS WeightAllocated, '8' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Freighter-04-27-04-2019' AS DepartureID, '4/3/2019' AS DateLogged, 'DM Paper' AS ProductType, '448' AS WeightAllocated, '38' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tug-01-30-04-2019' AS DepartureID, '1/27/2019' AS DateLogged, 'Oil' AS ProductType, '96' AS WeightAllocated, '6' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tanker-02-07-04-2019' AS DepartureID, '1/5/2019' AS DateLogged, 'Phone Catalogues' AS ProductType, '247' AS WeightAllocated, '44' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tug-02-25-04-2019' AS DepartureID, '1/20/2019' AS DateLogged, 'University Textbooks' AS ProductType, '96' AS WeightAllocated, '2' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tanker-04-27-06-2019' AS DepartureID, '1/16/2019' AS DateLogged, 'Shipping Containers' AS ProductType, '180' AS WeightAllocated, '22' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Freighter-04-12-04-2019' AS DepartureID, '1/7/2019' AS DateLogged, 'Luxury Goods' AS ProductType, '492' AS WeightAllocated, '12' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tug-03-17-04-2019' AS DepartureID, '2/25/2019' AS DateLogged, 'Phone Catalogues' AS ProductType, '73' AS WeightAllocated, '6' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tug-01-04-06-2019' AS DepartureID, '3/21/2019' AS DateLogged, 'Shipping Containers' AS ProductType, '107' AS WeightAllocated, '9' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Freighter-03-01-04-2019' AS DepartureID, '2/1/2019' AS DateLogged, 'Livestock' AS ProductType, '836' AS WeightAllocated, '42' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tug-02-25-04-2019' AS DepartureID, '4/15/2019' AS DateLogged, 'Spices' AS ProductType, '33' AS WeightAllocated, '1' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tanker-01-11-05-2019' AS DepartureID, '2/8/2019' AS DateLogged, 'Produce' AS ProductType, '161' AS WeightAllocated, '8' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tanker-05-17-06-2019' AS DepartureID, '1/18/2019' AS DateLogged, 'Phone Catalogues' AS ProductType, '76' AS WeightAllocated, '18' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tanker-05-02-05-2019' AS DepartureID, '1/26/2019' AS DateLogged, 'Legumes' AS ProductType, '104' AS WeightAllocated, '44' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Freighter-02-10-04-2019' AS DepartureID, '3/14/2019' AS DateLogged, 'Motor vehicles' AS ProductType, '652' AS WeightAllocated, '44' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tug-03-04-05-2019' AS DepartureID, '1/25/2019' AS DateLogged, 'Timber' AS ProductType, '22' AS WeightAllocated, '5' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tanker-04-27-04-2019' AS DepartureID, '1/25/2019' AS DateLogged, 'White Goods' AS ProductType, '188' AS WeightAllocated, '46' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tug-02-11-05-2019' AS DepartureID, '4/16/2019' AS DateLogged, 'Sneakers' AS ProductType, '100' AS WeightAllocated, '5' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tug-04-18-06-2019' AS DepartureID, '4/13/2019' AS DateLogged, 'Produce' AS ProductType, '52' AS WeightAllocated, '6' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tug-03-04-05-2019' AS DepartureID, '2/14/2019' AS DateLogged, 'Produce' AS ProductType, '13' AS WeightAllocated, '12' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Freighter-05-23-05-2019' AS DepartureID, '4/15/2019' AS DateLogged, 'University Textbooks' AS ProductType, '200' AS WeightAllocated, '26' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tug-03-04-05-2019' AS DepartureID, '3/31/2019' AS DateLogged, 'C&BS Co Soap' AS ProductType, '51' AS WeightAllocated, '1' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Freighter-04-26-05-2019' AS DepartureID, '4/1/2019' AS DateLogged, 'Knickknacks' AS ProductType, '132' AS WeightAllocated, '82' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Freighter-04-31-03-2019' AS DepartureID, '4/2/2019' AS DateLogged, 'Shipping Containers' AS ProductType, '172' AS WeightAllocated, '38' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tanker-02-11-06-2019' AS DepartureID, '2/11/2019' AS DateLogged, 'Shipping Containers' AS ProductType, '168' AS WeightAllocated, '48' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tug-03-17-04-2019' AS DepartureID, '3/21/2019' AS DateLogged, 'Tiny Violins' AS ProductType, '64' AS WeightAllocated, '10' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tug-03-17-04-2019' AS DepartureID, '4/16/2019' AS DateLogged, 'White Goods' AS ProductType, '0' AS WeightAllocated, '11' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tug-04-11-06-2019' AS DepartureID, '2/20/2019' AS DateLogged, 'University Textbooks' AS ProductType, '78' AS WeightAllocated, '11' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tug-04-11-06-2019' AS DepartureID, '3/18/2019' AS DateLogged, 'Spurs Jerseys' AS ProductType, '20' AS WeightAllocated, '11' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Freighter-05-06-06-2019' AS DepartureID, '2/10/2019' AS DateLogged, 'Vinyl Records' AS ProductType, '228' AS WeightAllocated, '98' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tanker-04-27-04-2019' AS DepartureID, '4/12/2019' AS DateLogged, 'Spurs Jerseys' AS ProductType, '144' AS WeightAllocated, '48' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tanker-04-27-06-2019' AS DepartureID, '1/8/2019' AS DateLogged, 'Spurs Jerseys' AS ProductType, '10' AS WeightAllocated, '38' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tanker-02-07-04-2019' AS DepartureID, '2/23/2019' AS DateLogged, 'Shipping Containers' AS ProductType, '79' AS WeightAllocated, '18' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Freighter-04-19-06-2019' AS DepartureID, '1/6/2019' AS DateLogged, 'Motor vehicles' AS ProductType, '140' AS WeightAllocated, '2' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tanker-01-12-05-2019' AS DepartureID, '2/20/2019' AS DateLogged, 'Sneakers' AS ProductType, '28' AS WeightAllocated, '32' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tug-05-22-05-2019' AS DepartureID, '3/28/2019' AS DateLogged, 'Oil' AS ProductType, '105' AS WeightAllocated, '4' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tug-04-11-06-2019' AS DepartureID, '3/5/2019' AS DateLogged, 'Timber' AS ProductType, '78' AS WeightAllocated, '3' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tug-01-13-06-2019' AS DepartureID, '3/4/2019' AS DateLogged, 'Luxury Goods' AS ProductType, '66' AS WeightAllocated, '10' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Freighter-05-26-05-2019' AS DepartureID, '1/18/2019' AS DateLogged, 'Spurs Jerseys' AS ProductType, '84' AS WeightAllocated, '78' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Freighter-05-10-06-2019' AS DepartureID, '2/2/2019' AS DateLogged, 'Oil' AS ProductType, '508' AS WeightAllocated, '12' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tanker-03-30-04-2019' AS DepartureID, '2/14/2019' AS DateLogged, 'Motor vehicles' AS ProductType, '176' AS WeightAllocated, '46' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Freighter-05-10-06-2019' AS DepartureID, '3/2/2019' AS DateLogged, 'Tiny Violins' AS ProductType, '716' AS WeightAllocated, '76' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tug-01-13-06-2019' AS DepartureID, '3/9/2019' AS DateLogged, 'Shipping Containers' AS ProductType, '62' AS WeightAllocated, '12' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tug-05-10-04-2019' AS DepartureID, '3/2/2019' AS DateLogged, 'Vinyl Records' AS ProductType, '39' AS WeightAllocated, '10' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tanker-05-02-05-2019' AS DepartureID, '4/12/2019' AS DateLogged, 'Electronics' AS ProductType, '59' AS WeightAllocated, '22' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Freighter-02-26-05-2019' AS DepartureID, '2/26/2019' AS DateLogged, 'Vinyl Records' AS ProductType, '96' AS WeightAllocated, '42' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tug-05-27-03-2019' AS DepartureID, '4/7/2019' AS DateLogged, 'DVD Boxsets' AS ProductType, '108' AS WeightAllocated, '5' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Freighter-02-11-06-2019' AS DepartureID, '1/19/2019' AS DateLogged, 'Timber' AS ProductType, '132' AS WeightAllocated, '4' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tug-01-04-06-2019' AS DepartureID, '3/7/2019' AS DateLogged, 'Electronics' AS ProductType, '3' AS WeightAllocated, '11' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tug-01-29-04-2019' AS DepartureID, '2/23/2019' AS DateLogged, 'Tiny Violins' AS ProductType, '103' AS WeightAllocated, '2' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tanker-05-17-06-2019' AS DepartureID, '3/3/2019' AS DateLogged, 'Produce' AS ProductType, '61' AS WeightAllocated, '12' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tanker-05-02-05-2019' AS DepartureID, '3/27/2019' AS DateLogged, 'Legumes' AS ProductType, '190' AS WeightAllocated, '2' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tug-01-29-04-2019' AS DepartureID, '3/9/2019' AS DateLogged, 'University Textbooks' AS ProductType, '29' AS WeightAllocated, '10' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tug-05-27-03-2019' AS DepartureID, '3/19/2019' AS DateLogged, 'DM Paper' AS ProductType, '26' AS WeightAllocated, '2' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tanker-04-21-04-2019' AS DepartureID, '2/16/2019' AS DateLogged, 'Produce' AS ProductType, '94' AS WeightAllocated, '42' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tanker-04-27-06-2019' AS DepartureID, '3/3/2019' AS DateLogged, 'Shipping Containers' AS ProductType, '109' AS WeightAllocated, '6' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tanker-05-04-05-2019' AS DepartureID, '2/6/2019' AS DateLogged, 'Sneakers' AS ProductType, '28' AS WeightAllocated, '32' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Freighter-05-26-06-2019' AS DepartureID, '1/1/2019' AS DateLogged, 'Timber' AS ProductType, '364' AS WeightAllocated, '54' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tug-03-17-04-2019' AS DepartureID, '2/15/2019' AS DateLogged, 'Oil' AS ProductType, '9' AS WeightAllocated, '1' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Freighter-02-11-06-2019' AS DepartureID, '3/11/2019' AS DateLogged, 'Vinyl Records' AS ProductType, '36' AS WeightAllocated, '16' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tug-03-15-04-2019' AS DepartureID, '3/16/2019' AS DateLogged, 'Electronics' AS ProductType, '31' AS WeightAllocated, '9' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tug-03-17-04-2019' AS DepartureID, '2/11/2019' AS DateLogged, 'Beanie Babies' AS ProductType, '108' AS WeightAllocated, '8' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Freighter-04-26-05-2019' AS DepartureID, '4/19/2019' AS DateLogged, 'C&BS Co Soap' AS ProductType, '836' AS WeightAllocated, '2' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tanker-05-17-06-2019' AS DepartureID, '1/22/2019' AS DateLogged, 'DM Paper' AS ProductType, '169' AS WeightAllocated, '20' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tanker-04-27-04-2019' AS DepartureID, '1/4/2019' AS DateLogged, 'Knickknacks' AS ProductType, '32' AS WeightAllocated, '36' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Freighter-02-19-04-2019' AS DepartureID, '3/26/2019' AS DateLogged, 'Livestock' AS ProductType, '460' AS WeightAllocated, '62' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Freighter-05-06-06-2019' AS DepartureID, '2/3/2019' AS DateLogged, 'Livestock' AS ProductType, '804' AS WeightAllocated, '40' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tug-01-29-04-2019' AS DepartureID, '4/10/2019' AS DateLogged, 'Timber' AS ProductType, '10' AS WeightAllocated, '8' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tug-01-04-06-2019' AS DepartureID, '4/3/2019' AS DateLogged, 'Legumes' AS ProductType, '49' AS WeightAllocated, '5' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Freighter-03-10-04-2019' AS DepartureID, '3/17/2019' AS DateLogged, 'Sneakers' AS ProductType, '780' AS WeightAllocated, '100' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tanker-02-11-06-2019' AS DepartureID, '1/17/2019' AS DateLogged, 'Produce' AS ProductType, '88' AS WeightAllocated, '12' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tanker-04-10-04-2019' AS DepartureID, '1/21/2019' AS DateLogged, 'Beanie Babies' AS ProductType, '192' AS WeightAllocated, '34' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tanker-05-20-05-2019' AS DepartureID, '4/23/2019' AS DateLogged, 'Cheese' AS ProductType, '84' AS WeightAllocated, '22' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Freighter-05-23-05-2019' AS DepartureID, '3/1/2019' AS DateLogged, 'Rubber Ducks' AS ProductType, '208' AS WeightAllocated, '72' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tug-04-11-06-2019' AS DepartureID, '4/9/2019' AS DateLogged, 'Motor vehicles' AS ProductType, '7' AS WeightAllocated, '5' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tanker-01-11-05-2019' AS DepartureID, '4/22/2019' AS DateLogged, 'Motor vehicles' AS ProductType, '226' AS WeightAllocated, '20' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tug-03-17-04-2019' AS DepartureID, '4/13/2019' AS DateLogged, 'Cheese' AS ProductType, '87' AS WeightAllocated, '3' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tanker-01-12-05-2019' AS DepartureID, '4/9/2019' AS DateLogged, 'Electronics' AS ProductType, '256' AS WeightAllocated, '32' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Freighter-05-26-06-2019' AS DepartureID, '1/3/2019' AS DateLogged, 'Gold Bullion' AS ProductType, '968' AS WeightAllocated, '72' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tanker-01-04-06-2019' AS DepartureID, '3/27/2019' AS DateLogged, 'Legumes' AS ProductType, '214' AS WeightAllocated, '12' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tug-01-23-04-2019' AS DepartureID, '4/3/2019' AS DateLogged, 'University Textbooks' AS ProductType, '1' AS WeightAllocated, '5' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tanker-05-04-05-2019' AS DepartureID, '2/26/2019' AS DateLogged, 'Electronics' AS ProductType, '139' AS WeightAllocated, '50' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Freighter-04-27-04-2019' AS DepartureID, '2/27/2019' AS DateLogged, 'Oil' AS ProductType, '900' AS WeightAllocated, '48' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tug-01-04-06-2019' AS DepartureID, '1/30/2019' AS DateLogged, 'Spurs Jerseys' AS ProductType, '7' AS WeightAllocated, '9' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tug-03-17-04-2019' AS DepartureID, '1/31/2019' AS DateLogged, 'Gold Bullion' AS ProductType, '55' AS WeightAllocated, '9' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Freighter-05-19-06-2019' AS DepartureID, '4/1/2019' AS DateLogged, 'Spices' AS ProductType, '764' AS WeightAllocated, '42' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tug-04-18-06-2019' AS DepartureID, '3/9/2019' AS DateLogged, 'Spurs Jerseys' AS ProductType, '91' AS WeightAllocated, '2' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Freighter-04-19-06-2019' AS DepartureID, '3/20/2019' AS DateLogged, 'Oil' AS ProductType, '908' AS WeightAllocated, '48' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Freighter-05-06-06-2019' AS DepartureID, '1/16/2019' AS DateLogged, 'DVD Boxsets' AS ProductType, '632' AS WeightAllocated, '100' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tanker-01-12-05-2019' AS DepartureID, '1/31/2019' AS DateLogged, 'Motor vehicles' AS ProductType, '131' AS WeightAllocated, '28' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tug-05-26-05-2019' AS DepartureID, '2/10/2019' AS DateLogged, 'DVD Boxsets' AS ProductType, '69' AS WeightAllocated, '1' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tug-03-14-04-2019' AS DepartureID, '2/21/2019' AS DateLogged, 'Spurs Jerseys' AS ProductType, '66' AS WeightAllocated, '10' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Freighter-05-23-05-2019' AS DepartureID, '2/1/2019' AS DateLogged, 'Spices' AS ProductType, '152' AS WeightAllocated, '8' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tug-03-15-04-2019' AS DepartureID, '3/14/2019' AS DateLogged, 'Phone Catalogues' AS ProductType, '18' AS WeightAllocated, '5' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Freighter-03-01-04-2019' AS DepartureID, '1/1/2019' AS DateLogged, 'Knickknacks' AS ProductType, '332' AS WeightAllocated, '58' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Freighter-03-10-04-2019' AS DepartureID, '1/29/2019' AS DateLogged, 'Sneakers' AS ProductType, '268' AS WeightAllocated, '82' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tanker-01-04-06-2019' AS DepartureID, '4/24/2019' AS DateLogged, 'Shipping Containers' AS ProductType, '179' AS WeightAllocated, '18' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Freighter-05-06-06-2019' AS DepartureID, '1/27/2019' AS DateLogged, 'Produce' AS ProductType, '680' AS WeightAllocated, '94' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tug-04-18-06-2019' AS DepartureID, '4/1/2019' AS DateLogged, 'C&BS Co Soap' AS ProductType, '31' AS WeightAllocated, '11' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Freighter-03-10-04-2019' AS DepartureID, '2/23/2019' AS DateLogged, 'Phone Catalogues' AS ProductType, '844' AS WeightAllocated, '78' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Freighter-05-10-06-2019' AS DepartureID, '3/28/2019' AS DateLogged, 'Spices' AS ProductType, '556' AS WeightAllocated, '20' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tanker-05-03-05-2019' AS DepartureID, '2/9/2019' AS DateLogged, 'Electronics' AS ProductType, '245' AS WeightAllocated, '50' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tug-03-17-04-2019' AS DepartureID, '4/22/2019' AS DateLogged, 'Beanie Babies' AS ProductType, '96' AS WeightAllocated, '5' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Freighter-02-10-04-2019' AS DepartureID, '2/23/2019' AS DateLogged, 'Spices' AS ProductType, '336' AS WeightAllocated, '40' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tanker-05-27-05-2019' AS DepartureID, '3/1/2019' AS DateLogged, 'Motor vehicles' AS ProductType, '240' AS WeightAllocated, '34' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tanker-05-20-05-2019' AS DepartureID, '4/2/2019' AS DateLogged, 'Vinyl Records' AS ProductType, '23' AS WeightAllocated, '12' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tanker-01-04-06-2019' AS DepartureID, '3/28/2019' AS DateLogged, 'Luxury Goods' AS ProductType, '75' AS WeightAllocated, '48' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Freighter-04-19-06-2019' AS DepartureID, '2/20/2019' AS DateLogged, 'Legumes' AS ProductType, '336' AS WeightAllocated, '94' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Freighter-02-03-06-2019' AS DepartureID, '2/12/2019' AS DateLogged, 'Rubber Ducks' AS ProductType, '864' AS WeightAllocated, '14' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Freighter-01-06-04-2019' AS DepartureID, '3/1/2019' AS DateLogged, 'Spices' AS ProductType, '364' AS WeightAllocated, '48' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Freighter-05-26-06-2019' AS DepartureID, '4/4/2019' AS DateLogged, 'Legumes' AS ProductType, '940' AS WeightAllocated, '58' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tug-02-11-05-2019' AS DepartureID, '4/13/2019' AS DateLogged, 'University Textbooks' AS ProductType, '20' AS WeightAllocated, '3' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tanker-01-04-06-2019' AS DepartureID, '1/2/2019' AS DateLogged, 'Shipping Containers' AS ProductType, '15' AS WeightAllocated, '26' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Freighter-05-19-06-2019' AS DepartureID, '3/6/2019' AS DateLogged, 'Livestock' AS ProductType, '872' AS WeightAllocated, '54' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Freighter-05-06-06-2019' AS DepartureID, '3/14/2019' AS DateLogged, 'Beanie Babies' AS ProductType, '868' AS WeightAllocated, '42' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tug-03-04-05-2019' AS DepartureID, '1/3/2019' AS DateLogged, 'University Textbooks' AS ProductType, '56' AS WeightAllocated, '7' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tug-05-27-03-2019' AS DepartureID, '3/18/2019' AS DateLogged, 'Produce' AS ProductType, '61' AS WeightAllocated, '10' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tanker-05-27-05-2019' AS DepartureID, '3/14/2019' AS DateLogged, 'C&BS Co Soap' AS ProductType, '178' AS WeightAllocated, '24' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tug-02-25-04-2019' AS DepartureID, '4/7/2019' AS DateLogged, 'Tiny Violins' AS ProductType, '82' AS WeightAllocated, '4' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Freighter-01-18-06-2019' AS DepartureID, '2/19/2019' AS DateLogged, 'Tiny Violins' AS ProductType, '76' AS WeightAllocated, '28' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Freighter-05-10-06-2019' AS DepartureID, '1/4/2019' AS DateLogged, 'DVD Boxsets' AS ProductType, '188' AS WeightAllocated, '60' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tanker-01-04-06-2019' AS DepartureID, '2/24/2019' AS DateLogged, 'C&BS Co Soap' AS ProductType, '240' AS WeightAllocated, '26' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tug-01-13-06-2019' AS DepartureID, '3/20/2019' AS DateLogged, 'Knickknacks' AS ProductType, '31' AS WeightAllocated, '1' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tanker-02-07-04-2019' AS DepartureID, '2/27/2019' AS DateLogged, 'White Goods' AS ProductType, '244' AS WeightAllocated, '24' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tanker-05-27-05-2019' AS DepartureID, '2/1/2019' AS DateLogged, 'C&BS Co Soap' AS ProductType, '165' AS WeightAllocated, '26' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tanker-01-11-05-2019' AS DepartureID, '2/27/2019' AS DateLogged, 'Livestock' AS ProductType, '15' AS WeightAllocated, '20' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tug-02-25-04-2019' AS DepartureID, '1/8/2019' AS DateLogged, 'Phone Catalogues' AS ProductType, '17' AS WeightAllocated, '9' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tanker-03-30-04-2019' AS DepartureID, '4/4/2019' AS DateLogged, 'Oil' AS ProductType, '216' AS WeightAllocated, '20' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tanker-04-27-06-2019' AS DepartureID, '2/22/2019' AS DateLogged, 'Spurs Jerseys' AS ProductType, '34' AS WeightAllocated, '28' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Freighter-04-26-05-2019' AS DepartureID, '3/23/2019' AS DateLogged, 'White Goods' AS ProductType, '36' AS WeightAllocated, '46' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Freighter-02-26-05-2019' AS DepartureID, '1/1/2019' AS DateLogged, 'Shipping Containers' AS ProductType, '848' AS WeightAllocated, '48' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tug-03-04-05-2019' AS DepartureID, '3/3/2019' AS DateLogged, 'Phone Catalogues' AS ProductType, '66' AS WeightAllocated, '9' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Freighter-03-10-04-2019' AS DepartureID, '1/16/2019' AS DateLogged, 'Luxury Goods' AS ProductType, '664' AS WeightAllocated, '54' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tanker-05-20-05-2019' AS DepartureID, '1/17/2019' AS DateLogged, 'DM Paper' AS ProductType, '129' AS WeightAllocated, '46' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Freighter-04-12-04-2019' AS DepartureID, '1/23/2019' AS DateLogged, 'Legumes' AS ProductType, '756' AS WeightAllocated, '2' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tug-01-30-04-2019' AS DepartureID, '2/24/2019' AS DateLogged, 'Shipping Containers' AS ProductType, '69' AS WeightAllocated, '5' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Freighter-02-26-05-2019' AS DepartureID, '1/27/2019' AS DateLogged, 'Spurs Jerseys' AS ProductType, '448' AS WeightAllocated, '24' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tug-03-04-05-2019' AS DepartureID, '1/17/2019' AS DateLogged, 'Phone Catalogues' AS ProductType, '17' AS WeightAllocated, '10' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Tug-05-27-03-2019' AS DepartureID, '2/8/2019' AS DateLogged, 'DVD Boxsets' AS ProductType, '92' AS WeightAllocated, '2' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Tanker-01-12-05-2019' AS DepartureID, '1/1/2019' AS DateLogged, 'Vinyl Records' AS ProductType, '155' AS WeightAllocated, '22' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Tanker-05-17-06-2019' AS DepartureID, '1/10/2019' AS DateLogged, 'Motor vehicles' AS ProductType, '234' AS WeightAllocated, '8' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tanker-04-21-04-2019' AS DepartureID, '2/28/2019' AS DateLogged, 'Cheese' AS ProductType, '219' AS WeightAllocated, '44' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tug-04-03-05-2019' AS DepartureID, '3/21/2019' AS DateLogged, 'Oil' AS ProductType, '29' AS WeightAllocated, '4' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tug-05-27-03-2019' AS DepartureID, '1/16/2019' AS DateLogged, 'Cheese' AS ProductType, '104' AS WeightAllocated, '11' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Freighter-01-18-06-2019' AS DepartureID, '1/3/2019' AS DateLogged, 'Beanie Babies' AS ProductType, '708' AS WeightAllocated, '100' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tug-04-11-06-2019' AS DepartureID, '4/5/2019' AS DateLogged, 'University Textbooks' AS ProductType, '13' AS WeightAllocated, '1' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tug-03-14-04-2019' AS DepartureID, '2/11/2019' AS DateLogged, 'Luxury Goods' AS ProductType, '23' AS WeightAllocated, '4' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Freighter-05-26-05-2019' AS DepartureID, '3/25/2019' AS DateLogged, 'University Textbooks' AS ProductType, '196' AS WeightAllocated, '96' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Freighter-02-03-06-2019' AS DepartureID, '3/7/2019' AS DateLogged, 'Livestock' AS ProductType, '116' AS WeightAllocated, '50' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Freighter-04-26-05-2019' AS DepartureID, '1/23/2019' AS DateLogged, 'Beanie Babies' AS ProductType, '20' AS WeightAllocated, '46' AS VolumeAllocated UNION ALL 
SELECT 'Colin Chien' AS Salesperson, 'Tug-05-10-04-2019' AS DepartureID, '3/18/2019' AS DateLogged, 'Oil' AS ProductType, '81' AS WeightAllocated, '2' AS VolumeAllocated UNION ALL 
SELECT 'Brian Topp' AS Salesperson, 'Tug-01-29-04-2019' AS DepartureID, '3/3/2019' AS DateLogged, 'Livestock' AS ProductType, '61' AS WeightAllocated, '5' AS VolumeAllocated UNION ALL 
SELECT 'Marsha Klein' AS Salesperson, 'Freighter-02-19-04-2019' AS DepartureID, '3/22/2019' AS DateLogged, 'Luxury Goods' AS ProductType, '860' AS WeightAllocated, '76' AS VolumeAllocated UNION ALL 
SELECT 'Daisy Steiner' AS Salesperson, 'Tanker-05-08-06-2019' AS DepartureID, '4/9/2019' AS DateLogged, 'Timber' AS ProductType, '13' AS WeightAllocated, '50' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tanker-04-27-04-2019' AS DepartureID, '3/14/2019' AS DateLogged, 'Sneakers' AS ProductType, '66' AS WeightAllocated, '46' AS VolumeAllocated UNION ALL 
SELECT 'Mike Watt' AS Salesperson, 'Freighter-02-26-05-2019' AS DepartureID, '2/6/2019' AS DateLogged, 'Rubber Ducks' AS ProductType, '944' AS WeightAllocated, '22' AS VolumeAllocated UNION ALL 
SELECT 'Twist Morgan' AS Salesperson, 'Freighter-01-18-06-2019' AS DepartureID, '2/1/2019' AS DateLogged, 'University Textbooks' AS ProductType, '864' AS WeightAllocated, '68' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Freighter-03-01-04-2019' AS DepartureID, '3/30/2019' AS DateLogged, 'Spices' AS ProductType, '556' AS WeightAllocated, '82' AS VolumeAllocated UNION ALL 
SELECT 'Tim Bisley' AS Salesperson, 'Tug-04-11-06-2019' AS DepartureID, '3/31/2019' AS DateLogged, 'Luxury Goods' AS ProductType, '108' AS WeightAllocated, '10' AS VolumeAllocated
) As t

--SELECT top 5 ShipID, DepartureDate, MaxWeight, MaxVolume FROM W7_DepartureDetails

SELECT l.ShipID, l.DepartureDate, l.MaxWeight, l.MaxVolume, r.WeightAllocated, r.VolumeAllocated,
       CASE WHEN (r.WeightAllocated > l.MaxWeight) THEN 'TRUE' ELSE 'FALSE' END AS [Max_Weight_Exceeded?],
       CASE WHEN (r.VolumeAllocated > l.MaxVolume) THEN 'TRUE' ELSE 'FALSE' END AS [Max_Volume_Exceeded?]
FROM W7_DepartureDetails l 
LEFT JOIN
 (   
  SELECT Ship_ID, Dep_Date, SUM(WeightAllocated) AS WeightAllocated, SUM(VolumeAllocated) AS VolumeAllocated
  FROM
   (   -- retrive ShipID & Departture Date from 'DepartureID' field
       SELECT DepartureID, LEFT(DepartureID, LEN(DepartureID)-11) As Ship_ID, 
               DATEFROMPARTS(RIGHT(RIGHT(DepartureID,10),4),
                             RIGHT(LEFT(RIGHT(DepartureID,10),5),2),
                             LEFT(RIGHT(DepartureID,10),2)
                            ) AS Dep_Date,  
       WeightAllocated, VolumeAllocated FROM W7_AllocationDetails
   ) As a1 GROUP BY Ship_ID, Dep_Date
 ) As r ON l.ShipID = r.Ship_ID AND l.DepartureDate = r.Dep_Date


run \| edit \| history \| help	0