PostgreSQL Sandbox: General Resale, PostgreSQL

Language: Layout:

--PostgreSQL 9.5
--'\\' is a delimiter

CREATE TABLE general_resale(UPC INTEGER, item VARCHAR, in_stock INTEGER, price INTEGER, ship_day DATE, class VARCHAR)\\
  
INSERT INTO general_resale (UPC, item, in_stock, price, ship_day, class) VALUES (101, 'generator', 16, 5999, '12-1-2065', 'restricted')\\
INSERT INTO general_resale (UPC, item, in_stock, price, ship_day, class) VALUES (102, 'generator lite', 25, 3000, '12-1-2065', 'neutral')\\
INSERT INTO general_resale (UPC, item, in_stock, price, ship_day, class) VALUES (991, 'robot dog', 1, 99000, '12-28-2065', 'restricted')\\
INSERT INTO general_resale (UPC, item, in_stock, price, ship_day, class) VALUES (204, 'blank tape', 93, 5999, '12-31-2065', 'neutral')\\
INSERT INTO general_resale (UPC, item, in_stock, price, ship_day, class) VALUES (201, 'A WasteLand Pocket Guide', 2, 5999, '12-28-2065', 'neutral')\\
INSERT INTO general_resale (UPC, item, in_stock, price, ship_day, class) VALUES (301, 'gas mask', 12, 3000, '12-19-2065', 'neutral')\\
INSERT INTO general_resale (UPC, item, in_stock, price, ship_day, class) VALUES (302, 'sunshades', 17, 3000, '12-19-2065', 'neutral')\\
INSERT INTO general_resale (UPC, item, in_stock, price, ship_day, class) VALUES (212, 'tent', 2, 490, '12-4-2065', 'neutral')\\
INSERT INTO general_resale (UPC, item, in_stock, price, ship_day, class) VALUES (401, 'goldfish', 31, 100, '12-16-2065', 'neutral')\\
INSERT INTO general_resale (UPC, item, in_stock, price, ship_day, class) VALUES (405, 'repair kit', 3, 1000, '12-6-2065', 'restricted')\\
INSERT INTO general_resale (UPC, item, in_stock, price, ship_day, class) VALUES (404, 'fish food', 28, 299, '12-6-2065', 'neutral')\\
INSERT INTO general_resale (UPC, item, in_stock, price, ship_day, class) VALUES (107, 'powdered rations', 56, 1349, '1-3-2066', 'restricted')\\
INSERT INTO general_resale (UPC, item, in_stock, price, ship_day, class) VALUES (999, 'extra life', 1, 10000, '1-6-2066', 'restricted')\\

SELECT * from general_resale\\

CREATE TABLE report_breakin (UPC INTEGER, units_stolen INTEGER, unit_value INTEGER)\\
  
INSERT INTO report_breakin (UPC, units_stolen, unit_value) VALUES (101, 4, 5999)\\
INSERT INTO report_breakin (UPC, units_stolen, unit_value) VALUES (991, 1, 99000)\\
INSERT INTO report_breakin (UPC, units_stolen, unit_value) VALUES (401, 2, 100)\\
INSERT INTO report_breakin (UPC, units_stolen, unit_value) VALUES (404, 1, 299)\\
INSERT INTO report_breakin (UPC, units_stolen, unit_value) VALUES (107, 16, 1349)\\

SELECT * from report_breakin\\


absolute service time: 0,49 sec