q4.sql

INSERT INTO part VALUES (30034, "Unknown Chip", "red", 3.56);
INSERT INTO part VALUES (30134, "Breadboard", "white", 50.4);
INSERT INTO part VALUES (12154, "Processed Graphite", "black", 2.1);
INSERT INTO part VALUES (10023, "Cushion Piece", "red", 100.3);
INSERT INTO part VALUES (23044, "Bobbin", "black", 2.3);

INSERT INTO supplier VALUES (4122, "Horizon Systems", "Pune", "MSC Bank");
INSERT INTO supplier VALUES (9162, "Ikea", "Stockholm", "Swedbank");
INSERT INTO supplier VALUES (4518, "MPQMDSPH Ltd.", "Philadelphia", "Bank of America");
INSERT INTO supplier VALUES (4590, "Weno Mech", "Philadelphia", "Bank of America");
INSERT INTO supplier VALUES (7800, "Ainsama Motors", "Bengaluru", "State Bank of Karnataka");

INSERT INTO shipment VALUES(1100232, 10034, 4518, "2022-09-05", 1000, 32.8);
INSERT INTO shipment VALUES(1100233, 10034, 9162, "2022-09-15", 3000, 35.4);
INSERT INTO shipment VALUES(1100234, 10034, 4590, "2022-08-25", 5000, 50.5);
INSERT INTO shipment VALUES(2200232, 10034, 4590, "2022-07-05", 6700, 20.3);

INSERT INTO shipment VALUES(2200233, 30034, 7800, "2022-05-04", 5600, 20.4);
INSERT INTO shipment VALUES(2200234, 30034, 4590, "2022-07-12", 5000, 10.9);
INSERT INTO shipment VALUES(3300232, 30034, 9162, "2022-08-23", 100, 12.4);
INSERT INTO shipment VALUES(3300233, 30034, 4122, "2022-05-06", 4560, 7.8);

INSERT INTO shipment VALUES(3300234, 12154, 4518, "2022-02-21", 1003, 300.4);
INSERT INTO shipment VALUES(4400232, 12154, 2143, "2022-02-23", 1040, 212.4);
INSERT INTO shipment VALUES(4400233, 12154, 7800, "2022-02-07", 2000, 222.4);
INSERT INTO shipment VALUES(4400234, 12154, 9162, "2022-01-03", 1033, 195.4);

INSERT INTO shipment VALUES(5500232, 10023, 4518, "2022-09-02", 220, 5000);
INSERT INTO shipment VALUES(5500234, 10023, 4122, "2022-08-19", 300, 5990);
INSERT INTO shipment VALUES(5500235, 10023, 7800, "2022-08-14", 700, 7400);
INSERT INTO shipment VALUES(5500237, 10023, 9162, "2022-08-23", 750, 7410);

INSERT INTO shipment VALUES(6600232, 23044, 4518, "2022-08-30", 5200, 1.8);
INSERT INTO shipment VALUES(6600233, 23044, 2143, "2021-12-12", 9600, 2.4);
INSERT INTO shipment VALUES(6600230, 30134, 9162, "2020-02-20", 5000, 5.6);
INSERT INTO shipment VALUES(6600236, 23044, 9162, "2020-02-29", 5050, 3.4);