CREATE TABLE Managers (
manager_id INT PRIMARY KEY,
name VARCHAR(255),
grade VARCHAR(50),
city VARCHAR(50)
);
INSERT INTO Managers (manager_id, name, grade, city)
VALUES
(1, 'John Doe', 'Senior', 'ΠΠ°ΡΠΈΠΆ'),
(2, 'Jane Smith', 'Middle', 'ΠΠΎΠ½Π΄ΠΎΠ½'),
(3, 'James Brown', 'Junior', 'ΠΠ΅ΡΠ»ΠΈΠ½'),
(4, 'Chris Wilson', 'Middle', NULL),
(5, 'Russell White', 'Junior', 'ΠΠ°Π΄ΡΠΈΠ΄'),
(6, 'Caitlin Maxwell', 'Senior', 'ΠΠ°Π΄ΡΠΈΠ΄'),
(7, 'Robert Morales', 'Senior', 'Π ΠΈΠΌ'),
(8, 'Michael Walter', NULL, 'ΠΠ°Π΄ΡΠΈΠ΄'),
(9, 'Travis Smith', 'Junior', 'ΠΠ°Π΄ΡΠΈΠ΄'),
(10, 'Abigail Collins', 'Middle', 'ΠΠΎΠ½Π΄ΠΎΠ½'),
(11, 'Victor Arnold', 'Junior', 'ΠΠ΅ΡΠ»ΠΈΠ½'),
(12, 'Emma Hayes', 'Senior', 'ΠΠ°ΡΠΈΠΆ'),
(13, NULL, 'Middle', 'Π ΠΈΠΌ'),
(14, 'Marcus Robinson', 'Junior', 'ΠΠ΅ΡΠ»ΠΈΠ½'),
(15, 'Charlotte Murray', 'Senior', 'ΠΠ°ΡΠΈΠΆ'),
(16, 'Ryan Washington', 'Junior', 'ΠΠ°Π΄ΡΠΈΠ΄'),
(17, 'Megan Austin', 'Middle', 'Π ΠΈΠΌ'),
(18, 'Evelyn Edwards', 'Middle', 'ΠΠ΅ΡΠ»ΠΈΠ½'),
(19, 'Katherine Ray', NULL, 'ΠΠΎΠ½Π΄ΠΎΠ½'),
(20, 'Sarah Ward', 'Junior', 'ΠΠ°ΡΠΈΠΆ'),
(21, 'Alexandra Spencer', 'Middle', NULL),
(22, 'Timothy Hoffman', 'Junior', 'ΠΠΎΠ½Π΄ΠΎΠ½'),
(23, 'Eric Soto', 'Senior', 'ΠΠ°Π΄ΡΠΈΠ΄'),
(24, 'Brenda Beck', 'Junior', 'ΠΠ°ΡΠΈΠΆ'),
(25, 'Sophia Schneider', 'Middle', 'ΠΠΎΠ½Π΄ΠΎΠ½'),
(26, 'Bobby Fox', 'Senior', 'ΠΠ΅ΡΠ»ΠΈΠ½'),
(27, 'Crystal Warren', 'Junior', 'Π ΠΈΠΌ'),
(28, 'Adam Tucker', 'Middle', 'ΠΠ°Π΄ΡΠΈΠ΄'),
(29, 'Denise Lowe', 'Senior', 'Π ΠΈΠΌ'),
(30, 'Matthew Russell', NULL, 'ΠΠΎΠ½Π΄ΠΎΠ½'),
(31, 'Samantha Murphy', 'Middle', 'ΠΠ΅ΡΠ»ΠΈΠ½'),
(32, 'Diana Hopkins', 'Junior', 'ΠΠ°ΡΠΈΠΆ'),
(33, 'Jack Anderson', 'Senior', 'ΠΠ°Π΄ΡΠΈΠ΄'),
(34, 'Heather Carroll', 'Junior', 'ΠΠ΅ΡΠ»ΠΈΠ½'),
(35, 'David Gutierrez', 'Middle', 'Π ΠΈΠΌ'),
(36, 'Julie Graham', 'Senior', 'ΠΠ°ΡΠΈΠΆ'),
(37, 'Anthony Hernandez', 'Junior', 'ΠΠ°Π΄ΡΠΈΠ΄'),
(38, 'Melanie Webb', 'Middle', 'ΠΠΎΠ½Π΄ΠΎΠ½'),
(39, 'Christina Burton', 'Senior', 'Π ΠΈΠΌ'),
(40, 'Harold Perry', 'Junior', 'ΠΠ°Π΄ΡΠΈΠ΄'),
(41, 'Jesse Robertson', 'Middle', NULL),
(42, 'Gloria Duncan', 'Junior', 'ΠΠ΅ΡΠ»ΠΈΠ½'),
(43, 'Bruce Daniels', 'Senior', 'ΠΠ°ΡΠΈΠΆ'),
(44, 'Rebecca Watson', 'Middle', 'ΠΠ΅ΡΠ»ΠΈΠ½'),
(45, 'Zachary Knight', 'Junior', 'Π ΠΈΠΌ'),
(46, 'Nathan Grant', 'Senior', 'ΠΠ°ΡΠΈΠΆ'),
(47, 'Julia Jenkins', 'Middle', 'ΠΠ°Π΄ΡΠΈΠ΄'),
(48, 'Sara Lane', 'Senior', 'ΠΠ΅ΡΠ»ΠΈΠ½'),
(49, 'Christina Kelly', NULL, 'ΠΠ°ΡΠΈΠΆ'),
(50, 'Chris Wilson', 'Middle', 'ΠΠ°Π΄ΡΠΈΠ΄');
SELECT * FROM Managers;
CREATE TABLE Loyalty (
loyalty_id INT PRIMARY KEY,
discount DECIMAL(3, 2),
name VARCHAR(50)
);
INSERT INTO Loyalty (loyalty_id, discount, name)
VALUES
(1, 0.05, 'Bronze'),
(2, 0.10, 'Silver'),
(3, 0.15, 'Gold'),
(4, 0.20, 'Platinum'),
(5, 0.25, 'Diamond');
SELECT * FROM Loyalty;
CREATE TABLE Clients (
client_id INT PRIMARY KEY,
reg_date DATE,
age INT,
phone VARCHAR(50),
loyalty_id INT,
FOREIGN KEY (loyalty_id) REFERENCES Loyalty(loyalty_id)
);
INSERT INTO Clients (client_id, reg_date, age, phone, loyalty_id)
VALUES
(1, '2021-03-10', 28, '123-456-7890', 1),
(2, '2020-11-15', 35, '123-456-7891', NULL),
(3, NULL, 22, '123-456-7892', 2),
(4, '2024-01-31', 40, '(954)626-4329x539', 3),
(5, '2023-07-01', 52, '+1-694-911-8641x4917', 2),
(6, '2023-11-25', 47, '+1-911-113-9550x32020', 3),
(7, '2021-11-16', NULL, '+1-846-404-3386x00290', 3),
(8, '2023-01-01', 39, '383.278.8258', 3),
(9, '2023-05-17', 20, '+1-689-713-4760x46391', 5),
(10, '2024-05-29', 43, '942-640-0789', 5),
(11, '2024-05-01', 52, '(067)510-8482', 5),
(12, '2022-03-24', 26, NULL, 3),
(13, '2024-01-26', 63, '288.635.4193', 5),
(14, '2024-06-07', 44, '(476)406-1624x163', 5),
(15, '2021-09-21', 18, '(510)064-3482x064', 3),
(16, '2022-12-25', 54, '+1-601-785-2984x5326', 4),
(17, '2023-05-31', 67, '265.851.6353x05257', 2),
(18, '2024-05-27', 30, '(240)016-1892x2059', NULL),
(19, '2023-12-01', 55, '001-852-229-1955x655', 4),
(20, '2023-07-04', 48, '(520)416-1890x38456', 4),
(21, '2021-10-05', 39, '797.212.5596x41264', 1),
(22, '2022-09-01', 55, '+1-108-707-2097x81440', 1),
(23, '2023-08-20', 30, '001-521-370-3769x4106', 1),
(24, '2022-12-25', 62, '362-138-6912', 4),
(25, '2024-08-24', 66, '+1-841-095-2103x865', 4),
(26, '2023-04-02', 38, '859.776.3852', 3),
(27, '2024-02-20', 59, NULL, 4),
(28, '2022-08-11', 31, '(722)881-6836', 4),
(29, '2022-07-04', 68, '+1-830-204-1619x90606', 3),
(30, '2024-01-02', 20, '8672579809', 1),
(31, '2022-09-20', 68, '611-928-3059x06292', 1),
(32, '2023-04-18', 27, '2740110882', 3),
(33, '2023-05-12', 57, '279.583.4715', 3),
(34, '2021-12-11', 44, '320-022-6982x173', 4),
(35, '2022-06-29', 32, '+1-513-394-5243', 4),
(36, '2022-06-24', 55, '(160)894-7519x714', NULL),
(37, '2022-07-07', 50, '994.476.3928x768', 3),
(38, '2022-05-29', 53, '853-572-4723', 5),
(39, '2024-05-03', 56, '669.769.4391x46398', 5),
(40, '2024-02-09', 57, '120-525-1950', 1),
(41, '2024-01-28', 39, '833.734.1709x6146', 4),
(42, '2023-07-11', 19, '6363156683', 2),
(43, '2021-11-24', 55, '001-149-641-2882', 4),
(44, '2024-08-26', 40, '+1-584-513-3913x573', 1),
(45, '2021-11-22', 23, '001-158-499-0884x281', 4),
(46, '2022-05-06', 36, '8026271708', 3),
(47, '2022-02-13', 21, '032-375-4967x2171', 2),
(48, '2022-01-17', 27, '(046)433-5339', 4),
(49, '2023-09-26', 25, '236.359.9593', NULL),
(50, '2023-01-17', 48, '123-456-7893', 4);
SELECT * FROM Clients;
CREATE TABLE Products (
product_id INT PRIMARY KEY,
category VARCHAR(50),
product_name VARCHAR(255),
price DECIMAL(10, 2),
stock INT
);
INSERT INTO Products (product_id, category, product_name, price, stock)
VALUES
-- ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°
(1, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'Π‘ΠΌΠ°ΡΡΡΠΎΠ½ X', 699.99, 120),
(2, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΠΎΡΡΠ±ΡΠΊ Pro 15', 1199.99, 50),
(3, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'Π’Π΅Π»Π΅Π²ΠΈΠ·ΠΎΡ Smart 55"', 799.99, 30),
(4, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΠ³ΡΠΎΠ²Π°Ρ ΠΊΠΎΠ½ΡΠΎΠ»Ρ NextGen', 499.99, 60),
(5, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΠΎΠ½ΠΈΡΠΎΡ UltraHD', 349.99, 40),
(6, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΠ°ΠΌΠ΅ΡΠ° FullFrame', 1299.99, 25),
(7, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'Π‘ΠΈΡΡΠ΅ΠΌΠ° Π΄ΠΎΠΌΠ°ΡΠ½Π΅Π³ΠΎ ΠΊΠΈΠ½ΠΎΡΠ΅Π°ΡΡΠ°', 1599.99, 10),
(8, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΡΠ°ΡΠΈΡΠ΅ΡΠΊΠΈΠΉ ΠΏΠ»Π°Π½ΡΠ΅Ρ DesignPad', 499.99, 35),
(9, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'Π‘Π΅ΡΠ΅Π²ΠΎΠΉ ΠΌΠ°ΡΡΡΡΡΠΈΠ·Π°ΡΠΎΡ FastNet', 149.99, 70),
(10, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'SSD Π΄ΠΈΡΠΊ 1TB', 129.99, 100),
-- ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°
(11, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'Π‘ΡΠΈΡΠ°Π»ΡΠ½Π°Ρ ΠΌΠ°ΡΠΈΠ½Π° AutoClean', 599.99, 25),
(12, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'Π₯ΠΎΠ»ΠΎΠ΄ΠΈΠ»ΡΠ½ΠΈΠΊ FrostFree', 999.99, 15),
(13, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΠΈΠΊΡΠΎΠ²ΠΎΠ»Π½ΠΎΠ²Π°Ρ ΠΏΠ΅ΡΡ SmartCook', 199.99, 80),
(14, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΡΠ»Π΅ΡΠΎΡ TurboClean', 299.99, 70),
(15, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'Π£ΡΡΠ³ SteamPro', 89.99, 120),
(16, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΡΠ»ΡΡΠΈΠ²Π°ΡΠΊΠ° MultiCooker', 149.99, 50),
(17, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΡΠΈΡΡΠΈΡΠ΅Π»Ρ Π²ΠΎΠ·Π΄ΡΡ
Π° FreshAir', 399.99, 30),
(18, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΠΎΡΠ΅ΠΌΠ°ΡΠΈΠ½Π° BaristaPro', 499.99, 20),
(19, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΠΎΠ΄ΠΎΠ½Π°Π³ΡΠ΅Π²Π°ΡΠ΅Π»Ρ HeatUp', 799.99, 15),
(20, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'Π£ΠΌΠ½ΡΠΉ ΠΏΡΠ»Π΅ΡΠΎΡ RoboVac', 599.99, 40),
-- ΠΠ°Π΄ΠΆΠ΅ΡΡ
(21, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'Π‘ΠΌΠ°ΡΡ-ΡΠ°ΡΡ FitTech', 199.99, 100),
(22, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'ΠΠ°ΡΡΠ½ΠΈΠΊΠΈ NoiseCancel', 149.99, 150),
(23, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'ΠΠΎΡΡΠ°ΡΠΈΠ²Π½Π°Ρ ΠΊΠΎΠ»ΠΎΠ½ΠΊΠ° BoomSound', 129.99, 60),
(24, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½Π½Π°Ρ ΠΊΠ½ΠΈΠ³Π° E-Reader', 249.99, 40),
(25, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'ΠΠ½Π΅ΡΠ½ΠΈΠΉ Π°ΠΊΠΊΡΠΌΡΠ»ΡΡΠΎΡ PowerBank', 49.99, 200),
(26, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'Π£ΠΌΠ½Π°Ρ Π»Π°ΠΌΠΏΠ° LightControl', 29.99, 300),
(27, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'ΠΠ»Π°Π²ΠΈΠ°ΡΡΡΠ° Mechanical Pro', 99.99, 80),
(28, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'Π‘ΠΌΠ°ΡΡ-Π·Π°ΠΌΠΎΠΊ SecureLock', 199.99, 40),
(29, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'Π£ΠΌΠ½ΡΠ΅ ΠΎΡΠΊΠΈ VisionTech', 299.99, 50),
(30, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'ΠΠ΅ΠΉΠΌΠΏΠ°Π΄ GameMaster', 79.99, 100),
-- ΠΠΎΠΏΠΎΠ»Π½ΠΈΡΠ΅Π»ΡΠ½ΡΠ΅ ΡΠΎΠ²Π°ΡΡ Π΄Π»Ρ Π·Π°ΠΏΠΎΠ»Π½Π΅Π½ΠΈΡ
(31, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'Π£ΠΌΠ½Π°Ρ ΡΠΎΠ·Π΅ΡΠΊΠ° SmartPlug', 39.99, 200),
(32, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'Wi-Fi Π°Π΄Π°ΠΏΡΠ΅Ρ SpeedBoost', 24.99, 150),
(33, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'Bluetooth Π°Π΄Π°ΠΏΡΠ΅Ρ', 19.99, 180),
(34, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΠ°ΡΡΠ΄Π½ΠΎΠ΅ ΡΡΡΡΠΎΠΉΡΡΠ²ΠΎ QuickCharge', 29.99, 220),
(35, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΠ΅Π±-ΠΊΠ°ΠΌΠ΅ΡΠ° HD Pro', 89.99, 60),
(36, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΠ»Π΅ΠΊΡΡΠΈΡΠ΅ΡΠΊΠΈΠΉ ΡΠ°ΠΉΠ½ΠΈΠΊ SmartKettle', 69.99, 90),
(37, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'Π€Π΅Π½ HairDryerPro', 49.99, 100),
(38, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'Π’ΠΎΡΡΠ΅Ρ BreadMaster', 39.99, 80),
(39, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΠ»Π΅ΠΊΡΡΠΎΠ³ΡΠΈΠ»Ρ GrillEasy', 89.99, 50),
(40, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'Π£Π²Π»Π°ΠΆΠ½ΠΈΡΠ΅Π»Ρ Π²ΠΎΠ·Π΄ΡΡ
Π°', 119.99, 40),
(41, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'Π ΡΡΠ½ΠΎΠΉ ΡΡΠ°Π±ΠΈΠ»ΠΈΠ·Π°ΡΠΎΡ Π΄Π»Ρ ΡΠΌΠ°ΡΡΡΠΎΠ½Π°', 99.99, 70),
(42, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'ΠΠ°ΡΡΠ° ΠΏΠ°ΠΌΡΡΠΈ 128GB', 29.99, 300),
(43, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'ΠΠΎΠ»ΡΡΠ΅Π²Π°Ρ Π»Π°ΠΌΠΏΠ° Π΄Π»Ρ Π±Π»ΠΎΠ³Π΅ΡΠΎΠ²', 49.99, 90),
(44, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'ΠΠΈΡΡΡΠ°Π»ΡΠ½ΡΠ΅ ΠΎΡΠΊΠΈ VRPro', 399.99, 25),
(45, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'ΠΠΈΠΊΡΠΎΡΠΎΠ½ USB Studio', 79.99, 60),
-- ΠΠ°ΠΏΠΎΠ»Π½Π΅Π½ΠΈΠ΅ Π΄ΠΎ 100 ΡΠΎΠ²Π°ΡΠΎΠ²
(46, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'Π¦ΠΈΡΡΠΎΠ²ΠΎΠΉ ΡΠΎΡΠΎΠ°ΠΏΠΏΠ°ΡΠ°Ρ Compact', 299.99, 30),
(47, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΡΠΎΠ΅ΠΊΡΠΎΡ HD Mini', 399.99, 20),
(48, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'Π‘Π°ΡΠ½Π΄Π±Π°Ρ', 499.99, 25),
(49, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΠ°Π±Π΅Π»Ρ HDMI 4K', 19.99, 300),
(50, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΠ°ΡΠ°ΡΠ΅ΠΉΠΊΠΈ AA (12 ΡΡ.)', 12.99, 500),
(51, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΠΈΠ½ΠΈ-Ρ
ΠΎΠ»ΠΎΠ΄ΠΈΠ»ΡΠ½ΠΈΠΊ', 299.99, 20),
(52, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'Π‘ΠΎΠΊΠΎΠ²ΡΠΆΠΈΠΌΠ°Π»ΠΊΠ°', 159.99, 30),
(53, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΠ°ΡΠΎΠ²Π°ΡΠΊΠ°', 79.99, 40),
(54, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'Π’Π΅ΡΠΌΠΎΠΏΠΎΡ', 149.99, 25),
(55, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΠΎΡΡΠ°ΡΠΈΠ²Π½ΡΠΉ Π²Π΅Π½ΡΠΈΠ»ΡΡΠΎΡ', 39.99, 150),
(56, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'ΠΠ³ΡΠΎΠ²Π°Ρ ΠΌΡΡΡ ProMouse', 49.99, 80),
(57, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'ΠΠ³ΡΠΎΠ²Π°Ρ ΠΊΠ»Π°Π²ΠΈΠ°ΡΡΡΠ° ProKey', 99.99, 50),
(58, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'Π£ΠΌΠ½ΡΠ΅ Π²Π΅ΡΡ BodyTrack', 69.99, 90),
(59, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'Π’Π΅ΡΠΌΠΎΠΊΡΡΠΆΠΊΠ° Ρ ΠΏΠΎΠ΄ΠΎΠ³ΡΠ΅Π²ΠΎΠΌ', 39.99, 120),
(60, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'Π‘Π΅Π»ΡΠΈ-ΠΏΠ°Π»ΠΊΠ°', 19.99, 300),
(61, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'Π£ΡΠΈΠ»ΠΈΡΠ΅Π»Ρ ΡΠΈΠ³Π½Π°Π»Π° Wi-Fi', 29.99, 150),
(62, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΠ°Π±Π΅Π»Ρ USB-C 1ΠΌ', 9.99, 400),
(63, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΠΎΠΊ-ΡΡΠ°Π½ΡΠΈΡ Π΄Π»Ρ Π½ΠΎΡΡΠ±ΡΠΊΠ°', 99.99, 40),
(64, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'Π€Π»Π΅ΡΠΊΠ° 64GB', 19.99, 300),
(65, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΠ΅ΡΡΠΊΠΈΠΉ Π΄ΠΈΡΠΊ 2TB', 89.99, 50),
(66, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΡΠ»Π΅ΡΠΎΡ-ΡΠΎΠ±ΠΎΡ Pro', 699.99, 15),
(67, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΠ»Π΅ΠΊΡΡΠΎΠΏΠ»ΠΈΡΠ°', 499.99, 10),
(68, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΠ»Π΅Π½Π΄Π΅Ρ PowerMix', 59.99, 90),
(69, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'Π€ΡΠΈΡΡΡΠ½ΠΈΡΠ°', 129.99, 40),
(70, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΡΠ»Π΅Ρ Π΄Π»Ρ Π²ΠΎΠ΄Ρ', 199.99, 20),
(71, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'ΠΠΎΡΡΠ°ΡΠΈΠ²Π½ΡΠΉ ΠΆΠ΅ΡΡΠΊΠΈΠΉ Π΄ΠΈΡΠΊ 1TB', 49.99, 60),
(72, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'ΠΠ°ΡΠ½ΠΈΡΡΡΠ° Π΄Π»Ρ ΠΊΠΎΠΌΠΏΡΡΡΠ΅ΡΠ°', 39.99, 100),
(73, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'Π¨ΡΠ°ΡΠΈΠ² Π΄Π»Ρ ΠΊΠ°ΠΌΠ΅ΡΡ', 29.99, 70),
(74, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'Π£ΠΌΠ½Π°Ρ ΠΊΠΎΠ»ΠΎΠ½ΠΊΠ° VoiceAssistant', 99.99, 50),
(75, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'ΠΠ»Π°Π½ΡΠ΅Ρ MediaTab', 299.99, 30),
(76, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΠ³ΡΠΎΠ²ΠΎΠΉ Π½ΠΎΡΡΠ±ΡΠΊ GamerPro', 1999.99, 10),
(77, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΡΠ°ΡΠΈΡΠ΅ΡΠΊΠ°Ρ ΠΊΠ°ΡΡΠ° GTX 3080', 799.99, 5),
(78, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΠ°ΡΠ΅ΡΠΈΠ½ΡΠΊΠ°Ρ ΠΏΠ»Π°ΡΠ° GamerBoard', 199.99, 20),
(79, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΡΠΎΡΠ΅ΡΡΠΎΡ Intel i7', 299.99, 15),
(80, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΠΏΠ΅ΡΠ°ΡΠΈΠ²Π½Π°Ρ ΠΏΠ°ΠΌΡΡΡ 16GB', 99.99, 25),
(81, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΠ»Π΅ΠΊΡΡΠΈΡΠ΅ΡΠΊΠ°Ρ ΠΏΠ»ΠΈΡΠ° Compact', 399.99, 10),
(82, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΠΈΠΊΡΠ΅Ρ ΡΡΡΠ½ΠΎΠΉ', 49.99, 80),
(83, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΡΡ
ΠΎΠ²ΠΎΠΉ ΡΠΊΠ°Ρ CompactOven', 599.99, 15),
(84, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΡΡΡΠΆΠΊΠ° ΠΊΡΡ
ΠΎΠ½Π½Π°Ρ', 299.99, 10),
(85, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'Π€ΠΈΠ»ΡΡΡ Π΄Π»Ρ Π²ΠΎΠ΄Ρ', 99.99, 100),
(86, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'ΠΠ°ΡΡΠ΄Π½ΠΎΠ΅ ΡΡΡΡΠΎΠΉΡΡΠ²ΠΎ SolarCharge', 29.99, 150),
(87, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'Π‘Π΅Π½ΡΠΎΡΠ½ΡΠΉ ΡΠΊΡΠ°Π½ Π΄Π»Ρ ΡΠΈΡΠΎΠ²Π°Π½ΠΈΡ', 149.99, 40),
(88, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'VR ΠΊΠΎΠ½ΡΡΠΎΠ»Π»Π΅ΡΡ', 199.99, 30),
(89, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'ΠΠ°Π΄ΠΆΠ΅Ρ Π΄Π»Ρ ΡΠΌΠ½ΠΎΠ³ΠΎ Π΄ΠΎΠΌΠ°', 129.99, 50),
(90, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'Π ΠΎΠ±ΠΎΡΠΈΠ·ΠΈΡΠΎΠ²Π°Π½Π½Π°Ρ ΡΡΠΊΠ°', 599.99, 10),
-- Π€ΠΈΠ½Π°Π»ΡΠ½ΡΠ΅ Π·Π°ΠΏΠΈΡΠΈ Π΄Π»Ρ Π·Π°ΠΏΠΎΠ»Π½Π΅Π½ΠΈΡ
(91, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΠ²ΡΠΊΠΎΠ²Π°Ρ ΠΊΠ°ΡΡΠ° ProAudio', 199.99, 20),
(92, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΡΠΎΡΠ΅ΡΡΠΈΠΎΠ½Π°Π»ΡΠ½ΡΠΉ ΠΌΠΎΠ½ΠΈΡΠΎΡ', 999.99, 5),
(93, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΠ°ΡΠ½ΠΈΡΡΡΠ° Π΄Π»Ρ Π²ΠΈΠ΄Π΅ΠΎΠΈΠ³Ρ', 149.99, 40),
(94, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'USB-ΠΊΠΎΠ½ΡΠ΅Π½ΡΡΠ°ΡΠΎΡ', 19.99, 300),
(95, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½Π½ΡΠΉ ΡΠ΅ΡΠΌΠΎΠΌΠ΅ΡΡ', 29.99, 200),
(96, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'Π‘ΡΡΠΈΠ»ΠΊΠ° Π΄Π»Ρ ΠΎΠ²ΠΎΡΠ΅ΠΉ', 79.99, 20),
(97, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'Π’Π΅ΡΠΌΠΎΡ', 49.99, 100),
(98, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'Π‘ΡΠΈΡΠ°Π»ΡΠ½ΡΠΉ ΠΏΠΎΡΠΎΡΠΎΠΊ Π°Π²ΡΠΎΠΌΠ°Ρ', 19.99, 500),
(99, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΠ»Π°Π΄ΠΈΠ»ΡΠ½Π°Ρ Π΄ΠΎΡΠΊΠ°', 89.99, 30),
(100, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½Π½ΡΠ΅ Π²Π΅ΡΡ', 29.99, 200),
(101, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΠ³ΡΠΎΠ²Π°Ρ ΠΊΠΎΠ½ΡΠΎΠ»Ρ', 450.00, 45),
(102, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'Π£ΠΌΠ½ΡΠΉ Π±ΡΠ°ΡΠ»Π΅Ρ', 120.00, 80),
(103, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'Π‘ΠΎΠΊΠΎΠ²ΡΠΆΠΈΠΌΠ°Π»ΠΊΠ°', 220.00, 30),
(104, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΠΎΠΌΠ°ΡΠ½ΠΈΠΉ ΠΏΡΠΎΠ΅ΠΊΡΠΎΡ', 700.00, 15),
(105, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'Π ΠΎΠ±ΠΎΡ-ΠΏΡΠ»Π΅ΡΠΎΡ', 350.00, 25),
(106, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΡΠ»ΡΡΠΈΠ²Π°ΡΠΊΠ°', 180.00, 40),
(107, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'Π‘Π΅ΡΠ΅Π²ΠΎΠΉ Π°Π΄Π°ΠΏΡΠ΅Ρ', 15.00, 300),
(108, 'ΠΠ°Π΄ΠΆΠ΅ΡΡ', 'Π‘ΠΌΠ°ΡΡ-ΠΊΠ°ΠΌΠ΅ΡΠ°', 250.00, 35),
(109, 'ΠΡΡΠΎΠ²Π°Ρ ΡΠ΅Ρ
Π½ΠΈΠΊΠ°', 'ΠΠΎΡΠ΅Π²Π°ΡΠΊΠ°', 270.00, 20),
(110, 'ΠΠ»Π΅ΠΊΡΡΠΎΠ½ΠΈΠΊΠ°', 'ΠΠΎΠΌΠ°ΡΠ½ΠΈΠΉ ΡΠ΅ΡΠ²Π΅Ρ', 1200.00, 5);
SELECT * FROM Products;
CREATE TABLE Orders (
order_id INT PRIMARY KEY,
date DATE,
time TIME,
sum DECIMAL(10, 2),
quantity INT,
product_id INT,
client_id INT,
manager_id INT,
FOREIGN KEY (client_id) REFERENCES Clients(client_id),
FOREIGN KEY (manager_id) REFERENCES Managers(manager_id)
);
INSERT INTO Orders (order_id, date, time, sum, quantity, product_id, client_id, manager_id)
VALUES
(1, '2023-05-10', '12:00:00', 1000.50, 2, 101, 1, 2),
(2, '2022-07-15', '15:45:00', 500.00, 1, 102, 2, 3),
(3, '2024-01-20', '18:30:00', 1500.75, 3, 103, 3, 1),
(4, '2024-05-18', '07:42:50', 334.47, 8, 32, 15, 20),
(5, '2023-05-24', '19:47:40', 638.64, 7, 34, 43, 44),
(6, '2023-11-13', '00:16:21', 824.96, 7, 95, 36, 30),
(7, '2024-04-12', '12:12:39', 480.12, 10, 47, 4, 8),
(8, '2023-09-24', '08:55:20', 915.41, 4, 25, 38, 35),
(9, '2022-12-14', '11:39:50', 407.84, 3, 56, 36, 8),
(10, '2022-11-09', '13:55:03', 795.04, 4, 73, 6, 36),
(11, '2022-10-23', '12:22:44', 809.87, 1, 13, 12, 10),
(12, '2023-04-18', '11:30:33', 761.85, 8, 15, 3, 28),
(13, '2023-04-12', '07:19:55', 252.93, 4, 3, 22, 20),
(14, '2023-03-30', '22:44:52', 39.25, 9, 93, 2, 9),
(15, '2023-04-16', '18:20:37', 168.50, 5, 21, 26, 37),
(16, '2023-10-07', '02:03:52', 823.47, 3, 43, 16, 45),
(17, '2023-12-09', '21:46:26', 358.19, 4, 12, 15, 38),
(18, '2022-10-19', '20:53:31', 118.23, 10, 66, 18, 13),
(19, '2024-05-07', '13:33:07', 655.96, 5, 24, 37, 49),
(20, '2022-10-11', '10:50:38', 454.41, 7, 53, 29, 11),
(21, '2024-04-14', '03:46:15', 935.08, 7, 30, 1, 31),
(22, '2024-09-02', '23:06:57', 315.26, 8, 49, 38, 48),
(23, '2023-04-12', '07:12:55', 337.49, 1, 71, 15, 26),
(24, '2024-06-27', '10:15:15', 453.28, 4, 1, 15, 48),
(25, '2024-08-30', '17:43:31', 990.63, 6, 92, 34, 19),
(26, '2023-04-28', '20:00:16', 469.60, 8, 6, 36, 26),
(27, '2023-12-21', '04:56:59', 210.82, 7, 11, 22, 19),
(28, '2024-03-25', '19:06:36', 950.56, 4, 24, 4, 41),
(29, '2022-10-26', '06:14:55', 460.71, 7, 65, 38, 28),
(30, '2022-12-04', '01:50:03', 743.50, 4, 86, 14, 19),
(31, '2024-02-21', '16:34:06', 293.36, 1, 66, 32, 26),
(32, '2023-05-05', '20:32:33', 806.34, 5, 81, 28, 46),
(33, '2024-03-06', '21:49:44', 460.08, 10, 93, 3, 18),
(34, '2023-07-10', '00:23:26', 524.57, 2, 13, 22, 12),
(35, '2023-11-25', '02:27:15', 561.76, 7, 15, 5, 22),
(36, '2022-11-17', '16:56:56', 75.83, 5, 51, 31, 43),
(37, '2024-03-10', '14:59:15', 97.69, 6, 20, 14, 14),
(38, '2024-07-20', '17:43:55', 846.69, 2, 37, 47, 8),
(39, '2023-12-26', '23:06:11', 751.65, 8, 87, 14, 13),
(40, '2023-02-17', '19:32:25', 392.24, 2, 26, 26, 27),
(41, '2023-03-30', '18:50:12', 664.12, 7, 82, 50, 41),
(42, '2024-07-11', '19:53:00', 183.33, 7, 9, 24, 3),
(43, '2024-07-09', '08:26:37', 210.74, 2, 55, 23, 10),
(44, '2024-05-12', '02:58:11', 640.16, 7, 83, 23, 18),
(45, '2022-10-02', '17:24:03', 328.50, 2, 80, 5, 32),
(46, '2023-04-27', '20:09:22', 407.60, 5, 99, 30, 26),
(47, '2023-09-04', '23:50:02', 957.65, 10, 27, 32, 13),
(48, '2024-05-13', '01:14:38', 946.13, 4, 69, 41, 39),
(49, '2024-05-29', '15:09:07', 926.29, 6, 86, 17, 12),
(50, '2023-09-30', '09:00:00', 750.20, 1, 110, 50, 1);
SELECT * FROM Orders;
-- 1a. ΠΠ°ΠΉΠ΄ΠΈΡΠ΅ ΠΈΠ½ΡΠΎΡΠΌΠ°ΡΠΈΡ ΠΎ Π·Π°ΠΊΠ°Π·Π°Ρ
, Π΄Π»Ρ ΠΊΠΎΡΠΎΡΡΡ
ΡΠΊΠ°Π·Π°Π½Ρ ΠΊΠ°ΠΊ ΠΊΠ»ΠΈΠ΅Π½Ρ,
-- Π΅Π³ΠΎ ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΠ° Π»ΠΎΡΠ»ΡΠ½ΠΎΡΡΠΈ ΠΈ ΠΌΠ΅Π½Π΅Π΄ΠΆΠ΅Ρ.
-- ΠΡΠ²Π΅Π΄ΠΈΡΠ΅:
-- β Π½ΠΎΠΌΠ΅Ρ Π·Π°ΠΊΠ°Π·Π°,
-- β ID ΠΊΠ»ΠΈΠ΅Π½ΡΠ° ΠΈ Π΅Π³ΠΎ Π½ΠΎΠΌΠ΅Ρ ΡΠ΅Π»Π΅ΡΠΎΠ½Π°,
-- β Π½Π°Π·Π²Π°Π½ΠΈΠ΅ ΠΈ ΡΠ°Π·ΠΌΠ΅Ρ ΡΠΊΠΈΠ΄ΠΊΠΈ ΠΏΠΎ ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΠ΅ Π»ΠΎΡΠ»ΡΠ½ΠΎΡΡΠΈ,
-- β ΠΈΠΌΡ ΠΌΠ΅Π½Π΅Π΄ΠΆΠ΅ΡΠ°.
SELECT
o.order_id,
c.client_id,
c.phone,
l.discount,
l.name AS loyalty_name,
m.name AS manager_name
FROM
Orders o
JOIN
Clients c ON c.client_id = o.client_id
JOIN
Loyalty l ON l.loyalty_id = c.loyalty_id
JOIN
Managers m ON m.manager_id = o.manager_id;
Telegram: DB developers channel