Добавил:
Katynska
Опубликованный материал нарушает ваши авторские права? Сообщите нам.
Вуз:
Предмет:
Файл:Разные СУБД / Лаба 4 / sql запросы из БД
.txtCREATE 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;
Соседние файлы в папке Лаба 4