Разные СУБД / Лаба 4 / sql запросы из БД

CREATE TABLE Products(
maker TEXT NOT NULL,
model INTEGER NOT NULL,
type TEXT NOT NULL);


INSERT INTO Products (maker, model, type)VALUES
('Amdahl', 1611, 'pc' ),
('Amdahl', 1612, 'pc'),
('Amdahl', 1613, 'pc'),
('Amdahl', 1511, 'laptop'),
('Amdahl', 1512, 'laptop'),
('Amdahl', 1513, 'laptop'),
('blackСoffin', 1621, 'pc'),
('blackСoffin', 1622, 'pc'),
('blackСoffin', 1623, 'pc'),
('blackСoffin', 1521, 'laptop'),
('CellAndMachine', 1631, 'pc'),
('DriverSF', 1641, 'pc'),
('DriverSF', 1642, 'pc'),
('DriverSF', 1643, 'pc'),
('DriverSF', 1841, 'printer'),
('DriverSF', 1842, 'printer'),
('Eureka', 1651, 'pc'),
('Eureka', 1652, 'pc'),
('Eureka', 1653, 'pc'),
('Eureka', 1551, 'laptop'),
('Eureka', 1552, 'laptop'),
('Eureka', 1553, 'laptop'),
('Eureka', 1851, 'printer'),
('Eureka', 1852, 'printer'),
('Eureka', 1853, 'printer'),
('Fiji', 1561, 'laptop'),
('Fiji', 1562, 'laptop'),
('GGTop', 1571, 'laptop'),
('HellMachine', 6661, 'printer'),
('HellMachine', 6662, 'printer');






UPDATE Products
SET sales_2023 = '{60, 40, 30, 35, 50, 55, 60, 50, 45, 40, 65, NULL}'
WHERE model = 1611;

UPDATE Products
SET sales_2023 = '{40, 25, 20, 22, 35, 40, 30, 28, 56, 24, 35, NULL}'
WHERE model = 1511;

UPDATE Products
SET sales_2023 = '{65, 34, 23, 21, 24, 65, 32, 37, 65, 34, 24, NULL}'
WHERE model = 1612;

UPDATE Products
SET sales_2023 = '{73, 25, 20, 22, 35, 59, 30, 28, 66, 24, 35, NULL}'
WHERE model = 1551;

UPDATE Products
SET sales_2023 = '{75, 20, 18, 21, 30, 65, 28, 25, 73, 20, 32, NULL}'
WHERE model = 1552;

UPDATE Products
SET sales_2023 = '{65, 18, 15, 17, 25, 70, 22, 20, 79, 15, 26, NULL}'
WHERE model = 1553;


UPDATE Products
SET sales_2023 = '{45, 20, 18, 21, 30, 45, 28, 25, 53, 20, 32, NULL}'
WHERE model = 1512;

UPDATE Products
SET sales_2023 = '{60, 18, 15, 17, 25, 40, 22, 20, 68, 15, 26, NULL}'
WHERE model = 1513;

UPDATE Products
SET sales_2023 = '{72, 20, 18, 21, 28, 52, 24, 22, 60, 18, 30, NULL}'
WHERE model = 1521;

UPDATE Products
SET sales_2023 = '{40, 35, 30, 32, 55, 60, 50, 45, 40, 35, 60, NULL}'
WHERE model = 1621;

UPDATE Products
SET sales_2023 = '{55, 45, 35, 38, 60, 65, 55, 50, 45, 40, 70, NULL}'
WHERE model = 1622;

UPDATE Products
SET sales_2023 = '{60, 50, 40, 45, 70, 75, 60, 55, 50, 45, 80, NULL}'
WHERE model = 1623;

UPDATE Products
SET sales_2023 = '{55, 30, 25, 28, 60, 45, 35, 32, 50, 28, 45, NULL}'
WHERE model = 1641;

UPDATE Products
SET sales_2023 = '{60, 25, 22, 28, 38, 42, 35, 32, 58, 25, 40, NULL}'
WHERE model = 1642;

UPDATE Products
SET sales_2023 = '{40, 35, 30, 38, 48, 52, 45, 42, 48, 35, 50, NULL}'
WHERE model = 1643;

UPDATE Products
SET sales_2023 = '{45, 40, 30, 35, 50, 55, 45, 40, 35, 30, 50, NULL}'
WHERE model = 1651;

UPDATE Products
SET sales_2023 = '{50, 45, 35, 40, 55, 60, 50, 45, 40, 35, 55, NULL}'
WHERE model = 1652;

UPDATE Products
SET sales_2023 = '{40, 35, 30, 35, 50, 55, 45, 40, 35, 30, 50, NULL}'
WHERE model = 1653;

UPDATE Products
SET sales_2023 = '{35, 28, 25, 30, 40, 45, 38, 35, 30, 28, 45, NULL}'
WHERE model = 1631;

UPDATE Products
SET sales_2023 = '{35, 30, 25, 28, 40, 45, 35, 32, 30, 28, 45, NULL}'
WHERE model = 1561;

UPDATE Products
SET sales_2023 = '{40, 35, 30, 32, 45, 50, 40, 38, 35, 32, 50, NULL}'
WHERE model = 1562;

UPDATE Products
SET sales_2023 = '{45, 40, 35, 38, 50, 55, 45, 42, 40, 38, 55, NULL}'
WHERE model = 1571;

UPDATE Products
SET sales_2023 = '{40, 30, 25, 28, 45, 50, 40, 35, 30, 25, 45, NULL}'
WHERE model = 1613;

UPDATE Products
SET sales_2023 = '{45, 37, 28, 32, 55, 60, 45, 40, 38, 35, 50, NULL}'
WHERE model = 1631;




UPDATE Products
SET sales_2023 = '{25, 22, 20, 24, 30, 35, 40, 45, 50, 55, 60, NULL}'
WHERE model = 1841;

UPDATE Products
SET sales_2023 = '{22, 20, 18, 21, 28, 32, 37, 42, 47, 52, 57, NULL}'
WHERE model = 1842;

UPDATE Products
SET sales_2023 = '{25, 22, 20, 24, 30, 35, 40, 45, 50, 55, 60, NULL}'
WHERE model = 1851;

UPDATE Products
SET sales_2023 = '{22, 20, 18, 21, 28, 32, 37, 42, 47, 52, 57, NULL}'
WHERE model = 1852;

UPDATE Products
SET sales_2023 = '{37, 24, 23, 21, 57, 61, 32, 15, 17, 24, 63, NULL}'
WHERE model = 1853;

UPDATE Products
SET sales_2023 = '{18, 16, 14, 20, 25, 30, 35, 40, 45, 50, 55, NULL}'
WHERE model = 6661;

UPDATE Products
SET sales_2023 = '{20, 18, 15, 22, 30, 35, 40, 45, 50, 55, 60, NULL}'
WHERE model = 6662;