retail_sales_mysql.sql

-- ================================================
-- Retail Sales Database — MySQL Dump File
-- ================================================

CREATE DATABASE IF NOT EXISTS retail_sales;
USE retail_sales;

-- ── Customers Table ────────────────────────────
DROP TABLE IF EXISTS customers;
CREATE TABLE customers (
    customer_id  INT           PRIMARY KEY,
    name         VARCHAR(100),
    city         VARCHAR(50),
    gender       VARCHAR(5),
    age          INT,
    signup_date  DATE
);

INSERT INTO customers VALUES (1, 'Amit Sharma', 'Delhi', 'M', 50, '2022-10-10');
INSERT INTO customers VALUES (2, 'Priya Singh', 'Mumbai', 'M', 36, '2022-05-31');
INSERT INTO customers VALUES (3, 'Rahul Verma', 'Chennai', 'F', 29, '2022-11-18');
INSERT INTO customers VALUES (4, 'Sneha Patel', 'Hyderabad', 'F', 42, '2022-11-13');
INSERT INTO customers VALUES (5, 'Vikram Rao', 'Hyderabad', 'F', 40, '2022-07-05');
INSERT INTO customers VALUES (6, 'Anita Nair', 'Bangalore', 'M', 44, '2022-10-23');
INSERT INTO customers VALUES (7, 'Deepak Joshi', 'Delhi', 'M', 32, '2022-04-09');
INSERT INTO customers VALUES (8, 'Meera Gupta', 'Delhi', 'F', 32, '2022-12-27');
INSERT INTO customers VALUES (9, 'Suresh Kumar', 'Kolkata', 'M', 45, '2022-02-05');
INSERT INTO customers VALUES (10, 'Nisha Mehta', 'Mumbai', 'M', 57, '2022-01-24');
INSERT INTO customers VALUES (11, 'Arjun Tiwari', 'Mumbai', 'F', 45, '2022-12-05');
INSERT INTO customers VALUES (12, 'Kavya Reddy', 'Delhi', 'M', 24, '2022-04-27');
INSERT INTO customers VALUES (13, 'Ravi Pillai', 'Hyderabad', 'F', 43, '2022-05-29');
INSERT INTO customers VALUES (14, 'Pooja Agarwal', 'Hyderabad', 'F', 23, '2022-02-10');
INSERT INTO customers VALUES (15, 'Sanjay Das', 'Mumbai', 'F', 45, '2022-04-30');
INSERT INTO customers VALUES (16, 'Divya Sharma', 'Hyderabad', 'M', 51, '2022-02-21');
INSERT INTO customers VALUES (17, 'Karan Malhotra', 'Kolkata', 'F', 59, '2022-07-14');
INSERT INTO customers VALUES (18, 'Swati Jain', 'Hyderabad', 'M', 23, '2022-05-23');
INSERT INTO customers VALUES (19, 'Rohit Pandey', 'Lucknow', 'F', 42, '2022-08-21');
INSERT INTO customers VALUES (20, 'Aisha Khan', 'Chennai', 'M', 54, '2022-11-22');

-- ── Products Table ─────────────────────────────
DROP TABLE IF EXISTS products;
CREATE TABLE products (
    product_id    INT            PRIMARY KEY,
    product_name  VARCHAR(100),
    category      VARCHAR(50),
    price         DECIMAL(10,2),
    stock         INT
);

INSERT INTO products VALUES (1, 'Laptop Pro', 'Electronics', 65000, 85);
INSERT INTO products VALUES (2, 'Smartphone X', 'Electronics', 35000, 67);
INSERT INTO products VALUES (3, 'Wireless Earbuds', 'Electronics', 4500, 31);
INSERT INTO products VALUES (4, 'Smart Watch', 'Electronics', 12000, 98);
INSERT INTO products VALUES (5, 'T-Shirt Premium', 'Clothing', 899, 58);
INSERT INTO products VALUES (6, 'Denim Jeans', 'Clothing', 1499, 68);
INSERT INTO products VALUES (7, 'Running Shoes', 'Footwear', 3200, 51);
INSERT INTO products VALUES (8, 'Backpack Elite', 'Accessories', 2500, 69);
INSERT INTO products VALUES (9, 'Coffee Maker', 'Appliances', 4800, 89);
INSERT INTO products VALUES (10, 'Air Purifier', 'Appliances', 8999, 24);

-- ── Sales Table ────────────────────────────────
DROP TABLE IF EXISTS sales;
CREATE TABLE sales (
    sale_id       INT            PRIMARY KEY,
    customer_id   INT,
    product_id    INT,
    quantity      INT,
    sale_date     DATE,
    discount      DECIMAL(5,2),
    total_amount  DECIMAL(10,2),
    FOREIGN KEY (customer_id) REFERENCES customers(customer_id),
    FOREIGN KEY (product_id)  REFERENCES products(product_id)
);

INSERT INTO sales VALUES (1, 12, 3, 3, '2023-04-18', 10, 12150.0);
INSERT INTO sales VALUES (2, 9, 2, 2, '2023-05-06', 20, 56000.0);
INSERT INTO sales VALUES (3, 6, 8, 4, '2023-11-24', 10, 9000.0);
INSERT INTO sales VALUES (4, 18, 4, 3, '2023-04-28', 0, 36000.0);
INSERT INTO sales VALUES (5, 2, 6, 4, '2023-02-03', 10, 5396.4);
INSERT INTO sales VALUES (6, 7, 10, 3, '2023-12-02', 5, 25647.15);
INSERT INTO sales VALUES (7, 16, 7, 4, '2023-05-16', 5, 12160.0);
INSERT INTO sales VALUES (8, 5, 4, 3, '2023-08-08', 20, 28800.0);
INSERT INTO sales VALUES (9, 19, 7, 3, '2023-03-12', 5, 9120.0);
INSERT INTO sales VALUES (10, 17, 8, 1, '2023-02-26', 0, 2500.0);
INSERT INTO sales VALUES (11, 5, 3, 4, '2023-02-02', 20, 14400.0);
INSERT INTO sales VALUES (12, 13, 7, 4, '2023-05-09', 20, 10240.0);
INSERT INTO sales VALUES (13, 18, 1, 1, '2023-05-17', 20, 52000.0);
INSERT INTO sales VALUES (14, 11, 2, 3, '2023-03-22', 15, 89250.0);
INSERT INTO sales VALUES (15, 15, 1, 3, '2023-04-02', 20, 156000.0);
INSERT INTO sales VALUES (16, 17, 2, 3, '2023-11-08', 20, 84000.0);
INSERT INTO sales VALUES (17, 7, 3, 3, '2023-10-04', 5, 12825.0);
INSERT INTO sales VALUES (18, 17, 1, 3, '2023-01-10', 15, 165750.0);
INSERT INTO sales VALUES (19, 4, 6, 3, '2023-01-30', 5, 4272.15);
INSERT INTO sales VALUES (20, 8, 10, 1, '2023-09-06', 0, 8999.0);
INSERT INTO sales VALUES (21, 3, 9, 2, '2023-12-04', 5, 9120.0);
INSERT INTO sales VALUES (22, 16, 9, 2, '2023-09-28', 10, 8640.0);
INSERT INTO sales VALUES (23, 20, 7, 2, '2023-12-20', 20, 5120.0);
INSERT INTO sales VALUES (24, 7, 5, 4, '2023-08-13', 10, 3236.4);
INSERT INTO sales VALUES (25, 17, 8, 1, '2023-04-26', 5, 2375.0);
INSERT INTO sales VALUES (26, 3, 6, 1, '2023-10-11', 20, 1199.2);
INSERT INTO sales VALUES (27, 8, 10, 2, '2023-02-06', 0, 17998.0);
INSERT INTO sales VALUES (28, 2, 4, 1, '2023-06-19', 0, 12000.0);
INSERT INTO sales VALUES (29, 3, 9, 2, '2023-12-09', 10, 8640.0);
INSERT INTO sales VALUES (30, 16, 4, 2, '2023-10-23', 20, 19200.0);
INSERT INTO sales VALUES (31, 16, 4, 4, '2023-04-08', 15, 40800.0);
INSERT INTO sales VALUES (32, 4, 2, 4, '2023-08-05', 10, 126000.0);
INSERT INTO sales VALUES (33, 14, 8, 1, '2023-02-01', 0, 2500.0);
INSERT INTO sales VALUES (34, 13, 6, 1, '2023-04-09', 5, 1424.05);
INSERT INTO sales VALUES (35, 7, 9, 4, '2023-08-05', 5, 18240.0);
INSERT INTO sales VALUES (36, 6, 5, 4, '2023-02-08', 5, 3416.2);
INSERT INTO sales VALUES (37, 15, 9, 1, '2023-11-30', 0, 4800.0);
INSERT INTO sales VALUES (38, 18, 1, 1, '2023-03-27', 5, 61750.0);
INSERT INTO sales VALUES (39, 14, 8, 4, '2023-07-25', 5, 9500.0);
INSERT INTO sales VALUES (40, 2, 3, 4, '2023-07-19', 0, 18000.0);
INSERT INTO sales VALUES (41, 9, 8, 3, '2023-12-23', 15, 6375.0);
INSERT INTO sales VALUES (42, 18, 8, 2, '2023-06-01', 5, 4750.0);
INSERT INTO sales VALUES (43, 7, 1, 1, '2023-01-30', 10, 58500.0);
INSERT INTO sales VALUES (44, 2, 10, 4, '2023-09-29', 20, 28796.8);
INSERT INTO sales VALUES (45, 6, 1, 1, '2023-02-05', 5, 61750.0);
INSERT INTO sales VALUES (46, 20, 2, 2, '2023-03-03', 15, 59500.0);
INSERT INTO sales VALUES (47, 19, 4, 1, '2023-02-11', 20, 9600.0);
INSERT INTO sales VALUES (48, 14, 10, 3, '2023-04-15', 10, 24297.3);
INSERT INTO sales VALUES (49, 11, 4, 3, '2023-03-09', 15, 30600.0);
INSERT INTO sales VALUES (50, 10, 8, 3, '2023-01-05', 0, 7500.0);
INSERT INTO sales VALUES (51, 15, 10, 1, '2023-10-03', 0, 8999.0);
INSERT INTO sales VALUES (52, 7, 9, 3, '2023-06-28', 5, 13680.0);
INSERT INTO sales VALUES (53, 3, 4, 3, '2023-03-22', 10, 32400.0);
INSERT INTO sales VALUES (54, 15, 9, 3, '2023-12-01', 20, 11520.0);
INSERT INTO sales VALUES (55, 17, 1, 3, '2023-03-10', 0, 195000.0);
INSERT INTO sales VALUES (56, 9, 2, 1, '2023-03-21', 20, 28000.0);
INSERT INTO sales VALUES (57, 9, 5, 2, '2023-04-15', 10, 1618.2);
INSERT INTO sales VALUES (58, 9, 9, 4, '2023-01-27', 10, 17280.0);
INSERT INTO sales VALUES (59, 3, 7, 3, '2023-01-02', 0, 9600.0);
INSERT INTO sales VALUES (60, 11, 3, 3, '2023-08-15', 5, 12825.0);
INSERT INTO sales VALUES (61, 18, 7, 1, '2023-02-08', 0, 3200.0);
INSERT INTO sales VALUES (62, 5, 9, 1, '2023-10-26', 10, 4320.0);
INSERT INTO sales VALUES (63, 18, 3, 4, '2023-01-22', 5, 17100.0);
INSERT INTO sales VALUES (64, 10, 6, 1, '2023-04-18', 10, 1349.1);
INSERT INTO sales VALUES (65, 8, 2, 3, '2023-07-28', 20, 84000.0);
INSERT INTO sales VALUES (66, 20, 3, 2, '2023-04-01', 5, 8550.0);
INSERT INTO sales VALUES (67, 14, 1, 2, '2023-07-30', 10, 117000.0);
INSERT INTO sales VALUES (68, 8, 5, 2, '2023-07-15', 0, 1798.0);
INSERT INTO sales VALUES (69, 2, 8, 2, '2023-08-24', 5, 4750.0);
INSERT INTO sales VALUES (70, 12, 5, 2, '2023-01-13', 5, 1708.1);
INSERT INTO sales VALUES (71, 7, 7, 3, '2023-02-05', 10, 8640.0);
INSERT INTO sales VALUES (72, 9, 6, 4, '2023-06-19', 20, 4796.8);
INSERT INTO sales VALUES (73, 1, 2, 3, '2023-10-25', 5, 99750.0);
INSERT INTO sales VALUES (74, 9, 1, 1, '2023-08-11', 20, 52000.0);
INSERT INTO sales VALUES (75, 12, 6, 4, '2023-09-19', 20, 4796.8);
INSERT INTO sales VALUES (76, 4, 7, 2, '2023-01-23', 10, 5760.0);
INSERT INTO sales VALUES (77, 14, 1, 2, '2023-08-09', 10, 117000.0);
INSERT INTO sales VALUES (78, 3, 6, 3, '2023-06-03', 0, 4497.0);
INSERT INTO sales VALUES (79, 17, 5, 4, '2023-07-26', 10, 3236.4);
INSERT INTO sales VALUES (80, 10, 9, 2, '2023-08-04', 5, 9120.0);
INSERT INTO sales VALUES (81, 13, 3, 3, '2023-10-08', 15, 11475.0);
INSERT INTO sales VALUES (82, 1, 5, 3, '2023-08-09', 5, 2562.15);
INSERT INTO sales VALUES (83, 19, 10, 3, '2023-08-15', 15, 22947.45);
INSERT INTO sales VALUES (84, 15, 4, 4, '2023-12-04', 5, 45600.0);
INSERT INTO sales VALUES (85, 3, 5, 3, '2023-05-01', 0, 2697.0);
INSERT INTO sales VALUES (86, 10, 4, 2, '2023-01-13', 5, 22800.0);
INSERT INTO sales VALUES (87, 2, 4, 4, '2023-02-07', 20, 38400.0);
INSERT INTO sales VALUES (88, 15, 7, 2, '2023-09-11', 15, 5440.0);
INSERT INTO sales VALUES (89, 13, 4, 2, '2023-02-24', 0, 24000.0);
INSERT INTO sales VALUES (90, 14, 4, 2, '2023-08-26', 20, 19200.0);
INSERT INTO sales VALUES (91, 2, 9, 2, '2023-08-22', 0, 9600.0);
INSERT INTO sales VALUES (92, 5, 8, 3, '2023-11-10', 15, 6375.0);
INSERT INTO sales VALUES (93, 17, 7, 4, '2023-09-01', 5, 12160.0);
INSERT INTO sales VALUES (94, 15, 5, 2, '2023-09-24', 10, 1618.2);
INSERT INTO sales VALUES (95, 16, 4, 3, '2023-02-09', 15, 30600.0);
INSERT INTO sales VALUES (96, 10, 4, 3, '2023-06-13', 10, 32400.0);
INSERT INTO sales VALUES (97, 18, 2, 2, '2023-04-29', 5, 66500.0);
INSERT INTO sales VALUES (98, 13, 3, 2, '2023-08-01', 0, 9000.0);
INSERT INTO sales VALUES (99, 14, 6, 4, '2023-02-01', 15, 5096.6);
INSERT INTO sales VALUES (100, 7, 7, 4, '2023-12-23', 20, 10240.0);
INSERT INTO sales VALUES (101, 1, 10, 4, '2023-01-04', 15, 30596.6);
INSERT INTO sales VALUES (102, 12, 5, 4, '2023-10-03', 15, 3056.6);
INSERT INTO sales VALUES (103, 18, 10, 2, '2023-04-23', 15, 15298.3);
INSERT INTO sales VALUES (104, 9, 7, 4, '2023-07-19', 0, 12800.0);
INSERT INTO sales VALUES (105, 11, 7, 2, '2023-03-07', 15, 5440.0);
INSERT INTO sales VALUES (106, 20, 9, 1, '2023-10-31', 15, 4080.0);
INSERT INTO sales VALUES (107, 19, 1, 1, '2023-03-11', 15, 55250.0);
INSERT INTO sales VALUES (108, 15, 3, 1, '2023-07-14', 10, 4050.0);
INSERT INTO sales VALUES (109, 11, 4, 4, '2023-06-22', 10, 43200.0);
INSERT INTO sales VALUES (110, 13, 5, 4, '2023-02-11', 10, 3236.4);
INSERT INTO sales VALUES (111, 16, 1, 1, '2023-04-25', 10, 58500.0);
INSERT INTO sales VALUES (112, 3, 1, 1, '2023-04-13', 5, 61750.0);
INSERT INTO sales VALUES (113, 1, 10, 2, '2023-03-06', 5, 17098.1);
INSERT INTO sales VALUES (114, 16, 2, 2, '2023-12-25', 15, 59500.0);
INSERT INTO sales VALUES (115, 9, 6, 2, '2023-11-07', 20, 2398.4);
INSERT INTO sales VALUES (116, 4, 3, 3, '2023-10-24', 0, 13500.0);
INSERT INTO sales VALUES (117, 1, 5, 4, '2023-04-12', 15, 3056.6);
INSERT INTO sales VALUES (118, 3, 10, 2, '2023-12-23', 0, 17998.0);
INSERT INTO sales VALUES (119, 10, 10, 1, '2023-01-22', 20, 7199.2);
INSERT INTO sales VALUES (120, 12, 9, 4, '2023-02-05', 10, 17280.0);
INSERT INTO sales VALUES (121, 17, 6, 1, '2023-09-08', 15, 1274.15);
INSERT INTO sales VALUES (122, 4, 7, 3, '2023-12-29', 15, 8160.0);
INSERT INTO sales VALUES (123, 5, 7, 2, '2023-11-30', 20, 5120.0);
INSERT INTO sales VALUES (124, 9, 10, 4, '2023-08-12', 15, 30596.6);
INSERT INTO sales VALUES (125, 19, 5, 3, '2023-02-14', 5, 2562.15);
INSERT INTO sales VALUES (126, 9, 8, 2, '2023-10-19', 15, 4250.0);
INSERT INTO sales VALUES (127, 20, 7, 3, '2023-09-11', 0, 9600.0);
INSERT INTO sales VALUES (128, 11, 3, 4, '2023-07-01', 5, 17100.0);
INSERT INTO sales VALUES (129, 9, 6, 3, '2023-12-26', 20, 3597.6);
INSERT INTO sales VALUES (130, 9, 9, 1, '2023-04-08', 20, 3840.0);
INSERT INTO sales VALUES (131, 3, 4, 4, '2023-10-12', 15, 40800.0);
INSERT INTO sales VALUES (132, 8, 8, 4, '2023-01-09', 15, 8500.0);
INSERT INTO sales VALUES (133, 3, 5, 2, '2023-12-21', 15, 1528.3);
INSERT INTO sales VALUES (134, 8, 5, 3, '2023-10-11', 15, 2292.45);
INSERT INTO sales VALUES (135, 17, 6, 4, '2023-06-19', 20, 4796.8);
INSERT INTO sales VALUES (136, 12, 8, 3, '2023-05-09', 10, 6750.0);
INSERT INTO sales VALUES (137, 8, 2, 2, '2023-03-03', 10, 63000.0);
INSERT INTO sales VALUES (138, 18, 3, 2, '2023-09-05', 5, 8550.0);
INSERT INTO sales VALUES (139, 9, 10, 3, '2023-04-10', 0, 26997.0);
INSERT INTO sales VALUES (140, 10, 4, 3, '2023-06-04', 5, 34200.0);
INSERT INTO sales VALUES (141, 1, 9, 2, '2023-01-24', 10, 8640.0);
INSERT INTO sales VALUES (142, 2, 9, 3, '2023-11-23', 5, 13680.0);
INSERT INTO sales VALUES (143, 16, 2, 1, '2023-05-26', 20, 28000.0);
INSERT INTO sales VALUES (144, 16, 8, 4, '2023-04-05', 10, 9000.0);
INSERT INTO sales VALUES (145, 2, 5, 4, '2023-02-03', 0, 3596.0);
INSERT INTO sales VALUES (146, 13, 8, 1, '2023-11-19', 20, 2000.0);
INSERT INTO sales VALUES (147, 2, 3, 2, '2023-06-05', 20, 7200.0);
INSERT INTO sales VALUES (148, 3, 4, 1, '2023-08-02', 20, 9600.0);
INSERT INTO sales VALUES (149, 20, 10, 2, '2023-07-14', 20, 14398.4);
INSERT INTO sales VALUES (150, 15, 8, 3, '2023-08-08', 20, 6000.0);
INSERT INTO sales VALUES (151, 10, 10, 1, '2023-02-20', 20, 7199.2);
INSERT INTO sales VALUES (152, 7, 4, 3, '2023-03-22', 0, 36000.0);
INSERT INTO sales VALUES (153, 8, 3, 1, '2023-01-02', 5, 4275.0);
INSERT INTO sales VALUES (154, 14, 8, 4, '2023-01-17', 10, 9000.0);
INSERT INTO sales VALUES (155, 8, 5, 3, '2023-02-06', 15, 2292.45);
INSERT INTO sales VALUES (156, 8, 5, 2, '2023-02-28', 15, 1528.3);
INSERT INTO sales VALUES (157, 18, 4, 2, '2023-03-14', 10, 21600.0);
INSERT INTO sales VALUES (158, 3, 1, 2, '2023-11-01', 10, 117000.0);
INSERT INTO sales VALUES (159, 19, 5, 4, '2023-08-28', 0, 3596.0);
INSERT INTO sales VALUES (160, 10, 7, 3, '2023-10-04', 20, 7680.0);
INSERT INTO sales VALUES (161, 16, 8, 1, '2023-01-21', 20, 2000.0);
INSERT INTO sales VALUES (162, 14, 6, 3, '2023-02-16', 0, 4497.0);
INSERT INTO sales VALUES (163, 8, 10, 1, '2023-10-23', 10, 8099.1);
INSERT INTO sales VALUES (164, 2, 3, 4, '2023-11-30', 20, 14400.0);
INSERT INTO sales VALUES (165, 15, 5, 2, '2023-08-12', 20, 1438.4);
INSERT INTO sales VALUES (166, 16, 2, 4, '2023-07-29', 10, 126000.0);
INSERT INTO sales VALUES (167, 11, 6, 1, '2023-06-18', 5, 1424.05);
INSERT INTO sales VALUES (168, 14, 8, 3, '2023-10-09', 15, 6375.0);
INSERT INTO sales VALUES (169, 2, 8, 1, '2023-05-10', 10, 2250.0);
INSERT INTO sales VALUES (170, 11, 2, 4, '2023-01-01', 20, 112000.0);
INSERT INTO sales VALUES (171, 18, 8, 4, '2023-04-07', 0, 10000.0);
INSERT INTO sales VALUES (172, 17, 6, 4, '2023-01-27', 15, 5096.6);
INSERT INTO sales VALUES (173, 7, 5, 2, '2023-08-13', 10, 1618.2);
INSERT INTO sales VALUES (174, 16, 2, 1, '2023-05-03', 20, 28000.0);
INSERT INTO sales VALUES (175, 6, 5, 1, '2023-07-28', 20, 719.2);
INSERT INTO sales VALUES (176, 3, 4, 1, '2023-03-02', 15, 10200.0);
INSERT INTO sales VALUES (177, 5, 8, 3, '2023-12-28', 20, 6000.0);
INSERT INTO sales VALUES (178, 9, 7, 4, '2023-05-05', 15, 10880.0);
INSERT INTO sales VALUES (179, 15, 9, 2, '2023-04-08', 15, 8160.0);
INSERT INTO sales VALUES (180, 20, 9, 2, '2023-05-22', 0, 9600.0);
INSERT INTO sales VALUES (181, 14, 6, 3, '2023-05-25', 0, 4497.0);
INSERT INTO sales VALUES (182, 10, 10, 4, '2023-08-17', 5, 34196.2);
INSERT INTO sales VALUES (183, 18, 8, 3, '2023-10-10', 10, 6750.0);
INSERT INTO sales VALUES (184, 18, 7, 4, '2023-04-07', 10, 11520.0);
INSERT INTO sales VALUES (185, 8, 10, 4, '2023-07-30', 5, 34196.2);
INSERT INTO sales VALUES (186, 2, 6, 4, '2023-07-17', 15, 5096.6);
INSERT INTO sales VALUES (187, 5, 8, 1, '2023-09-15', 5, 2375.0);
INSERT INTO sales VALUES (188, 19, 6, 1, '2023-02-21', 15, 1274.15);
INSERT INTO sales VALUES (189, 17, 8, 1, '2023-07-29', 5, 2375.0);
INSERT INTO sales VALUES (190, 5, 2, 4, '2023-06-23', 10, 126000.0);
INSERT INTO sales VALUES (191, 20, 7, 1, '2023-12-12', 10, 2880.0);
INSERT INTO sales VALUES (192, 18, 7, 3, '2023-10-05', 15, 8160.0);
INSERT INTO sales VALUES (193, 2, 10, 1, '2023-11-20', 5, 8549.05);
INSERT INTO sales VALUES (194, 10, 4, 1, '2023-02-20', 15, 10200.0);
INSERT INTO sales VALUES (195, 4, 8, 2, '2023-01-15', 10, 4500.0);
INSERT INTO sales VALUES (196, 2, 6, 1, '2023-07-03', 10, 1349.1);
INSERT INTO sales VALUES (197, 12, 7, 2, '2023-09-29', 5, 6080.0);
INSERT INTO sales VALUES (198, 14, 10, 2, '2023-03-31', 5, 17098.1);
INSERT INTO sales VALUES (199, 3, 10, 4, '2023-12-16', 20, 28796.8);
INSERT INTO sales VALUES (200, 8, 8, 2, '2023-08-25', 5, 4750.0);
INSERT INTO sales VALUES (201, 9, 8, 3, '2023-08-27', 0, 7500.0);
INSERT INTO sales VALUES (202, 10, 9, 2, '2023-08-15', 0, 9600.0);
INSERT INTO sales VALUES (203, 12, 10, 3, '2023-12-20', 15, 22947.45);
INSERT INTO sales VALUES (204, 9, 8, 3, '2023-07-16', 5, 7125.0);
INSERT INTO sales VALUES (205, 16, 2, 2, '2023-10-20', 15, 59500.0);
INSERT INTO sales VALUES (206, 12, 10, 3, '2023-01-12', 10, 24297.3);
INSERT INTO sales VALUES (207, 13, 5, 1, '2023-12-18', 20, 719.2);
INSERT INTO sales VALUES (208, 2, 10, 4, '2023-04-28', 10, 32396.4);
INSERT INTO sales VALUES (209, 20, 6, 2, '2023-11-14', 5, 2848.1);
INSERT INTO sales VALUES (210, 9, 3, 1, '2023-06-08', 0, 4500.0);
INSERT INTO sales VALUES (211, 15, 1, 3, '2023-02-16', 5, 185250.0);
INSERT INTO sales VALUES (212, 10, 6, 4, '2023-04-13', 5, 5696.2);
INSERT INTO sales VALUES (213, 5, 9, 3, '2023-09-14', 20, 11520.0);
INSERT INTO sales VALUES (214, 9, 3, 3, '2023-06-01', 15, 11475.0);
INSERT INTO sales VALUES (215, 11, 2, 4, '2023-03-14', 0, 140000.0);
INSERT INTO sales VALUES (216, 8, 7, 3, '2023-07-22', 0, 9600.0);
INSERT INTO sales VALUES (217, 1, 5, 1, '2023-07-08', 15, 764.15);
INSERT INTO sales VALUES (218, 9, 10, 4, '2023-02-25', 10, 32396.4);
INSERT INTO sales VALUES (219, 8, 8, 1, '2023-10-15', 20, 2000.0);
INSERT INTO sales VALUES (220, 11, 10, 2, '2023-11-22', 0, 17998.0);
INSERT INTO sales VALUES (221, 15, 5, 4, '2023-03-13', 0, 3596.0);
INSERT INTO sales VALUES (222, 2, 1, 3, '2023-03-01', 15, 165750.0);
INSERT INTO sales VALUES (223, 4, 4, 2, '2023-08-21', 15, 20400.0);
INSERT INTO sales VALUES (224, 12, 9, 4, '2023-03-21', 20, 15360.0);
INSERT INTO sales VALUES (225, 14, 2, 4, '2023-07-28', 20, 112000.0);
INSERT INTO sales VALUES (226, 9, 1, 3, '2023-08-16', 5, 185250.0);
INSERT INTO sales VALUES (227, 15, 4, 3, '2023-12-18', 0, 36000.0);
INSERT INTO sales VALUES (228, 12, 9, 3, '2023-07-23', 0, 14400.0);
INSERT INTO sales VALUES (229, 9, 4, 1, '2023-02-16', 15, 10200.0);
INSERT INTO sales VALUES (230, 7, 10, 1, '2023-06-20', 0, 8999.0);
INSERT INTO sales VALUES (231, 8, 3, 2, '2023-10-11', 0, 9000.0);
INSERT INTO sales VALUES (232, 7, 10, 2, '2023-06-18', 5, 17098.1);
INSERT INTO sales VALUES (233, 5, 10, 1, '2023-03-16', 10, 8099.1);
INSERT INTO sales VALUES (234, 5, 9, 3, '2023-02-26', 5, 13680.0);
INSERT INTO sales VALUES (235, 1, 3, 1, '2023-05-02', 10, 4050.0);
INSERT INTO sales VALUES (236, 19, 6, 1, '2023-05-16', 5, 1424.05);
INSERT INTO sales VALUES (237, 2, 3, 4, '2023-02-28', 20, 14400.0);
INSERT INTO sales VALUES (238, 3, 8, 4, '2023-09-20', 10, 9000.0);
INSERT INTO sales VALUES (239, 19, 2, 4, '2023-04-24', 20, 112000.0);
INSERT INTO sales VALUES (240, 20, 1, 3, '2023-11-26', 15, 165750.0);
INSERT INTO sales VALUES (241, 1, 1, 4, '2023-08-07', 15, 221000.0);
INSERT INTO sales VALUES (242, 4, 8, 4, '2023-02-11', 0, 10000.0);
INSERT INTO sales VALUES (243, 11, 10, 2, '2023-03-06', 0, 17998.0);
INSERT INTO sales VALUES (244, 9, 10, 3, '2023-11-02', 15, 22947.45);
INSERT INTO sales VALUES (245, 17, 5, 4, '2023-11-06', 20, 2876.8);
INSERT INTO sales VALUES (246, 14, 2, 1, '2023-04-21', 20, 28000.0);
INSERT INTO sales VALUES (247, 14, 8, 2, '2023-06-23', 15, 4250.0);
INSERT INTO sales VALUES (248, 15, 7, 4, '2023-06-10', 0, 12800.0);
INSERT INTO sales VALUES (249, 14, 6, 3, '2023-03-20', 10, 4047.3);
INSERT INTO sales VALUES (250, 16, 2, 1, '2023-02-17', 0, 35000.0);
INSERT INTO sales VALUES (251, 14, 2, 3, '2023-10-12', 5, 99750.0);
INSERT INTO sales VALUES (252, 2, 10, 3, '2023-07-30', 0, 26997.0);
INSERT INTO sales VALUES (253, 12, 7, 1, '2023-11-04', 10, 2880.0);
INSERT INTO sales VALUES (254, 10, 6, 1, '2023-09-17', 20, 1199.2);
INSERT INTO sales VALUES (255, 7, 3, 4, '2023-02-25', 5, 17100.0);
INSERT INTO sales VALUES (256, 12, 9, 3, '2023-05-23', 0, 14400.0);
INSERT INTO sales VALUES (257, 19, 4, 4, '2023-11-15', 20, 38400.0);
INSERT INTO sales VALUES (258, 20, 9, 1, '2023-12-03', 20, 3840.0);
INSERT INTO sales VALUES (259, 9, 1, 2, '2023-12-26', 10, 117000.0);
INSERT INTO sales VALUES (260, 10, 6, 3, '2023-04-03', 0, 4497.0);
INSERT INTO sales VALUES (261, 5, 10, 4, '2023-03-14', 0, 35996.0);
INSERT INTO sales VALUES (262, 1, 2, 2, '2023-08-03', 15, 59500.0);
INSERT INTO sales VALUES (263, 15, 6, 2, '2023-06-09', 10, 2698.2);
INSERT INTO sales VALUES (264, 11, 10, 1, '2023-03-21', 0, 8999.0);
INSERT INTO sales VALUES (265, 6, 10, 1, '2023-05-20', 0, 8999.0);
INSERT INTO sales VALUES (266, 15, 7, 4, '2023-08-15', 20, 10240.0);
INSERT INTO sales VALUES (267, 14, 5, 2, '2023-02-28', 20, 1438.4);
INSERT INTO sales VALUES (268, 12, 7, 1, '2023-12-14', 10, 2880.0);
INSERT INTO sales VALUES (269, 19, 8, 3, '2023-04-23', 0, 7500.0);
INSERT INTO sales VALUES (270, 13, 10, 1, '2023-04-15', 0, 8999.0);
INSERT INTO sales VALUES (271, 10, 4, 2, '2023-05-29', 10, 21600.0);
INSERT INTO sales VALUES (272, 11, 2, 1, '2023-08-09', 15, 29750.0);
INSERT INTO sales VALUES (273, 6, 3, 4, '2023-12-27', 20, 14400.0);
INSERT INTO sales VALUES (274, 8, 9, 3, '2023-07-23', 0, 14400.0);
INSERT INTO sales VALUES (275, 2, 7, 1, '2023-02-09', 15, 2720.0);
INSERT INTO sales VALUES (276, 11, 10, 4, '2023-07-27', 20, 28796.8);
INSERT INTO sales VALUES (277, 14, 5, 1, '2023-01-11', 15, 764.15);
INSERT INTO sales VALUES (278, 11, 3, 4, '2023-02-15', 10, 16200.0);
INSERT INTO sales VALUES (279, 14, 2, 2, '2023-10-29', 15, 59500.0);
INSERT INTO sales VALUES (280, 13, 9, 1, '2023-06-08', 15, 4080.0);
INSERT INTO sales VALUES (281, 11, 4, 3, '2023-02-09', 5, 34200.0);
INSERT INTO sales VALUES (282, 17, 2, 2, '2023-06-29', 10, 63000.0);
INSERT INTO sales VALUES (283, 5, 4, 1, '2023-05-12', 5, 11400.0);
INSERT INTO sales VALUES (284, 7, 3, 2, '2023-04-01', 0, 9000.0);
INSERT INTO sales VALUES (285, 16, 8, 4, '2023-11-26', 20, 8000.0);
INSERT INTO sales VALUES (286, 20, 6, 3, '2023-08-14', 5, 4272.15);
INSERT INTO sales VALUES (287, 3, 8, 4, '2023-05-21', 10, 9000.0);
INSERT INTO sales VALUES (288, 19, 1, 3, '2023-02-07', 20, 156000.0);
INSERT INTO sales VALUES (289, 10, 8, 4, '2023-01-30', 0, 10000.0);
INSERT INTO sales VALUES (290, 12, 5, 1, '2023-11-11', 0, 899.0);
INSERT INTO sales VALUES (291, 20, 9, 4, '2023-10-25', 15, 16320.0);
INSERT INTO sales VALUES (292, 18, 1, 4, '2023-11-30', 20, 208000.0);
INSERT INTO sales VALUES (293, 7, 6, 4, '2023-03-19', 20, 4796.8);
INSERT INTO sales VALUES (294, 2, 8, 1, '2023-02-13', 10, 2250.0);
INSERT INTO sales VALUES (295, 17, 3, 1, '2023-12-29', 5, 4275.0);
INSERT INTO sales VALUES (296, 15, 8, 2, '2023-07-10', 10, 4500.0);
INSERT INTO sales VALUES (297, 10, 7, 4, '2023-12-14', 10, 11520.0);
INSERT INTO sales VALUES (298, 20, 1, 3, '2023-06-18', 0, 195000.0);
INSERT INTO sales VALUES (299, 4, 9, 4, '2023-05-10', 10, 17280.0);
INSERT INTO sales VALUES (300, 20, 3, 3, '2023-10-26', 0, 13500.0);