Customer_Behavior_Analysis_database_setup.sql

-- Creating the main database
CREATE DATABASE Amazon_customers_behavior; 
use Amazon_customers_behavior;
-- This section creates the 9 main tables required for the Customer Behavior Analysis project database
CREATE TABLE Customers (
    customer_id INT PRIMARY KEY,
    full_name VARCHAR(100) NOT NULL,
    email VARCHAR(120) UNIQUE,
    city VARCHAR(60),
    age INT,
    gender VARCHAR(10),
    registration_date DATE
);
CREATE TABLE Categories (
    category_id INT PRIMARY KEY,
    category_name VARCHAR(80) NOT NULL,
    description VARCHAR(255)
);
CREATE TABLE Products (
    product_id INT PRIMARY KEY,
    product_name VARCHAR(120) NOT NULL,
    brand VARCHAR(80),
    price DECIMAL(10,2),
    stock_quantity INT,
    rating DECIMAL(2,1),
    sku VARCHAR(30) UNIQUE,
    category_id INT,
    FOREIGN KEY (category_id) REFERENCES Categories(category_id)
);
CREATE TABLE Orders (
    order_id INT PRIMARY KEY,
    customer_id INT,
    order_date DATE,
    total_amount DECIMAL(10,2),
    status VARCHAR(30),
    FOREIGN KEY (customer_id) REFERENCES Customers(customer_id)
);
CREATE TABLE Order_Items (
    order_item_id INT PRIMARY KEY,
    order_id INT,
    product_id INT,
    quantity INT,
    unit_price DECIMAL(10,2),
    subtotal DECIMAL(10,2),
    FOREIGN KEY (order_id) REFERENCES Orders(order_id),
    FOREIGN KEY (product_id) REFERENCES Products(product_id)
);
CREATE TABLE Payments (
    payment_id INT PRIMARY KEY,
    order_id INT,
    payment_method VARCHAR(50),
    amount DECIMAL(10,2),
    payment_date DATE,
    payment_status VARCHAR(30),
    FOREIGN KEY (order_id) REFERENCES Orders(order_id)
);
CREATE TABLE Shipments (
    shipment_id INT PRIMARY KEY,
    order_id INT,
    shipping_address VARCHAR(255),
    shipment_date DATE,
    delivery_date DATE,
    delivery_status VARCHAR(30),
    FOREIGN KEY (order_id) REFERENCES Orders(order_id)
);
CREATE TABLE Product_Reviews (
    review_id INT PRIMARY KEY,
    customer_id INT,
    product_id INT,
    rating INT,
    review_comment VARCHAR(255),
    review_date DATE,
    FOREIGN KEY (customer_id) REFERENCES Customers(customer_id),
    FOREIGN KEY (product_id) REFERENCES Products(product_id)
);
-- Customer data is fictional and used for privacy protection , This section creates the main tables such as Customers, Orders, Products, and related entities.
-- These tables are designed to support data analysis and business insights
INSERT INTO Customers (customer_id, full_name, email, city, age, gender, registration_date) VALUES
(1, 'Abdulrahman Alamri', 'abdulrahman.alamri1@gmail.com', 'Jeddah', 46, 'Male', '2023-08-03'),
(2, 'Hassan Alqahtani', 'hassan.alqahtani2@gmail.com', 'Al Lith', 24, 'Male', '2024-06-04'),
(3, 'Abdulrahman Alotaibi', 'abdulrahman.alotaibi3@gmail.com', 'Jeddah', 50, 'Male', '2023-06-03'),
(4, 'Dalal Alotaibi', 'dalal.alotaibi4@gmail.com', 'Rabigh', 35, 'Female', '2022-06-13'),
(5, 'Salem Alqahtani', 'salem.alqahtani5@gmail.com', 'Taif', 36, 'Male', '2022-09-16'),
(6, 'Faisal Almutairi', 'faisal.almutairi6@gmail.com', 'Jeddah', 34, 'Male', '2023-08-24'),
(7, 'Aseel Aljohani', 'aseel.aljohani7@gmail.com', 'Rabigh', 33, 'Female', '2024-04-19'),
(8, 'Aisha Alamri', 'aisha.alamri8@gmail.com', 'Taif', 50, 'Female', '2023-04-28'),
(9, 'Sara Alzahrani', 'sara.alzahrani9@gmail.com', 'Al Qunfudhah', 32, 'Female', '2022-06-13'),
(10, 'Khadijah Almutairi', 'khadijah.almutairi10@gmail.com', 'Al Qunfudhah', 23, 'Female', '2023-05-01'),
(11, 'Aisha Alshamrani', 'aisha.alshamrani11@gmail.com', 'Al Lith', 27, 'Female', '2021-05-13'),
(12, 'Joud Alamri', 'joud.alamri12@gmail.com', 'Taif', 51, 'Female', '2021-07-09'),
(13, 'Turki Alsubhi', 'turki.alsubhi13@gmail.com', 'Taif', 43, 'Male', '2023-01-08'),
(14, 'Saad Almutairi', 'saad.almutairi14@gmail.com', 'Jeddah', 47, 'Male', '2021-09-14'),
(15, 'Aisha Alzahrani', 'aisha.alzahrani15@gmail.com', 'Rabigh', 49, 'Female', '2024-06-10'),
(16, 'Faisal Alghamdi', 'faisal.alghamdi16@gmail.com', 'Jeddah', 37, 'Male', '2023-04-22'),
(17, 'Fahad Alqahtani', 'fahad.alqahtani17@gmail.com', 'Al Lith', 28, 'Male', '2021-04-15'),
(18, 'Yousef Alharbi', 'yousef.alharbi18@gmail.com', 'Taif', 40, 'Male', '2022-10-23'),
(19, 'Fahad Alharbi', 'fahad.alharbi19@gmail.com', 'Taif', 22, 'Male', '2021-06-16'),
(20, 'Hanan Aljohani', 'hanan.aljohani20@gmail.com', 'Rabigh', 34, 'Female', '2023-09-16'),
(21, 'Joud Alshamrani', 'joud.alshamrani21@gmail.com', 'Rabigh', 20, 'Female', '2023-04-04'),
(22, 'Faisal Aljohani', 'faisal.aljohani22@gmail.com', 'Jeddah', 35, 'Male', '2021-02-21'),
(23, 'Abdulrahman Alzahrani', 'abdulrahman.alzahrani23@gmail.com', 'Taif', 34, 'Male', '2024-06-05'),
(24, 'Sara Alghamdi', 'sara.alghamdi24@gmail.com', 'Taif', 30, 'Female', '2023-11-05'),
(25, 'Majed Alshehri', 'majed.alshehri25@gmail.com', 'Rabigh', 33, 'Male', '2024-03-03'),
(26, 'Razan Alsubhi', 'razan.alsubhi26@gmail.com', 'Jeddah', 47, 'Female', '2024-06-07'),
(27, 'Noura Alharbi', 'noura.alharbi27@gmail.com', 'Taif', 38, 'Female', '2022-03-09'),
(28, 'Lama Alamri', 'lama.alamri28@gmail.com', 'Taif', 29, 'Female', '2024-02-01'),
(29, 'Razan Alotaibi', 'razan.alotaibi29@gmail.com', 'Taif', 45, 'Female', '2021-06-13'),
(30, 'Ibrahim Alamri', 'ibrahim.alamri30@gmail.com', 'Rabigh', 49, 'Male', '2022-02-17'),
(31, 'Faisal Alotaibi', 'faisal.alotaibi31@gmail.com', 'Rabigh', 43, 'Male', '2022-06-22'),
(32, 'Rima Alshamrani', 'rima.alshamrani32@gmail.com', 'Jeddah', 52, 'Female', '2021-03-13'),
(33, 'Reem Alharbi', 'reem.alharbi33@gmail.com', 'Jeddah', 45, 'Female', '2022-01-03'),
(34, 'Lama Alzahrani', 'lama.alzahrani34@gmail.com', 'Taif', 48, 'Female', '2023-03-06'),
(35, 'Saad Alshamrani', 'saad.alshamrani35@gmail.com', 'Al Lith', 49, 'Male', '2021-03-14'),
(36, 'Layla Aljohani', 'layla.aljohani36@gmail.com', 'Al Lith', 29, 'Female', '2024-12-14'),
(37, 'Omar Alghamdi', 'omar.alghamdi37@gmail.com', 'Rabigh', 31, 'Male', '2024-12-01'),
(38, 'Omar Aljohani', 'omar.aljohani38@gmail.com', 'Jeddah', 40, 'Male', '2024-02-06'),
(39, 'Ibrahim Alqahtani', 'ibrahim.alqahtani39@gmail.com', 'Jeddah', 39, 'Male', '2023-08-08'),
(40, 'Rima Alotaibi', 'rima.alotaibi40@gmail.com', 'Al Qunfudhah', 27, 'Female', '2022-02-01'),
(41, 'Razan Alsubhi', 'razan.alsubhi41@gmail.com', 'Al Lith', 35, 'Female', '2022-10-02'),
(42, 'Sara Aljohani', 'sara.aljohani42@gmail.com', 'Rabigh', 42, 'Female', '2021-08-19'),
(43, 'Aseel Alsubhi', 'aseel.alsubhi43@gmail.com', 'Taif', 36, 'Female', '2024-08-02'),
(44, 'Layla Aljohani', 'layla.aljohani44@gmail.com', 'Taif', 40, 'Female', '2021-10-06'),
(45, 'Nayef Alharbi', 'nayef.alharbi45@gmail.com', 'Rabigh', 25, 'Male', '2021-09-25'),
(46, 'Saad Alamri', 'saad.alamri46@gmail.com', 'Rabigh', 45, 'Male', '2023-12-24'),
(47, 'Saad Alshehri', 'saad.alshehri47@gmail.com', 'Taif', 23, 'Male', '2021-09-18'),
(48, 'Reem Alamri', 'reem.alamri48@gmail.com', 'Rabigh', 52, 'Female', '2022-10-05'),
(49, 'Aseel Alotaibi', 'aseel.alotaibi49@gmail.com', 'Al Qunfudhah', 49, 'Female', '2023-12-13'),
(50, 'Maha Alshehri', 'maha.alshehri50@gmail.com', 'Rabigh', 25, 'Female', '2021-05-12'),
(51, 'Joud Almutairi', 'joud.almutairi51@gmail.com', 'Taif', 41, 'Female', '2022-03-11'),
(52, 'Joud Aljohani', 'joud.aljohani52@gmail.com', 'Jeddah', 41, 'Female', '2022-07-23'),
(53, 'Khadijah Alshamrani', 'khadijah.alshamrani53@gmail.com', 'Al Lith', 37, 'Female', '2024-11-25'),
(54, 'Layla Alharbi', 'layla.alharbi54@gmail.com', 'Rabigh', 22, 'Female', '2022-11-18'),
(55, 'Layla Alghamdi', 'layla.alghamdi55@gmail.com', 'Rabigh', 52, 'Female', '2021-07-25'),
(56, 'Abdulrahman Alsubhi', 'abdulrahman.alsubhi56@gmail.com', 'Taif', 42, 'Male', '2022-11-06'),
(57, 'Abdulrahman Alghamdi', 'abdulrahman.alghamdi57@gmail.com', 'Rabigh', 39, 'Male', '2021-05-26'),
(58, 'Yousef Alzahrani', 'yousef.alzahrani58@gmail.com', 'Jeddah', 37, 'Male', '2022-09-28'),
(59, 'Majed Almutairi', 'majed.almutairi59@gmail.com', 'Taif', 27, 'Male', '2021-07-13'),
(60, 'Yousef Alghamdi', 'yousef.alghamdi60@gmail.com', 'Rabigh', 52, 'Male', '2022-02-05'),
(61, 'Khadijah Alsubhi', 'khadijah.alsubhi61@gmail.com', 'Taif', 49, 'Female', '2024-01-05'),
(62, 'Majed Alharbi', 'majed.alharbi62@gmail.com', 'Taif', 20, 'Male', '2024-01-24'),
(63, 'Hanan Alamri', 'hanan.alamri63@gmail.com', 'Al Lith', 30, 'Female', '2023-08-04'),
(64, 'Maha Alshamrani', 'maha.alshamrani64@gmail.com', 'Rabigh', 42, 'Female', '2022-09-20'),
(65, 'Ibrahim Alsubhi', 'ibrahim.alsubhi65@gmail.com', 'Al Qunfudhah', 22, 'Male', '2023-10-23'),
(66, 'Abdulrahman Alshehri', 'abdulrahman.alshehri66@gmail.com', 'Al Qunfudhah', 51, 'Male', '2023-09-14'),
(67, 'Hanan Alghamdi', 'hanan.alghamdi67@gmail.com', 'Jeddah', 23, 'Female', '2022-04-23'),
(68, 'Hanan Alshehri', 'hanan.alshehri68@gmail.com', 'Jeddah', 41, 'Female', '2021-12-22'),
(69, 'Khalid Alharbi', 'khalid.alharbi69@gmail.com', 'Al Lith', 21, 'Male', '2024-01-25'),
(70, 'Rima Alqahtani', 'rima.alqahtani70@gmail.com', 'Al Lith', 23, 'Female', '2023-10-21'),
(71, 'Razan Alshehri', 'razan.alshehri71@gmail.com', 'Rabigh', 22, 'Female', '2023-08-23'),
(72, 'Salem Alghamdi', 'salem.alghamdi72@gmail.com', 'Taif', 35, 'Male', '2022-10-07'),
(73, 'Yousef Alsubhi', 'yousef.alsubhi73@gmail.com', 'Taif', 33, 'Male', '2021-01-24'),
(74, 'Maha Alghamdi', 'maha.alghamdi74@gmail.com', 'Taif', 20, 'Female', '2024-02-12'),
(75, 'Yousef Almutairi', 'yousef.almutairi75@gmail.com', 'Jeddah', 51, 'Male', '2022-11-23'),
(76, 'Abdulrahman Alzahrani', 'abdulrahman.alzahrani76@gmail.com', 'Jeddah', 35, 'Male', '2022-08-18'),
(77, 'Aisha Alamri', 'aisha.alamri77@gmail.com', 'Taif', 33, 'Female', '2022-06-03'),
(78, 'Omar Alotaibi', 'omar.alotaibi78@gmail.com', 'Rabigh', 36, 'Male', '2021-06-15'),
(79, 'Razan Alghamdi', 'razan.alghamdi79@gmail.com', 'Al Lith', 40, 'Female', '2023-02-05'),
(80, 'Fahad Alshamrani', 'fahad.alshamrani80@gmail.com', 'Rabigh', 22, 'Male', '2023-11-14'),
(81, 'Dalal Alqahtani', 'dalal.alqahtani81@gmail.com', 'Rabigh', 50, 'Female', '2022-05-20'),
(82, 'Aisha Alqahtani', 'aisha.alqahtani82@gmail.com', 'Al Qunfudhah', 30, 'Female', '2022-07-11'),
(83, 'Salem Alotaibi', 'salem.alotaibi83@gmail.com', 'Taif', 45, 'Male', '2022-08-27'),
(84, 'Turki Alshehri', 'turki.alshehri84@gmail.com', 'Al Qunfudhah', 30, 'Male', '2024-08-16'),
(85, 'Sara Aljohani', 'sara.aljohani85@gmail.com', 'Rabigh', 41, 'Female', '2021-12-28'),
(86, 'Faisal Alzahrani', 'faisal.alzahrani86@gmail.com', 'Taif', 28, 'Male', '2022-07-24'),
(87, 'Maha Alqahtani', 'maha.alqahtani87@gmail.com', 'Jeddah', 44, 'Female', '2024-12-21'),
(88, 'Saad Alotaibi', 'saad.alotaibi88@gmail.com', 'Jeddah', 36, 'Male', '2021-02-04'),
(89, 'Salem Alshamrani', 'salem.alshamrani89@gmail.com', 'Taif', 36, 'Male', '2024-08-15'),
(90, 'Faisal Alshehri', 'faisal.alshehri90@gmail.com', 'Rabigh', 30, 'Male', '2022-12-25'),
(91, 'Layla Almutairi', 'layla.almutairi91@gmail.com', 'Al Qunfudhah', 25, 'Female', '2024-12-23'),
(92, 'Khalid Almutairi', 'khalid.almutairi92@gmail.com', 'Al Lith', 35, 'Male', '2022-08-08'),
(93, 'Faisal Aljohani', 'faisal.aljohani93@gmail.com', 'Rabigh', 23, 'Male', '2021-06-25'),
(94, 'Joud Alsubhi', 'joud.alsubhi94@gmail.com', 'Rabigh', 20, 'Female', '2022-08-19'),
(95, 'Dalal Alzahrani', 'dalal.alzahrani95@gmail.com', 'Al Lith', 31, 'Female', '2024-07-02'),
(96, 'Nayef Alamri', 'nayef.alamri96@gmail.com', 'Taif', 41, 'Male', '2024-02-20'),
(97, 'Faisal Alghamdi', 'faisal.alghamdi97@gmail.com', 'Jeddah', 52, 'Male', '2024-10-28'),
(98, 'Yousef Alsubhi', 'yousef.alsubhi98@gmail.com', 'Taif', 48, 'Male', '2024-11-08'),
(99, 'Hassan Alshamrani', 'hassan.alshamrani99@gmail.com', 'Al Lith', 40, 'Male', '2024-01-14'),
(100, 'Nayef Alzahrani', 'nayef.alzahrani100@gmail.com', 'Al Qunfudhah', 21, 'Male', '2024-06-20');

-- This table defines 8 core product categories used to classify products and improve data organization and analysis.
INSERT INTO Categories (category_id, category_name, description) VALUES
(1, 'Electronics', 'Devices and electronic accessories'),
(2, 'Fashion', 'Clothing, shoes, and accessories'),
(3, 'Home & Kitchen', 'Home appliances and kitchen items'),
(4, 'Beauty', 'Beauty and personal care products'),
(5, 'Sports', 'Sports and outdoor products'),
(6, 'Books', 'Books and educational materials'),
(7, 'Toys', 'Toys and games for children'),
(8, 'Grocery', 'Food and daily grocery products');

-- This table contains detailed information about all products, including pricing,inventory levels, and category classification. It supports sales analysis and product performance tracking
INSERT INTO Products (product_id, product_name, brand, price, stock_quantity, rating, sku, category_id) VALUES
(1, 'iPhone 15 128GB', 'Apple', 3899.0, 25, 4.8, 'SKU-01-0001', 1),
(2, 'Samsung Galaxy S24', 'Samsung', 3199.0, 32, 4.7, 'SKU-01-0002', 1),
(3, 'Lenovo IdeaPad Laptop', 'Lenovo', 2499.0, 18, 4.5, 'SKU-01-0003', 1),
(4, 'Sony Wireless Headphones', 'Sony', 699.0, 55, 4.4, 'SKU-01-0004', 1),
(5, 'Apple Watch SE', 'Apple', 1099.0, 41, 4.6, 'SKU-01-0005', 1),
(6, 'Men Cotton T-Shirt', 'H&M', 79.0, 120, 4.1, 'SKU-02-0006', 2),
(7, 'Women Abaya Classic', 'Local Brand', 199.0, 70, 4.3, 'SKU-02-0007', 2),
(8, 'Running Shoes', 'Nike', 399.0, 60, 4.5, 'SKU-02-0008', 2),
(9, 'Leather Handbag', 'Aldo', 299.0, 38, 4.2, 'SKU-02-0009', 2),
(10, 'Sports Cap', 'Adidas', 89.0, 90, 4.0, 'SKU-02-0010', 2),
(11, 'Air Fryer 5L', 'Philips', 549.0, 34, 4.6, 'SKU-03-0011', 3),
(12, 'Coffee Maker', 'Delonghi', 799.0, 22, 4.5, 'SKU-03-0012', 3),
(13, 'Non-stick Cookware Set', 'Tefal', 449.0, 40, 4.4, 'SKU-03-0013', 3),
(14, 'Vacuum Cleaner', 'Dyson', 1899.0, 15, 4.7, 'SKU-03-0014', 3),
(15, 'Bed Sheet Set', 'Home Box', 149.0, 75, 4.2, 'SKU-03-0015', 3),
(16, 'Vitamin C Serum', 'The Ordinary', 89.0, 95, 4.4, 'SKU-04-0016', 4),
(17, 'Sunscreen SPF50', 'La Roche-Posay', 129.0, 100, 4.7, 'SKU-04-0017', 4),
(18, 'Perfume 100ml', 'Arabian Oud', 299.0, 50, 4.6, 'SKU-04-0018', 4),
(19, 'Hair Dryer', 'Braun', 249.0, 45, 4.3, 'SKU-04-0019', 4),
(20, 'Makeup Brush Set', 'Real Techniques', 119.0, 80, 4.2, 'SKU-04-0020', 4),
(21, 'Yoga Mat', 'Decathlon', 99.0, 85, 4.2, 'SKU-05-0021', 5),
(22, 'Dumbbell Set 10kg', 'Decathlon', 249.0, 42, 4.4, 'SKU-05-0022', 5),
(23, 'Football', 'Adidas', 109.0, 65, 4.1, 'SKU-05-0023', 5),
(24, 'Fitness Tracker', 'Huawei', 399.0, 33, 4.3, 'SKU-05-0024', 5),
(25, 'Water Bottle', 'Nike', 59.0, 150, 4.0, 'SKU-05-0025', 5),
(26, 'Data Science Book', 'O''Reilly', 199.0, 30, 4.8, 'SKU-06-0026', 6),
(27, 'SQL for Beginners', 'Pearson', 149.0, 44, 4.6, 'SKU-06-0027', 6),
(28, 'English Grammar Guide', 'Oxford', 89.0, 58, 4.4, 'SKU-06-0028', 6),
(29, 'Notebook Pack', 'Jarir', 35.0, 200, 4.1, 'SKU-06-0029', 6),
(30, 'Study Planner', 'Jarir', 49.0, 120, 4.2, 'SKU-06-0030', 6),
(31, 'LEGO Classic Box', 'LEGO', 249.0, 40, 4.7, 'SKU-07-0031', 7),
(32, 'Puzzle 1000 Pieces', 'Ravensburger', 99.0, 55, 4.3, 'SKU-07-0032', 7),
(33, 'Remote Control Car', 'Maisto', 179.0, 37, 4.2, 'SKU-07-0033', 7),
(34, 'Kids Drawing Kit', 'Crayola', 69.0, 90, 4.4, 'SKU-07-0034', 7),
(35, 'Board Game', 'Hasbro', 129.0, 60, 4.1, 'SKU-07-0035', 7),
(36, 'Premium Dates 1kg', 'Bateel', 79.0, 130, 4.7, 'SKU-08-0036', 8),
(37, 'Arabic Coffee 500g', 'Najjar', 45.0, 160, 4.5, 'SKU-08-0037', 8),
(38, 'Olive Oil 1L', 'Al Jouf', 59.0, 100, 4.4, 'SKU-08-0038', 8),
(39, 'Basmati Rice 5kg', 'Abu Kass', 69.0, 140, 4.3, 'SKU-08-0039', 8),
(40, 'Organic Honey 500g', 'Local Farm', 89.0, 80, 4.6, 'SKU-08-0040', 8);

-- Stores all purchase transactions made by customers , Includes order date, total amount, and order status ,Used to analyze customer purchasing behavior and sales performance.
INSERT INTO Orders (order_id, customer_id, order_date, total_amount, status) VALUES
(1, 82, '2024-04-24', 1313.0, 'Completed'),
(2, 90, '2025-07-12', 129.0, 'Pending'),
(3, 20, '2024-08-08', 158.0, 'Completed'),
(4, 69, '2024-05-07', 158.0, 'Pending'),
(5, 85, '2024-08-21', 149.0, 'Completed'),
(6, 90, '2025-11-30', 307.0, 'Completed'),
(7, 52, '2024-10-01', 342.0, 'Completed'),
(8, 55, '2025-08-20', 776.0, 'Pending'),
(9, 77, '2024-03-06', 850.0, 'Pending'),
(10, 15, '2024-10-27', 11844.0, 'Pending'),
(11, 81, '2024-11-01', 1286.0, 'Cancelled'),
(12, 63, '2024-01-20', 1085.0, 'Completed'),
(13, 34, '2025-06-24', 5770.0, 'Cancelled'),
(14, 16, '2024-09-10', 249.0, 'Completed'),
(15, 9, '2024-02-02', 179.0, 'Completed'),
(16, 93, '2025-08-07', 1683.0, 'Cancelled'),
(17, 60, '2024-02-25', 597.0, 'Completed'),
(18, 24, '2024-10-12', 3332.0, 'Pending'),
(19, 97, '2024-08-30', 4345.0, 'Completed'),
(20, 92, '2025-05-13', 5946.0, 'Completed'),
(21, 9, '2025-09-01', 996.0, 'Completed'),
(22, 41, '2024-09-24', 1073.0, 'Completed'),
(23, 32, '2025-01-13', 363.0, 'Completed'),
(24, 15, '2024-04-19', 1146.0, 'Cancelled'),
(25, 82, '2024-09-27', 1214.0, 'Cancelled'),
(26, 21, '2025-03-28', 6432.0, 'Cancelled'),
(27, 19, '2025-03-16', 238.0, 'Completed'),
(28, 46, '2025-07-27', 1187.0, 'Pending'),
(29, 86, '2024-09-11', 317.0, 'Completed'),
(30, 43, '2024-10-12', 1262.0, 'Completed'),
(31, 94, '2024-11-17', 177.0, 'Pending'),
(32, 67, '2025-07-05', 3212.0, 'Completed'),
(33, 25, '2025-03-06', 268.0, 'Pending'),
(34, 75, '2025-09-13', 2790.0, 'Completed'),
(35, 59, '2025-02-28', 217.0, 'Cancelled'),
(36, 1, '2024-04-19', 1667.0, 'Pending'),
(37, 86, '2025-06-27', 695.0, 'Cancelled'),
(38, 58, '2024-09-22', 425.0, 'Completed'),
(39, 9, '2025-02-28', 476.0, 'Pending'),
(40, 62, '2024-01-07', 1011.0, 'Completed'),
(41, 60, '2024-05-10', 597.0, 'Cancelled'),
(42, 55, '2024-05-18', 1656.0, 'Pending'),
(43, 36, '2025-03-07', 249.0, 'Completed'),
(44, 84, '2024-02-11', 4546.0, 'Completed'),
(45, 22, '2025-09-12', 1098.0, 'Cancelled'),
(46, 40, '2025-08-12', 4131.0, 'Pending'),
(47, 85, '2025-01-14', 4395.0, 'Completed'),
(48, 100, '2025-05-10', 944.0, 'Pending'),
(49, 4, '2025-05-21', 3996.0, 'Completed'),
(50, 25, '2024-03-28', 1210.0, 'Completed'),
(51, 55, '2025-07-17', 516.0, 'Completed'),
(52, 93, '2025-08-26', 1346.0, 'Cancelled'),
(53, 69, '2024-05-09', 2097.0, 'Completed'),
(54, 61, '2025-05-05', 2426.0, 'Pending'),
(55, 20, '2024-06-01', 1612.0, 'Cancelled'),
(56, 58, '2025-03-29', 1280.0, 'Completed'),
(57, 59, '2024-03-13', 1495.0, 'Completed'),
(58, 39, '2025-12-17', 784.0, 'Pending'),
(59, 4, '2024-04-03', 897.0, 'Completed'),
(60, 36, '2024-07-04', 1181.0, 'Cancelled'),
(61, 53, '2025-12-11', 5475.0, 'Pending'),
(62, 85, '2025-07-09', 4000.0, 'Pending'),
(63, 37, '2025-03-24', 9597.0, 'Pending'),
(64, 71, '2025-02-21', 546.0, 'Completed'),
(65, 32, '2025-04-12', 1524.0, 'Cancelled'),
(66, 99, '2025-02-28', 12801.0, 'Completed'),
(67, 42, '2024-07-12', 8440.0, 'Completed'),
(68, 57, '2024-04-12', 11571.0, 'Cancelled'),
(69, 43, '2025-11-21', 8022.0, 'Cancelled'),
(70, 12, '2025-03-20', 35.0, 'Completed'),
(71, 38, '2025-01-02', 752.0, 'Completed'),
(72, 37, '2025-11-24', 2303.0, 'Cancelled'),
(73, 89, '2024-09-13', 1006.0, 'Pending'),
(74, 85, '2025-02-09', 135.0, 'Completed'),
(75, 37, '2024-08-23', 1912.0, 'Cancelled'),
(76, 81, '2025-10-23', 7626.0, 'Completed'),
(77, 22, '2024-09-20', 697.0, 'Pending'),
(78, 2, '2024-09-27', 98.0, 'Cancelled'),
(79, 82, '2025-01-15', 10344.0, 'Completed'),
(80, 90, '2024-11-05', 299.0, 'Pending'),
(81, 31, '2025-07-04', 1880.0, 'Completed'),
(82, 31, '2025-01-06', 1175.0, 'Completed'),
(83, 17, '2025-08-01', 79.0, 'Completed'),
(84, 77, '2024-01-03', 727.0, 'Completed'),
(85, 3, '2024-06-27', 897.0, 'Completed'),
(86, 100, '2025-01-05', 105.0, 'Cancelled'),
(87, 94, '2025-11-05', 7894.0, 'Cancelled'),
(88, 57, '2024-03-16', 3544.0, 'Completed'),
(89, 30, '2025-02-27', 1491.0, 'Completed'),
(90, 17, '2025-07-23', 1822.0, 'Completed'),
(91, 14, '2024-12-24', 1132.0, 'Cancelled'),
(92, 89, '2024-09-30', 836.0, 'Completed'),
(93, 12, '2025-06-27', 2241.0, 'Completed'),
(94, 57, '2025-02-28', 1156.0, 'Completed'),
(95, 6, '2024-08-13', 3899.0, 'Pending'),
(96, 42, '2024-05-02', 3140.0, 'Completed'),
(97, 91, '2025-10-17', 10594.0, 'Pending'),
(98, 14, '2024-09-06', 802.0, 'Pending'),
(99, 100, '2024-12-23', 487.0, 'Completed'),
(100, 23, '2025-10-05', 426.0, 'Pending'),
(101, 36, '2025-08-28', 2675.0, 'Completed'),
(102, 60, '2025-08-17', 105.0, 'Cancelled'),
(103, 61, '2025-05-28', 35.0, 'Completed'),
(104, 6, '2024-09-10', 2212.0, 'Pending'),
(105, 9, '2024-12-03', 1101.0, 'Completed'),
(106, 95, '2025-12-02', 267.0, 'Cancelled'),
(107, 40, '2024-07-03', 697.0, 'Completed'),
(108, 77, '2025-01-20', 1066.0, 'Completed'),
(109, 97, '2025-04-04', 617.0, 'Completed'),
(110, 21, '2024-07-23', 1785.0, 'Cancelled'),
(111, 92, '2025-06-12', 2104.0, 'Completed'),
(112, 51, '2025-05-29', 197.0, 'Completed'),
(113, 90, '2024-05-22', 13753.0, 'Pending'),
(114, 16, '2024-02-18', 4021.0, 'Completed'),
(115, 47, '2024-03-10', 118.0, 'Cancelled'),
(116, 48, '2024-09-16', 3891.0, 'Completed'),
(117, 90, '2025-05-05', 1197.0, 'Completed'),
(118, 70, '2025-04-29', 898.0, 'Completed'),
(119, 52, '2025-03-26', 2994.0, 'Pending'),
(120, 70, '2024-10-27', 158.0, 'Completed'),
(121, 22, '2025-12-07', 5321.0, 'Pending'),
(122, 66, '2025-11-26', 267.0, 'Completed'),
(123, 50, '2025-08-03', 868.0, 'Completed'),
(124, 4, '2024-07-09', 1639.0, 'Pending'),
(125, 58, '2024-06-25', 297.0, 'Pending'),
(126, 39, '2024-06-10', 727.0, 'Completed'),
(127, 17, '2025-09-18', 238.0, 'Completed'),
(128, 10, '2024-05-08', 70.0, 'Completed'),
(129, 65, '2024-02-26', 1217.0, 'Completed'),
(130, 17, '2025-10-02', 537.0, 'Completed'),
(131, 73, '2024-02-12', 7497.0, 'Completed'),
(132, 82, '2024-02-01', 1033.0, 'Pending'),
(133, 57, '2025-03-01', 4950.0, 'Pending'),
(134, 41, '2024-09-04', 598.0, 'Pending'),
(135, 50, '2025-09-22', 1944.0, 'Pending'),
(136, 64, '2024-11-11', 158.0, 'Pending'),
(137, 7, '2024-02-21', 945.0, 'Completed'),
(138, 50, '2025-05-31', 1485.0, 'Pending'),
(139, 78, '2025-06-05', 2499.0, 'Pending'),
(140, 20, '2025-09-12', 287.0, 'Cancelled'),
(141, 39, '2025-08-30', 4274.0, 'Completed'),
(142, 22, '2025-06-20', 2900.0, 'Cancelled'),
(143, 20, '2025-02-26', 2072.0, 'Completed'),
(144, 70, '2024-12-28', 1743.0, 'Completed'),
(145, 45, '2024-05-29', 747.0, 'Completed'),
(146, 28, '2024-07-25', 1873.0, 'Cancelled'),
(147, 86, '2025-06-27', 1796.0, 'Completed'),
(148, 61, '2025-05-03', 2943.0, 'Completed'),
(149, 5, '2025-02-10', 5247.0, 'Pending'),
(150, 18, '2025-05-31', 2144.0, 'Pending'),
(151, 38, '2025-08-04', 775.0, 'Completed'),
(152, 1, '2024-09-24', 668.0, 'Pending'),
(153, 8, '2025-11-14', 2231.0, 'Completed'),
(154, 90, '2025-07-16', 296.0, 'Pending'),
(155, 73, '2024-04-24', 174.0, 'Completed'),
(156, 63, '2024-04-03', 2572.0, 'Cancelled'),
(157, 93, '2024-01-23', 5916.0, 'Pending'),
(158, 9, '2025-04-28', 3741.0, 'Completed'),
(159, 88, '2025-11-08', 1306.0, 'Cancelled'),
(160, 94, '2024-08-16', 238.0, 'Completed'),
(161, 25, '2024-04-25', 5454.0, 'Completed'),
(162, 94, '2025-08-12', 713.0, 'Completed'),
(163, 23, '2025-10-03', 1981.0, 'Pending'),
(164, 31, '2024-08-18', 1545.0, 'Completed'),
(165, 58, '2025-01-14', 2295.0, 'Completed'),
(166, 62, '2024-08-01', 14943.0, 'Completed'),
(167, 49, '2025-04-22', 1413.0, 'Cancelled'),
(168, 98, '2024-11-23', 7943.0, 'Completed'),
(169, 20, '2024-07-19', 149.0, 'Completed'),
(170, 46, '2024-06-22', 3094.0, 'Completed'),
(171, 86, '2025-09-23', 10663.0, 'Pending'),
(172, 23, '2024-04-19', 1614.0, 'Completed'),
(173, 90, '2024-08-19', 2499.0, 'Completed'),
(174, 82, '2024-01-10', 198.0, 'Completed'),
(175, 30, '2024-08-04', 9622.0, 'Cancelled'),
(176, 76, '2024-05-27', 119.0, 'Pending'),
(177, 50, '2024-05-23', 1076.0, 'Completed'),
(178, 56, '2024-07-09', 753.0, 'Cancelled'),
(179, 82, '2024-06-06', 955.0, 'Pending'),
(180, 24, '2025-03-17', 4360.0, 'Pending'),
(181, 50, '2024-03-27', 252.0, 'Cancelled'),
(182, 35, '2024-11-04', 3652.0, 'Completed'),
(183, 18, '2024-11-07', 958.0, 'Completed'),
(184, 74, '2024-09-05', 3490.0, 'Completed'),
(185, 38, '2025-12-10', 1481.0, 'Completed'),
(186, 89, '2025-03-04', 1197.0, 'Cancelled'),
(187, 85, '2025-11-11', 7764.0, 'Completed'),
(188, 51, '2025-04-19', 3417.0, 'Cancelled'),
(189, 15, '2024-05-25', 4643.0, 'Completed'),
(190, 22, '2024-09-06', 1805.0, 'Cancelled'),
(191, 52, '2025-10-06', 686.0, 'Completed'),
(192, 27, '2024-10-12', 129.0, 'Completed'),
(193, 68, '2025-10-16', 1891.0, 'Completed'),
(194, 24, '2025-01-17', 825.0, 'Completed'),
(195, 63, '2024-05-19', 1240.0, 'Completed'),
(196, 22, '2025-04-13', 1724.0, 'Cancelled'),
(197, 70, '2024-08-11', 178.0, 'Pending'),
(198, 57, '2024-04-30', 504.0, 'Completed'),
(199, 8, '2025-08-06', 1623.0, 'Completed'),
(200, 8, '2024-10-10', 445.0, 'Completed'),
(201, 10, '2025-10-10', 2202.0, 'Completed'),
(202, 28, '2025-05-21', 1233.0, 'Completed'),
(203, 1, '2025-03-14', 787.0, 'Completed'),
(204, 7, '2025-02-09', 346.0, 'Completed'),
(205, 55, '2025-12-11', 3663.0, 'Completed'),
(206, 57, '2024-12-25', 625.0, 'Completed'),
(207, 50, '2024-12-25', 1285.0, 'Pending'),
(208, 67, '2025-09-13', 846.0, 'Cancelled'),
(209, 15, '2024-09-03', 69.0, 'Pending'),
(210, 47, '2025-07-13', 9355.0, 'Completed'),
(211, 69, '2025-09-22', 735.0, 'Completed'),
(212, 40, '2025-11-13', 11697.0, 'Completed'),
(213, 45, '2025-06-19', 3342.0, 'Cancelled'),
(214, 55, '2024-10-05', 387.0, 'Cancelled'),
(215, 66, '2025-01-03', 3276.0, 'Completed'),
(216, 71, '2025-11-02', 465.0, 'Pending'),
(217, 16, '2025-05-29', 287.0, 'Completed'),
(218, 38, '2025-07-31', 945.0, 'Completed'),
(219, 43, '2024-01-02', 4135.0, 'Pending'),
(220, 6, '2024-08-25', 802.0, 'Cancelled');
/* 
Table: Order_Items
This table stores detailed records of products included in each order.
It links Orders and Products, and includes quantity and unit price for each item.
Used for analyzing product-level sales and customer purchasing patterns.
*/
INSERT INTO Order_Items (order_item_id, order_id, product_id, quantity, unit_price, subtotal) VALUES
(1, 1, 16, 3, 89.0, 267.0),
(2, 1, 15, 1, 149.0, 149.0),
(3, 1, 9, 3, 299.0, 897.0),
(4, 2, 29, 2, 35.0, 70.0),
(5, 2, 38, 1, 59.0, 59.0),
(6, 3, 6, 2, 79.0, 158.0),
(7, 4, 36, 2, 79.0, 158.0),
(8, 5, 15, 1, 149.0, 149.0),
(9, 6, 35, 1, 129.0, 129.0),
(10, 6, 16, 2, 89.0, 178.0),
(11, 7, 37, 1, 45.0, 45.0),
(12, 7, 21, 3, 99.0, 297.0),
(13, 8, 15, 2, 149.0, 298.0),
(14, 8, 9, 1, 299.0, 299.0),
(15, 8, 33, 1, 179.0, 179.0),
(16, 9, 39, 3, 69.0, 207.0),
(17, 9, 30, 1, 49.0, 49.0),
(18, 9, 34, 3, 69.0, 207.0),
(19, 9, 17, 3, 129.0, 387.0),
(20, 10, 30, 3, 49.0, 147.0),
(21, 10, 1, 3, 3899.0, 11697.0),
(22, 11, 10, 1, 89.0, 89.0),
(23, 11, 24, 3, 399.0, 1197.0),
(24, 12, 20, 1, 119.0, 119.0),
(25, 12, 16, 3, 89.0, 267.0),
(26, 12, 4, 1, 699.0, 699.0),
(27, 13, 14, 2, 1899.0, 3798.0),
(28, 13, 35, 3, 129.0, 387.0),
(29, 13, 13, 3, 449.0, 1347.0),
(30, 13, 20, 2, 119.0, 238.0),
(31, 14, 22, 1, 249.0, 249.0),
(32, 15, 33, 1, 179.0, 179.0),
(33, 16, 16, 1, 89.0, 89.0),
(34, 16, 31, 1, 249.0, 249.0),
(35, 16, 27, 3, 149.0, 447.0),
(36, 16, 13, 2, 449.0, 898.0),
(37, 17, 26, 3, 199.0, 597.0),
(38, 18, 5, 3, 1099.0, 3297.0),
(39, 18, 29, 1, 35.0, 35.0),
(40, 19, 32, 1, 99.0, 99.0),
(41, 19, 31, 1, 249.0, 249.0),
(42, 19, 14, 2, 1899.0, 3798.0),
(43, 19, 26, 1, 199.0, 199.0),
(44, 20, 19, 1, 249.0, 249.0),
(45, 20, 14, 3, 1899.0, 5697.0),
(46, 21, 26, 3, 199.0, 597.0),
(47, 21, 8, 1, 399.0, 399.0),
(48, 22, 16, 1, 89.0, 89.0),
(49, 22, 17, 3, 129.0, 387.0),
(50, 22, 26, 3, 199.0, 597.0),
(51, 23, 29, 3, 35.0, 105.0),
(52, 23, 35, 2, 129.0, 258.0),
(53, 24, 18, 3, 299.0, 897.0),
(54, 24, 19, 1, 249.0, 249.0),
(55, 25, 17, 2, 129.0, 258.0),
(56, 25, 4, 1, 699.0, 699.0),
(57, 25, 6, 1, 79.0, 79.0),
(58, 25, 28, 2, 89.0, 178.0),
(59, 26, 36, 3, 79.0, 237.0),
(60, 26, 1, 1, 3899.0, 3899.0),
(61, 26, 8, 3, 399.0, 1197.0),
(62, 26, 5, 1, 1099.0, 1099.0),
(63, 27, 20, 2, 119.0, 238.0),
(64, 28, 16, 1, 89.0, 89.0),
(65, 28, 11, 2, 549.0, 1098.0),
(66, 29, 7, 1, 199.0, 199.0),
(67, 29, 25, 2, 59.0, 118.0),
(68, 30, 23, 3, 109.0, 327.0),
(69, 30, 33, 3, 179.0, 537.0),
(70, 30, 26, 2, 199.0, 398.0),
(71, 31, 25, 3, 59.0, 177.0),
(72, 32, 28, 3, 89.0, 267.0),
(73, 32, 5, 2, 1099.0, 2198.0),
(74, 32, 22, 3, 249.0, 747.0),
(75, 33, 40, 2, 89.0, 178.0),
(76, 33, 37, 2, 45.0, 90.0),
(77, 34, 29, 3, 35.0, 105.0),
(78, 34, 14, 1, 1899.0, 1899.0),
(79, 34, 33, 3, 179.0, 537.0),
(80, 34, 31, 1, 249.0, 249.0),
(81, 35, 25, 2, 59.0, 118.0),
(82, 35, 32, 1, 99.0, 99.0),
(83, 36, 12, 2, 799.0, 1598.0),
(84, 36, 34, 1, 69.0, 69.0),
(85, 37, 29, 2, 35.0, 70.0),
(86, 37, 40, 3, 89.0, 267.0),
(87, 37, 33, 2, 179.0, 358.0),
(88, 38, 34, 2, 69.0, 138.0),
(89, 38, 32, 2, 99.0, 198.0),
(90, 38, 16, 1, 89.0, 89.0),
(91, 39, 35, 1, 129.0, 129.0),
(92, 39, 30, 1, 49.0, 49.0),
(93, 39, 27, 2, 149.0, 298.0),
(94, 40, 25, 3, 59.0, 177.0),
(95, 40, 27, 3, 149.0, 447.0),
(96, 40, 35, 3, 129.0, 387.0),
(97, 41, 26, 3, 199.0, 597.0),
(98, 42, 4, 2, 699.0, 1398.0),
(99, 42, 17, 2, 129.0, 258.0),
(100, 43, 31, 1, 249.0, 249.0),
(101, 44, 13, 3, 449.0, 1347.0),
(102, 44, 2, 1, 3199.0, 3199.0),
(103, 45, 11, 2, 549.0, 1098.0),
(104, 46, 13, 1, 449.0, 449.0),
(105, 46, 5, 3, 1099.0, 3297.0),
(106, 46, 38, 2, 59.0, 118.0),
(107, 46, 16, 3, 89.0, 267.0),
(108, 47, 1, 1, 3899.0, 3899.0),
(109, 47, 27, 2, 149.0, 298.0),
(110, 47, 32, 2, 99.0, 198.0),
(111, 48, 38, 1, 59.0, 59.0),
(112, 48, 18, 2, 299.0, 598.0),
(113, 48, 21, 2, 99.0, 198.0),
(114, 48, 16, 1, 89.0, 89.0),
(115, 49, 32, 2, 99.0, 198.0),
(116, 49, 14, 2, 1899.0, 3798.0),
(117, 50, 32, 3, 99.0, 297.0),
(118, 50, 36, 3, 79.0, 237.0),
(119, 50, 16, 2, 89.0, 178.0),
(120, 50, 31, 2, 249.0, 498.0),
(121, 51, 30, 2, 49.0, 98.0),
(122, 51, 18, 1, 299.0, 299.0),
(123, 51, 20, 1, 119.0, 119.0),
(124, 52, 7, 1, 199.0, 199.0),
(125, 52, 13, 2, 449.0, 898.0),
(126, 52, 19, 1, 249.0, 249.0),
(127, 53, 4, 3, 699.0, 2097.0),
(128, 54, 12, 2, 799.0, 1598.0),
(129, 54, 4, 1, 699.0, 699.0),
(130, 54, 17, 1, 129.0, 129.0),
(131, 55, 6, 3, 79.0, 237.0),
(132, 55, 16, 2, 89.0, 178.0),
(133, 55, 8, 3, 399.0, 1197.0),
(134, 56, 20, 3, 119.0, 357.0),
(135, 56, 37, 3, 45.0, 135.0),
(136, 56, 40, 1, 89.0, 89.0),
(137, 56, 4, 1, 699.0, 699.0),
(138, 57, 38, 1, 59.0, 59.0),
(139, 57, 13, 3, 449.0, 1347.0),
(140, 57, 28, 1, 89.0, 89.0),
(141, 58, 33, 2, 179.0, 358.0),
(142, 58, 35, 1, 129.0, 129.0),
(143, 58, 32, 3, 99.0, 297.0),
(144, 59, 18, 3, 299.0, 897.0),
(145, 60, 32, 2, 99.0, 198.0),
(146, 60, 6, 2, 79.0, 158.0),
(147, 60, 31, 2, 249.0, 498.0),
(148, 60, 23, 3, 109.0, 327.0),
(149, 61, 26, 2, 199.0, 398.0),
(150, 61, 36, 1, 79.0, 79.0),
(151, 61, 3, 2, 2499.0, 4998.0),
(152, 62, 4, 3, 699.0, 2097.0),
(153, 62, 13, 2, 449.0, 898.0),
(154, 62, 34, 3, 69.0, 207.0),
(155, 62, 24, 2, 399.0, 798.0),
(156, 63, 2, 3, 3199.0, 9597.0),
(157, 64, 8, 1, 399.0, 399.0),
(158, 64, 30, 3, 49.0, 147.0),
(159, 65, 25, 3, 59.0, 177.0),
(160, 65, 13, 3, 449.0, 1347.0),
(161, 66, 1, 3, 3899.0, 11697.0),
(162, 66, 19, 3, 249.0, 747.0),
(163, 66, 20, 3, 119.0, 357.0),
(164, 67, 15, 3, 149.0, 447.0),
(165, 67, 27, 2, 149.0, 298.0),
(166, 67, 3, 3, 2499.0, 7497.0),
(167, 67, 21, 2, 99.0, 198.0),
(168, 68, 1, 2, 3899.0, 7798.0),
(169, 68, 10, 2, 89.0, 178.0),
(170, 68, 27, 2, 149.0, 298.0),
(171, 68, 5, 3, 1099.0, 3297.0),
(172, 69, 21, 3, 99.0, 297.0),
(173, 69, 32, 1, 99.0, 99.0),
(174, 69, 35, 1, 129.0, 129.0),
(175, 69, 3, 3, 2499.0, 7497.0),
(176, 70, 29, 1, 35.0, 35.0),
(177, 71, 10, 3, 89.0, 267.0),
(178, 71, 16, 3, 89.0, 267.0),
(179, 71, 34, 1, 69.0, 69.0),
(180, 71, 27, 1, 149.0, 149.0),
(181, 72, 5, 2, 1099.0, 2198.0),
(182, 72, 29, 3, 35.0, 105.0),
(183, 73, 13, 1, 449.0, 449.0),
(184, 73, 25, 1, 59.0, 59.0),
(185, 73, 31, 2, 249.0, 498.0),
(186, 74, 37, 3, 45.0, 135.0),
(187, 75, 15, 2, 149.0, 298.0),
(188, 75, 13, 3, 449.0, 1347.0),
(189, 75, 40, 3, 89.0, 267.0),
(190, 76, 29, 2, 35.0, 70.0),
(191, 76, 3, 3, 2499.0, 7497.0),
(192, 76, 38, 1, 59.0, 59.0),
(193, 77, 22, 1, 249.0, 249.0),
(194, 77, 8, 1, 399.0, 399.0),
(195, 77, 30, 1, 49.0, 49.0),
(196, 78, 30, 2, 49.0, 98.0),
(197, 79, 31, 3, 249.0, 747.0),
(198, 79, 2, 3, 3199.0, 9597.0),
(199, 80, 9, 1, 299.0, 299.0),
(200, 81, 30, 3, 49.0, 147.0),
(201, 81, 24, 3, 399.0, 1197.0),
(202, 81, 35, 3, 129.0, 387.0),
(203, 81, 27, 1, 149.0, 149.0),
(204, 82, 35, 2, 129.0, 258.0),
(205, 82, 23, 2, 109.0, 218.0),
(206, 82, 4, 1, 699.0, 699.0),
(207, 83, 36, 1, 79.0, 79.0),
(208, 84, 9, 2, 299.0, 598.0),
(209, 84, 35, 1, 129.0, 129.0),
(210, 85, 9, 3, 299.0, 897.0),
(211, 86, 29, 3, 35.0, 105.0),
(212, 87, 30, 2, 49.0, 98.0),
(213, 87, 2, 2, 3199.0, 6398.0),
(214, 87, 4, 2, 699.0, 1398.0),
(215, 88, 39, 1, 69.0, 69.0),
(216, 88, 10, 2, 89.0, 178.0),
(217, 88, 5, 3, 1099.0, 3297.0),
(218, 89, 26, 2, 199.0, 398.0),
(219, 89, 27, 2, 149.0, 298.0),
(220, 89, 7, 3, 199.0, 597.0),
(221, 89, 21, 2, 99.0, 198.0),
(222, 90, 8, 3, 399.0, 1197.0),
(223, 90, 27, 2, 149.0, 298.0),
(224, 90, 23, 3, 109.0, 327.0),
(225, 91, 8, 1, 399.0, 399.0),
(226, 91, 18, 2, 299.0, 598.0),
(227, 91, 37, 3, 45.0, 135.0),
(228, 92, 18, 2, 299.0, 598.0),
(229, 92, 20, 2, 119.0, 238.0),
(230, 93, 27, 2, 149.0, 298.0),
(231, 93, 30, 2, 49.0, 98.0),
(232, 93, 22, 3, 249.0, 747.0),
(233, 93, 11, 2, 549.0, 1098.0),
(234, 94, 33, 2, 179.0, 358.0),
(235, 94, 8, 2, 399.0, 798.0),
(236, 95, 1, 1, 3899.0, 3899.0),
(237, 96, 28, 3, 89.0, 267.0),
(238, 96, 12, 3, 799.0, 2397.0),
(239, 96, 9, 1, 299.0, 299.0),
(240, 96, 25, 3, 59.0, 177.0),
(241, 97, 8, 2, 399.0, 798.0),
(242, 97, 26, 1, 199.0, 199.0),
(243, 97, 2, 3, 3199.0, 9597.0),
(244, 98, 34, 3, 69.0, 207.0),
(245, 98, 6, 2, 79.0, 158.0),
(246, 98, 26, 1, 199.0, 199.0),
(247, 98, 20, 2, 119.0, 238.0),
(248, 99, 16, 1, 89.0, 89.0),
(249, 99, 7, 2, 199.0, 398.0),
(250, 100, 37, 2, 45.0, 90.0),
(251, 100, 38, 3, 59.0, 177.0),
(252, 100, 29, 2, 35.0, 70.0),
(253, 100, 40, 1, 89.0, 89.0),
(254, 101, 33, 2, 179.0, 358.0),
(255, 101, 5, 2, 1099.0, 2198.0),
(256, 101, 20, 1, 119.0, 119.0),
(257, 102, 29, 3, 35.0, 105.0),
(258, 103, 29, 1, 35.0, 35.0),
(259, 104, 34, 2, 69.0, 138.0),
(260, 104, 40, 2, 89.0, 178.0),
(261, 104, 11, 2, 549.0, 1098.0),
(262, 104, 24, 2, 399.0, 798.0),
(263, 105, 19, 2, 249.0, 498.0),
(264, 105, 17, 1, 129.0, 129.0),
(265, 105, 39, 3, 69.0, 207.0),
(266, 105, 10, 3, 89.0, 267.0),
(267, 106, 28, 3, 89.0, 267.0),
(268, 107, 32, 1, 99.0, 99.0),
(269, 107, 13, 1, 449.0, 449.0),
(270, 107, 15, 1, 149.0, 149.0),
(271, 108, 12, 1, 799.0, 799.0),
(272, 108, 40, 3, 89.0, 267.0),
(273, 109, 20, 1, 119.0, 119.0),
(274, 109, 31, 2, 249.0, 498.0),
(275, 110, 17, 3, 129.0, 387.0),
(276, 110, 4, 2, 699.0, 1398.0),
(277, 111, 6, 2, 79.0, 158.0),
(278, 111, 11, 3, 549.0, 1647.0),
(279, 111, 18, 1, 299.0, 299.0),
(280, 112, 25, 2, 59.0, 118.0),
(281, 112, 6, 1, 79.0, 79.0),
(282, 113, 40, 2, 89.0, 178.0),
(283, 113, 1, 1, 3899.0, 3899.0),
(284, 113, 6, 1, 79.0, 79.0),
(285, 113, 2, 3, 3199.0, 9597.0),
(286, 114, 40, 2, 89.0, 178.0),
(287, 114, 30, 3, 49.0, 147.0),
(288, 114, 5, 3, 1099.0, 3297.0),
(289, 114, 8, 1, 399.0, 399.0),
(290, 115, 25, 2, 59.0, 118.0),
(291, 116, 5, 3, 1099.0, 3297.0),
(292, 116, 23, 3, 109.0, 327.0),
(293, 116, 16, 3, 89.0, 267.0),
(294, 117, 5, 1, 1099.0, 1099.0),
(295, 117, 30, 2, 49.0, 98.0),
(296, 118, 13, 2, 449.0, 898.0),
(297, 119, 12, 3, 799.0, 2397.0),
(298, 119, 32, 2, 99.0, 198.0),
(299, 119, 24, 1, 399.0, 399.0),
(300, 120, 6, 2, 79.0, 158.0),
(301, 121, 29, 3, 35.0, 105.0),
(302, 121, 3, 2, 2499.0, 4998.0),
(303, 121, 23, 2, 109.0, 218.0),
(304, 122, 10, 3, 89.0, 267.0),
(305, 123, 29, 2, 35.0, 70.0),
(306, 123, 24, 2, 399.0, 798.0),
(307, 124, 36, 1, 79.0, 79.0),
(308, 124, 8, 3, 399.0, 1197.0),
(309, 124, 17, 2, 129.0, 258.0),
(310, 124, 29, 3, 35.0, 105.0),
(311, 125, 21, 3, 99.0, 297.0),
(312, 126, 33, 1, 179.0, 179.0),
(313, 126, 15, 1, 149.0, 149.0),
(314, 126, 8, 1, 399.0, 399.0),
(315, 127, 20, 2, 119.0, 238.0),
(316, 128, 29, 2, 35.0, 70.0),
(317, 129, 20, 1, 119.0, 119.0),
(318, 129, 11, 2, 549.0, 1098.0),
(319, 130, 33, 3, 179.0, 537.0),
(320, 131, 3, 3, 2499.0, 7497.0),
(321, 132, 20, 3, 119.0, 357.0),
(322, 132, 31, 2, 249.0, 498.0),
(323, 132, 16, 2, 89.0, 178.0),
(324, 133, 14, 2, 1899.0, 3798.0),
(325, 133, 22, 3, 249.0, 747.0),
(326, 133, 39, 2, 69.0, 138.0),
(327, 133, 10, 3, 89.0, 267.0),
(328, 134, 18, 2, 299.0, 598.0),
(329, 135, 11, 3, 549.0, 1647.0),
(330, 135, 21, 3, 99.0, 297.0),
(331, 136, 6, 2, 79.0, 158.0),
(332, 137, 39, 1, 69.0, 69.0),
(333, 137, 31, 1, 249.0, 249.0),
(334, 137, 19, 2, 249.0, 498.0),
(335, 137, 35, 1, 129.0, 129.0),
(336, 138, 40, 1, 89.0, 89.0),
(337, 138, 8, 2, 399.0, 798.0),
(338, 138, 9, 2, 299.0, 598.0),
(339, 139, 3, 1, 2499.0, 2499.0),
(340, 140, 21, 2, 99.0, 198.0),
(341, 140, 40, 1, 89.0, 89.0),
(342, 141, 37, 2, 45.0, 90.0),
(343, 141, 20, 2, 119.0, 238.0),
(344, 141, 31, 3, 249.0, 747.0),
(345, 141, 2, 1, 3199.0, 3199.0),
(346, 142, 10, 3, 89.0, 267.0),
(347, 142, 16, 1, 89.0, 89.0),
(348, 142, 3, 1, 2499.0, 2499.0),
(349, 142, 37, 1, 45.0, 45.0),
(350, 143, 33, 3, 179.0, 537.0),
(351, 143, 40, 1, 89.0, 89.0),
(352, 143, 31, 3, 249.0, 747.0),
(353, 143, 4, 1, 699.0, 699.0),
(354, 144, 13, 2, 449.0, 898.0),
(355, 144, 16, 1, 89.0, 89.0),
(356, 144, 18, 2, 299.0, 598.0),
(357, 144, 36, 2, 79.0, 158.0),
(358, 145, 19, 3, 249.0, 747.0),
(359, 146, 36, 1, 79.0, 79.0),
(360, 146, 18, 3, 299.0, 897.0),
(361, 146, 9, 3, 299.0, 897.0),
(362, 147, 4, 2, 699.0, 1398.0),
(363, 147, 7, 2, 199.0, 398.0),
(364, 148, 21, 1, 99.0, 99.0),
(365, 148, 19, 3, 249.0, 747.0),
(366, 148, 4, 3, 699.0, 2097.0),
(367, 149, 19, 1, 249.0, 249.0),
(368, 149, 3, 2, 2499.0, 4998.0),
(369, 150, 13, 1, 449.0, 449.0),
(370, 150, 8, 3, 399.0, 1197.0),
(371, 150, 22, 2, 249.0, 498.0),
(372, 151, 40, 2, 89.0, 178.0),
(373, 151, 26, 3, 199.0, 597.0),
(374, 152, 29, 2, 35.0, 70.0),
(375, 152, 18, 2, 299.0, 598.0),
(376, 153, 20, 3, 119.0, 357.0),
(377, 153, 11, 2, 549.0, 1098.0),
(378, 153, 26, 3, 199.0, 597.0),
(379, 153, 33, 1, 179.0, 179.0),
(380, 154, 16, 1, 89.0, 89.0),
(381, 154, 39, 3, 69.0, 207.0),
(382, 155, 37, 1, 45.0, 45.0),
(383, 155, 35, 1, 129.0, 129.0),
(384, 156, 4, 2, 699.0, 1398.0),
(385, 156, 30, 2, 49.0, 98.0),
(386, 156, 9, 3, 299.0, 897.0),
(387, 156, 33, 1, 179.0, 179.0),
(388, 157, 1, 1, 3899.0, 3899.0),
(389, 157, 14, 1, 1899.0, 1899.0),
(390, 157, 38, 2, 59.0, 118.0),
(391, 158, 27, 3, 149.0, 447.0),
(392, 158, 12, 3, 799.0, 2397.0),
(393, 158, 9, 3, 299.0, 897.0),
(394, 159, 23, 1, 109.0, 109.0),
(395, 159, 8, 3, 399.0, 1197.0),
(396, 160, 20, 2, 119.0, 238.0),
(397, 161, 40, 1, 89.0, 89.0),
(398, 161, 2, 1, 3199.0, 3199.0),
(399, 161, 16, 3, 89.0, 267.0),
(400, 161, 14, 1, 1899.0, 1899.0),
(401, 162, 16, 3, 89.0, 267.0),
(402, 162, 20, 3, 119.0, 357.0),
(403, 162, 10, 1, 89.0, 89.0),
(404, 163, 4, 2, 699.0, 1398.0),
(405, 163, 23, 3, 109.0, 327.0),
(406, 163, 25, 2, 59.0, 118.0),
(407, 163, 34, 2, 69.0, 138.0),
(408, 164, 30, 3, 49.0, 147.0),
(409, 164, 4, 2, 699.0, 1398.0),
(410, 165, 4, 2, 699.0, 1398.0),
(411, 165, 18, 3, 299.0, 897.0),
(412, 166, 1, 3, 3899.0, 11697.0),
(413, 166, 14, 1, 1899.0, 1899.0),
(414, 166, 13, 3, 449.0, 1347.0),
(415, 167, 20, 3, 119.0, 357.0),
(416, 167, 17, 2, 129.0, 258.0),
(417, 167, 24, 2, 399.0, 798.0),
(418, 168, 21, 3, 99.0, 297.0),
(419, 168, 27, 1, 149.0, 149.0),
(420, 168, 3, 3, 2499.0, 7497.0),
(421, 169, 25, 1, 59.0, 59.0),
(422, 169, 37, 2, 45.0, 90.0),
(423, 170, 12, 1, 799.0, 799.0),
(424, 170, 35, 1, 129.0, 129.0),
(425, 170, 4, 3, 699.0, 2097.0),
(426, 170, 34, 1, 69.0, 69.0),
(427, 171, 2, 2, 3199.0, 6398.0),
(428, 171, 1, 1, 3899.0, 3899.0),
(429, 171, 35, 1, 129.0, 129.0),
(430, 171, 36, 3, 79.0, 237.0),
(431, 172, 16, 3, 89.0, 267.0),
(432, 172, 13, 3, 449.0, 1347.0),
(433, 173, 3, 1, 2499.0, 2499.0),
(434, 174, 32, 2, 99.0, 198.0),
(435, 175, 18, 3, 299.0, 897.0),
(436, 175, 3, 3, 2499.0, 7497.0),
(437, 175, 5, 1, 1099.0, 1099.0),
(438, 175, 35, 1, 129.0, 129.0),
(439, 176, 20, 1, 119.0, 119.0),
(440, 177, 4, 1, 699.0, 699.0),
(441, 177, 7, 1, 199.0, 199.0),
(442, 177, 28, 2, 89.0, 178.0),
(443, 178, 6, 3, 79.0, 237.0),
(444, 178, 40, 1, 89.0, 89.0),
(445, 178, 19, 1, 249.0, 249.0),
(446, 178, 16, 2, 89.0, 178.0),
(447, 179, 24, 1, 399.0, 399.0),
(448, 179, 7, 2, 199.0, 398.0),
(449, 179, 6, 2, 79.0, 158.0),
(450, 180, 7, 3, 199.0, 597.0),
(451, 180, 2, 1, 3199.0, 3199.0),
(452, 180, 6, 3, 79.0, 237.0),
(453, 180, 23, 3, 109.0, 327.0),
(454, 181, 37, 1, 45.0, 45.0),
(455, 181, 34, 3, 69.0, 207.0),
(456, 182, 10, 2, 89.0, 178.0),
(457, 182, 5, 2, 1099.0, 2198.0),
(458, 182, 11, 2, 549.0, 1098.0),
(459, 182, 28, 2, 89.0, 178.0),
(460, 183, 22, 2, 249.0, 498.0),
(461, 183, 40, 2, 89.0, 178.0),
(462, 183, 25, 3, 59.0, 177.0),
(463, 183, 29, 3, 35.0, 105.0),
(464, 184, 18, 3, 299.0, 897.0),
(465, 184, 26, 1, 199.0, 199.0),
(466, 184, 24, 3, 399.0, 1197.0),
(467, 184, 8, 3, 399.0, 1197.0),
(468, 185, 32, 2, 99.0, 198.0),
(469, 185, 9, 3, 299.0, 897.0),
(470, 185, 20, 1, 119.0, 119.0),
(471, 185, 16, 3, 89.0, 267.0),
(472, 186, 24, 3, 399.0, 1197.0),
(473, 187, 40, 3, 89.0, 267.0),
(474, 187, 3, 3, 2499.0, 7497.0),
(475, 188, 23, 2, 109.0, 218.0),
(476, 188, 2, 1, 3199.0, 3199.0),
(477, 189, 22, 3, 249.0, 747.0),
(478, 189, 30, 2, 49.0, 98.0),
(479, 189, 14, 2, 1899.0, 3798.0),
(480, 190, 36, 2, 79.0, 158.0),
(481, 190, 11, 3, 549.0, 1647.0),
(482, 191, 28, 1, 89.0, 89.0),
(483, 191, 26, 3, 199.0, 597.0),
(484, 192, 35, 1, 129.0, 129.0),
(485, 193, 40, 2, 89.0, 178.0),
(486, 193, 26, 2, 199.0, 398.0),
(487, 193, 38, 2, 59.0, 118.0),
(488, 193, 8, 3, 399.0, 1197.0),
(489, 194, 27, 2, 149.0, 298.0),
(490, 194, 39, 2, 69.0, 138.0),
(491, 194, 9, 1, 299.0, 299.0),
(492, 194, 37, 2, 45.0, 90.0),
(493, 195, 36, 3, 79.0, 237.0),
(494, 195, 33, 2, 179.0, 358.0),
(495, 195, 32, 2, 99.0, 198.0),
(496, 195, 27, 3, 149.0, 447.0),
(497, 196, 36, 1, 79.0, 79.0),
(498, 196, 33, 2, 179.0, 358.0),
(499, 196, 8, 3, 399.0, 1197.0),
(500, 196, 37, 2, 45.0, 90.0),
(501, 197, 16, 2, 89.0, 178.0),
(502, 198, 38, 3, 59.0, 177.0),
(503, 198, 23, 3, 109.0, 327.0),
(504, 199, 39, 2, 69.0, 138.0),
(505, 199, 35, 3, 129.0, 387.0),
(506, 199, 11, 2, 549.0, 1098.0),
(507, 200, 16, 3, 89.0, 267.0),
(508, 200, 10, 2, 89.0, 178.0),
(509, 201, 33, 2, 179.0, 358.0),
(510, 201, 18, 2, 299.0, 598.0),
(511, 201, 24, 3, 399.0, 1197.0),
(512, 201, 30, 1, 49.0, 49.0),
(513, 202, 19, 3, 249.0, 747.0),
(514, 202, 22, 1, 249.0, 249.0),
(515, 202, 36, 3, 79.0, 237.0),
(516, 203, 20, 2, 119.0, 238.0),
(517, 203, 11, 1, 549.0, 549.0),
(518, 204, 28, 3, 89.0, 267.0),
(519, 204, 6, 1, 79.0, 79.0),
(520, 205, 5, 3, 1099.0, 3297.0),
(521, 205, 15, 1, 149.0, 149.0),
(522, 205, 25, 1, 59.0, 59.0),
(523, 205, 6, 2, 79.0, 158.0),
(524, 206, 27, 3, 149.0, 447.0),
(525, 206, 40, 2, 89.0, 178.0),
(526, 207, 9, 3, 299.0, 897.0),
(527, 207, 16, 1, 89.0, 89.0),
(528, 207, 18, 1, 299.0, 299.0),
(529, 208, 26, 3, 199.0, 597.0),
(530, 208, 19, 1, 249.0, 249.0),
(531, 209, 34, 1, 69.0, 69.0),
(532, 210, 5, 2, 1099.0, 2198.0),
(533, 210, 2, 1, 3199.0, 3199.0),
(534, 210, 38, 1, 59.0, 59.0),
(535, 210, 1, 1, 3899.0, 3899.0),
(536, 211, 6, 1, 79.0, 79.0),
(537, 211, 20, 1, 119.0, 119.0),
(538, 211, 33, 3, 179.0, 537.0),
(539, 212, 1, 3, 3899.0, 11697.0),
(540, 213, 11, 3, 549.0, 1647.0),
(541, 213, 24, 2, 399.0, 798.0),
(542, 213, 9, 3, 299.0, 897.0),
(543, 214, 17, 3, 129.0, 387.0),
(544, 215, 37, 1, 45.0, 45.0),
(545, 215, 11, 3, 549.0, 1647.0),
(546, 215, 24, 3, 399.0, 1197.0),
(547, 215, 17, 3, 129.0, 387.0),
(548, 216, 21, 2, 99.0, 198.0),
(549, 216, 16, 3, 89.0, 267.0),
(550, 217, 15, 1, 149.0, 149.0),
(551, 217, 34, 2, 69.0, 138.0),
(552, 218, 30, 3, 49.0, 147.0),
(553, 218, 24, 2, 399.0, 798.0),
(554, 219, 7, 1, 199.0, 199.0),
(555, 219, 14, 2, 1899.0, 3798.0),
(556, 219, 34, 2, 69.0, 138.0),
(557, 220, 24, 1, 399.0, 399.0),
(558, 220, 30, 3, 49.0, 147.0),
(559, 220, 6, 1, 79.0, 79.0),
(560, 220, 38, 3, 59.0, 177.0);
--  Stores all customer orders including order date, total amount, and order status
INSERT INTO Payments (payment_id, order_id, payment_method, amount, payment_date, payment_status) VALUES
(1, 1, 'Credit Card', 1313.0, '2024-04-24', 'Paid'),
(2, 2, 'Mada', 129.0, NULL, 'Pending'),
(3, 3, 'Credit Card', 158.0, '2024-08-08', 'Paid'),
(4, 4, 'Apple Pay', 158.0, NULL, 'Pending'),
(5, 5, 'Cash on Delivery', 149.0, '2024-08-21', 'Paid'),
(6, 6, 'Cash on Delivery', 307.0, '2025-11-30', 'Paid'),
(7, 7, 'Cash on Delivery', 342.0, '2024-10-01', 'Paid'),
(8, 8, 'Credit Card', 776.0, NULL, 'Pending'),
(9, 9, 'Credit Card', 850.0, NULL, 'Pending'),
(10, 10, 'Apple Pay', 11844.0, NULL, 'Pending'),
(11, 11, 'Credit Card', 1286.0, '2024-11-01', 'Refunded'),
(12, 12, 'Credit Card', 1085.0, '2024-01-20', 'Paid'),
(13, 13, 'Cash on Delivery', 5770.0, '2025-06-24', 'Refunded'),
(14, 14, 'Mada', 249.0, '2024-09-10', 'Paid'),
(15, 15, 'Apple Pay', 179.0, '2024-02-02', 'Paid'),
(16, 16, 'Apple Pay', 1683.0, '2025-08-07', 'Refunded'),
(17, 17, 'Apple Pay', 597.0, '2024-02-25', 'Paid'),
(18, 18, 'Credit Card', 3332.0, NULL, 'Pending'),
(19, 19, 'Cash on Delivery', 4345.0, '2024-08-30', 'Paid'),
(20, 20, 'Credit Card', 5946.0, '2025-05-13', 'Paid'),
(21, 21, 'Credit Card', 996.0, '2025-09-01', 'Paid'),
(22, 22, 'Apple Pay', 1073.0, '2024-09-24', 'Paid'),
(23, 23, 'Credit Card', 363.0, '2025-01-13', 'Paid'),
(24, 24, 'Apple Pay', 1146.0, '2024-04-19', 'Refunded'),
(25, 25, 'Mada', 1214.0, '2024-09-27', 'Refunded'),
(26, 26, 'Apple Pay', 6432.0, '2025-03-28', 'Refunded'),
(27, 27, 'Credit Card', 238.0, '2025-03-16', 'Paid'),
(28, 28, 'Credit Card', 1187.0, NULL, 'Pending'),
(29, 29, 'Mada', 317.0, '2024-09-11', 'Paid'),
(30, 30, 'Credit Card', 1262.0, '2024-10-12', 'Paid'),
(31, 31, 'Mada', 177.0, NULL, 'Pending'),
(32, 32, 'Credit Card', 3212.0, '2025-07-05', 'Paid'),
(33, 33, 'Credit Card', 268.0, NULL, 'Pending'),
(34, 34, 'Apple Pay', 2790.0, '2025-09-13', 'Paid'),
(35, 35, 'Mada', 217.0, '2025-02-28', 'Refunded'),
(36, 36, 'Mada', 1667.0, NULL, 'Pending'),
(37, 37, 'Mada', 695.0, '2025-06-27', 'Refunded'),
(38, 38, 'Apple Pay', 425.0, '2024-09-22', 'Paid'),
(39, 39, 'Cash on Delivery', 476.0, NULL, 'Pending'),
(40, 40, 'Mada', 1011.0, '2024-01-07', 'Paid'),
(41, 41, 'Credit Card', 597.0, '2024-05-10', 'Refunded'),
(42, 42, 'Mada', 1656.0, NULL, 'Pending'),
(43, 43, 'Credit Card', 249.0, '2025-03-07', 'Paid'),
(44, 44, 'Mada', 4546.0, '2024-02-11', 'Paid'),
(45, 45, 'Credit Card', 1098.0, '2025-09-12', 'Refunded'),
(46, 46, 'Credit Card', 4131.0, NULL, 'Pending'),
(47, 47, 'Cash on Delivery', 4395.0, '2025-01-14', 'Paid'),
(48, 48, 'Cash on Delivery', 944.0, NULL, 'Pending'),
(49, 49, 'Apple Pay', 3996.0, '2025-05-21', 'Paid'),
(50, 50, 'Credit Card', 1210.0, '2024-03-28', 'Paid'),
(51, 51, 'Mada', 516.0, '2025-07-17', 'Paid'),
(52, 52, 'Apple Pay', 1346.0, '2025-08-26', 'Refunded'),
(53, 53, 'Apple Pay', 2097.0, '2024-05-09', 'Paid'),
(54, 54, 'Cash on Delivery', 2426.0, NULL, 'Pending'),
(55, 55, 'Mada', 1612.0, '2024-06-01', 'Refunded'),
(56, 56, 'Mada', 1280.0, '2025-03-29', 'Paid'),
(57, 57, 'Mada', 1495.0, '2024-03-13', 'Paid'),
(58, 58, 'Credit Card', 784.0, NULL, 'Pending'),
(59, 59, 'Credit Card', 897.0, '2024-04-03', 'Paid'),
(60, 60, 'Credit Card', 1181.0, '2024-07-04', 'Refunded'),
(61, 61, 'Apple Pay', 5475.0, NULL, 'Pending'),
(62, 62, 'Credit Card', 4000.0, NULL, 'Pending'),
(63, 63, 'Mada', 9597.0, NULL, 'Pending'),
(64, 64, 'Mada', 546.0, '2025-02-21', 'Paid'),
(65, 65, 'Mada', 1524.0, '2025-04-12', 'Refunded'),
(66, 66, 'Cash on Delivery', 12801.0, '2025-02-28', 'Paid'),
(67, 67, 'Cash on Delivery', 8440.0, '2024-07-12', 'Paid'),
(68, 68, 'Cash on Delivery', 11571.0, '2024-04-12', 'Refunded'),
(69, 69, 'Apple Pay', 8022.0, '2025-11-21', 'Refunded'),
(70, 70, 'Apple Pay', 35.0, '2025-03-20', 'Paid'),
(71, 71, 'Mada', 752.0, '2025-01-02', 'Paid'),
(72, 72, 'Apple Pay', 2303.0, '2025-11-24', 'Refunded'),
(73, 73, 'Apple Pay', 1006.0, NULL, 'Pending'),
(74, 74, 'Credit Card', 135.0, '2025-02-09', 'Paid'),
(75, 75, 'Mada', 1912.0, '2024-08-23', 'Refunded'),
(76, 76, 'Credit Card', 7626.0, '2025-10-23', 'Paid'),
(77, 77, 'Cash on Delivery', 697.0, NULL, 'Pending'),
(78, 78, 'Apple Pay', 98.0, '2024-09-27', 'Refunded'),
(79, 79, 'Apple Pay', 10344.0, '2025-01-15', 'Paid'),
(80, 80, 'Credit Card', 299.0, NULL, 'Pending'),
(81, 81, 'Cash on Delivery', 1880.0, '2025-07-04', 'Paid'),
(82, 82, 'Credit Card', 1175.0, '2025-01-06', 'Paid'),
(83, 83, 'Mada', 79.0, '2025-08-01', 'Paid'),
(84, 84, 'Credit Card', 727.0, '2024-01-03', 'Paid'),
(85, 85, 'Cash on Delivery', 897.0, '2024-06-27', 'Paid'),
(86, 86, 'Mada', 105.0, '2025-01-05', 'Refunded'),
(87, 87, 'Credit Card', 7894.0, '2025-11-05', 'Refunded'),
(88, 88, 'Apple Pay', 3544.0, '2024-03-16', 'Paid'),
(89, 89, 'Apple Pay', 1491.0, '2025-02-27', 'Paid'),
(90, 90, 'Credit Card', 1822.0, '2025-07-23', 'Paid'),
(91, 91, 'Credit Card', 1132.0, '2024-12-24', 'Refunded'),
(92, 92, 'Credit Card', 836.0, '2024-09-30', 'Paid'),
(93, 93, 'Credit Card', 2241.0, '2025-06-27', 'Paid'),
(94, 94, 'Credit Card', 1156.0, '2025-02-28', 'Paid'),
(95, 95, 'Apple Pay', 3899.0, NULL, 'Pending'),
(96, 96, 'Apple Pay', 3140.0, '2024-05-02', 'Paid'),
(97, 97, 'Cash on Delivery', 10594.0, NULL, 'Pending'),
(98, 98, 'Mada', 802.0, NULL, 'Pending'),
(99, 99, 'Mada', 487.0, '2024-12-23', 'Paid'),
(100, 100, 'Cash on Delivery', 426.0, NULL, 'Pending'),
(101, 101, 'Credit Card', 2675.0, '2025-08-28', 'Paid'),
(102, 102, 'Mada', 105.0, '2025-08-17', 'Refunded'),
(103, 103, 'Apple Pay', 35.0, '2025-05-28', 'Paid'),
(104, 104, 'Apple Pay', 2212.0, NULL, 'Pending'),
(105, 105, 'Mada', 1101.0, '2024-12-03', 'Paid'),
(106, 106, 'Apple Pay', 267.0, '2025-12-02', 'Refunded'),
(107, 107, 'Apple Pay', 697.0, '2024-07-03', 'Paid'),
(108, 108, 'Cash on Delivery', 1066.0, '2025-01-20', 'Paid'),
(109, 109, 'Cash on Delivery', 617.0, '2025-04-04', 'Paid'),
(110, 110, 'Apple Pay', 1785.0, '2024-07-23', 'Refunded'),
(111, 111, 'Cash on Delivery', 2104.0, '2025-06-12', 'Paid'),
(112, 112, 'Credit Card', 197.0, '2025-05-29', 'Paid'),
(113, 113, 'Cash on Delivery', 13753.0, NULL, 'Pending'),
(114, 114, 'Mada', 4021.0, '2024-02-18', 'Paid'),
(115, 115, 'Credit Card', 118.0, '2024-03-10', 'Refunded'),
(116, 116, 'Credit Card', 3891.0, '2024-09-16', 'Paid'),
(117, 117, 'Mada', 1197.0, '2025-05-05', 'Paid'),
(118, 118, 'Apple Pay', 898.0, '2025-04-29', 'Paid'),
(119, 119, 'Cash on Delivery', 2994.0, NULL, 'Pending'),
(120, 120, 'Apple Pay', 158.0, '2024-10-27', 'Paid'),
(121, 121, 'Credit Card', 5321.0, NULL, 'Pending'),
(122, 122, 'Cash on Delivery', 267.0, '2025-11-26', 'Paid'),
(123, 123, 'Credit Card', 868.0, '2025-08-03', 'Paid'),
(124, 124, 'Cash on Delivery', 1639.0, NULL, 'Pending'),
(125, 125, 'Apple Pay', 297.0, NULL, 'Pending'),
(126, 126, 'Cash on Delivery', 727.0, '2024-06-10', 'Paid'),
(127, 127, 'Cash on Delivery', 238.0, '2025-09-18', 'Paid'),
(128, 128, 'Apple Pay', 70.0, '2024-05-08', 'Paid'),
(129, 129, 'Mada', 1217.0, '2024-02-26', 'Paid'),
(130, 130, 'Mada', 537.0, '2025-10-02', 'Paid'),
(131, 131, 'Apple Pay', 7497.0, '2024-02-12', 'Paid'),
(132, 132, 'Cash on Delivery', 1033.0, NULL, 'Pending'),
(133, 133, 'Apple Pay', 4950.0, NULL, 'Pending'),
(134, 134, 'Mada', 598.0, NULL, 'Pending'),
(135, 135, 'Apple Pay', 1944.0, NULL, 'Pending'),
(136, 136, 'Cash on Delivery', 158.0, NULL, 'Pending'),
(137, 137, 'Apple Pay', 945.0, '2024-02-21', 'Paid'),
(138, 138, 'Apple Pay', 1485.0, NULL, 'Pending'),
(139, 139, 'Mada', 2499.0, NULL, 'Pending'),
(140, 140, 'Cash on Delivery', 287.0, '2025-09-12', 'Refunded'),
(141, 141, 'Cash on Delivery', 4274.0, '2025-08-30', 'Paid'),
(142, 142, 'Cash on Delivery', 2900.0, '2025-06-20', 'Refunded'),
(143, 143, 'Apple Pay', 2072.0, '2025-02-26', 'Paid'),
(144, 144, 'Mada', 1743.0, '2024-12-28', 'Paid'),
(145, 145, 'Credit Card', 747.0, '2024-05-29', 'Paid'),
(146, 146, 'Mada', 1873.0, '2024-07-25', 'Refunded'),
(147, 147, 'Cash on Delivery', 1796.0, '2025-06-27', 'Paid'),
(148, 148, 'Mada', 2943.0, '2025-05-03', 'Paid'),
(149, 149, 'Credit Card', 5247.0, NULL, 'Pending'),
(150, 150, 'Apple Pay', 2144.0, NULL, 'Pending'),
(151, 151, 'Apple Pay', 775.0, '2025-08-04', 'Paid'),
(152, 152, 'Credit Card', 668.0, NULL, 'Pending'),
(153, 153, 'Apple Pay', 2231.0, '2025-11-14', 'Paid'),
(154, 154, 'Cash on Delivery', 296.0, NULL, 'Pending'),
(155, 155, 'Apple Pay', 174.0, '2024-04-24', 'Paid'),
(156, 156, 'Cash on Delivery', 2572.0, '2024-04-03', 'Refunded'),
(157, 157, 'Apple Pay', 5916.0, NULL, 'Pending'),
(158, 158, 'Cash on Delivery', 3741.0, '2025-04-28', 'Paid'),
(159, 159, 'Cash on Delivery', 1306.0, '2025-11-08', 'Refunded'),
(160, 160, 'Cash on Delivery', 238.0, '2024-08-16', 'Paid'),
(161, 161, 'Cash on Delivery', 5454.0, '2024-04-25', 'Paid'),
(162, 162, 'Cash on Delivery', 713.0, '2025-08-12', 'Paid'),
(163, 163, 'Mada', 1981.0, NULL, 'Pending'),
(164, 164, 'Cash on Delivery', 1545.0, '2024-08-18', 'Paid'),
(165, 165, 'Credit Card', 2295.0, '2025-01-14', 'Paid'),
(166, 166, 'Cash on Delivery', 14943.0, '2024-08-01', 'Paid'),
(167, 167, 'Credit Card', 1413.0, '2025-04-22', 'Refunded'),
(168, 168, 'Mada', 7943.0, '2024-11-23', 'Paid'),
(169, 169, 'Apple Pay', 149.0, '2024-07-19', 'Paid'),
(170, 170, 'Credit Card', 3094.0, '2024-06-22', 'Paid'),
(171, 171, 'Apple Pay', 10663.0, NULL, 'Pending'),
(172, 172, 'Apple Pay', 1614.0, '2024-04-19', 'Paid'),
(173, 173, 'Cash on Delivery', 2499.0, '2024-08-19', 'Paid'),
(174, 174, 'Apple Pay', 198.0, '2024-01-10', 'Paid'),
(175, 175, 'Apple Pay', 9622.0, '2024-08-04', 'Refunded'),
(176, 176, 'Mada', 119.0, NULL, 'Pending'),
(177, 177, 'Cash on Delivery', 1076.0, '2024-05-23', 'Paid'),
(178, 178, 'Mada', 753.0, '2024-07-09', 'Refunded'),
(179, 179, 'Apple Pay', 955.0, NULL, 'Pending'),
(180, 180, 'Apple Pay', 4360.0, NULL, 'Pending'),
(181, 181, 'Cash on Delivery', 252.0, '2024-03-27', 'Refunded'),
(182, 182, 'Credit Card', 3652.0, '2024-11-04', 'Paid'),
(183, 183, 'Mada', 958.0, '2024-11-07', 'Paid'),
(184, 184, 'Mada', 3490.0, '2024-09-05', 'Paid'),
(185, 185, 'Cash on Delivery', 1481.0, '2025-12-10', 'Paid'),
(186, 186, 'Credit Card', 1197.0, '2025-03-04', 'Refunded'),
(187, 187, 'Cash on Delivery', 7764.0, '2025-11-11', 'Paid'),
(188, 188, 'Apple Pay', 3417.0, '2025-04-19', 'Refunded'),
(189, 189, 'Cash on Delivery', 4643.0, '2024-05-25', 'Paid'),
(190, 190, 'Cash on Delivery', 1805.0, '2024-09-06', 'Refunded'),
(191, 191, 'Mada', 686.0, '2025-10-06', 'Paid'),
(192, 192, 'Apple Pay', 129.0, '2024-10-12', 'Paid'),
(193, 193, 'Mada', 1891.0, '2025-10-16', 'Paid'),
(194, 194, 'Mada', 825.0, '2025-01-17', 'Paid'),
(195, 195, 'Cash on Delivery', 1240.0, '2024-05-19', 'Paid'),
(196, 196, 'Credit Card', 1724.0, '2025-04-13', 'Refunded'),
(197, 197, 'Credit Card', 178.0, NULL, 'Pending'),
(198, 198, 'Cash on Delivery', 504.0, '2024-04-30', 'Paid'),
(199, 199, 'Apple Pay', 1623.0, '2025-08-06', 'Paid'),
(200, 200, 'Mada', 445.0, '2024-10-10', 'Paid'),
(201, 201, 'Credit Card', 2202.0, '2025-10-10', 'Paid'),
(202, 202, 'Cash on Delivery', 1233.0, '2025-05-21', 'Paid'),
(203, 203, 'Apple Pay', 787.0, '2025-03-14', 'Paid'),
(204, 204, 'Credit Card', 346.0, '2025-02-09', 'Paid'),
(205, 205, 'Apple Pay', 3663.0, '2025-12-11', 'Paid'),
(206, 206, 'Mada', 625.0, '2024-12-25', 'Paid'),
(207, 207, 'Apple Pay', 1285.0, NULL, 'Pending'),
(208, 208, 'Mada', 846.0, '2025-09-13', 'Refunded'),
(209, 209, 'Apple Pay', 69.0, NULL, 'Pending'),
(210, 210, 'Cash on Delivery', 9355.0, '2025-07-13', 'Paid'),
(211, 211, 'Apple Pay', 735.0, '2025-09-22', 'Paid'),
(212, 212, 'Mada', 11697.0, '2025-11-13', 'Paid'),
(213, 213, 'Credit Card', 3342.0, '2025-06-19', 'Refunded'),
(214, 214, 'Credit Card', 387.0, '2024-10-05', 'Refunded'),
(215, 215, 'Credit Card', 3276.0, '2025-01-03', 'Paid'),
(216, 216, 'Apple Pay', 465.0, NULL, 'Pending'),
(217, 217, 'Credit Card', 287.0, '2025-05-29', 'Paid'),
(218, 218, 'Mada', 945.0, '2025-07-31', 'Paid'),
(219, 219, 'Credit Card', 4135.0, NULL, 'Pending'),
(220, 220, 'Cash on Delivery', 802.0, '2024-08-25', 'Refunded');


INSERT INTO Shipments (shipment_id, order_id, shipping_address, shipment_date, delivery_date, delivery_status) VALUES
(1, 1, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2024-04-27', '2024-05-02', 'Delivered'),
(2, 2, 'Rabigh, Makkah Region, Saudi Arabia', '2025-07-15', NULL, 'Shipped'),
(3, 3, 'Rabigh, Makkah Region, Saudi Arabia', '2024-08-10', '2024-08-14', 'Returned'),
(4, 4, 'Al Lith, Makkah Region, Saudi Arabia', '2024-05-10', NULL, 'Processing'),
(5, 5, 'Rabigh, Makkah Region, Saudi Arabia', '2024-08-23', NULL, 'Shipped'),
(6, 6, 'Rabigh, Makkah Region, Saudi Arabia', '2025-12-02', '2025-12-09', 'Returned'),
(7, 7, 'Jeddah, Makkah Region, Saudi Arabia', '2024-10-03', NULL, 'Processing'),
(8, 8, 'Rabigh, Makkah Region, Saudi Arabia', '2025-08-21', NULL, 'Shipped'),
(9, 9, 'Taif, Makkah Region, Saudi Arabia', '2024-03-09', NULL, 'Shipped'),
(10, 10, 'Rabigh, Makkah Region, Saudi Arabia', '2024-10-30', NULL, 'Processing'),
(11, 11, 'Rabigh, Makkah Region, Saudi Arabia', '2024-11-04', '2024-11-08', 'Returned'),
(12, 12, 'Al Lith, Makkah Region, Saudi Arabia', '2024-01-23', '2024-01-28', 'Delivered'),
(13, 13, 'Taif, Makkah Region, Saudi Arabia', '2025-06-27', '2025-07-02', 'Returned'),
(14, 14, 'Jeddah, Makkah Region, Saudi Arabia', '2024-09-13', '2024-09-16', 'Delivered'),
(15, 15, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2024-02-05', '2024-02-10', 'Delivered'),
(16, 16, 'Rabigh, Makkah Region, Saudi Arabia', '2025-08-09', '2025-08-14', 'Returned'),
(17, 17, 'Rabigh, Makkah Region, Saudi Arabia', '2024-02-26', '2024-02-29', 'Delivered'),
(18, 18, 'Taif, Makkah Region, Saudi Arabia', '2024-10-15', NULL, 'Processing'),
(19, 19, 'Jeddah, Makkah Region, Saudi Arabia', '2024-09-01', NULL, 'Shipped'),
(20, 20, 'Al Lith, Makkah Region, Saudi Arabia', '2025-05-16', '2025-05-20', 'Delivered'),
(21, 21, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2025-09-04', NULL, 'Processing'),
(22, 22, 'Al Lith, Makkah Region, Saudi Arabia', '2024-09-26', '2024-09-30', 'Delivered'),
(23, 23, 'Jeddah, Makkah Region, Saudi Arabia', '2025-01-16', NULL, 'Shipped'),
(24, 24, 'Rabigh, Makkah Region, Saudi Arabia', '2024-04-20', '2024-04-27', 'Returned'),
(25, 25, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2024-09-30', '2024-10-04', 'Returned'),
(26, 26, 'Rabigh, Makkah Region, Saudi Arabia', '2025-03-31', '2025-04-06', 'Returned'),
(27, 27, 'Taif, Makkah Region, Saudi Arabia', '2025-03-18', '2025-03-21', 'Delivered'),
(28, 28, 'Rabigh, Makkah Region, Saudi Arabia', '2025-07-28', NULL, 'Shipped'),
(29, 29, 'Taif, Makkah Region, Saudi Arabia', '2024-09-12', NULL, 'Shipped'),
(30, 30, 'Taif, Makkah Region, Saudi Arabia', '2024-10-13', '2024-10-17', 'Delivered'),
(31, 31, 'Rabigh, Makkah Region, Saudi Arabia', '2024-11-19', NULL, 'Processing'),
(32, 32, 'Jeddah, Makkah Region, Saudi Arabia', '2025-07-08', '2025-07-12', 'Returned'),
(33, 33, 'Rabigh, Makkah Region, Saudi Arabia', '2025-03-08', NULL, 'Shipped'),
(34, 34, 'Jeddah, Makkah Region, Saudi Arabia', '2025-09-16', '2025-09-23', 'Returned'),
(35, 35, 'Taif, Makkah Region, Saudi Arabia', '2025-03-03', '2025-03-10', 'Returned'),
(36, 36, 'Jeddah, Makkah Region, Saudi Arabia', '2024-04-20', NULL, 'Shipped'),
(37, 37, 'Taif, Makkah Region, Saudi Arabia', '2025-06-30', '2025-07-05', 'Returned'),
(38, 38, 'Jeddah, Makkah Region, Saudi Arabia', '2024-09-23', NULL, 'Shipped'),
(39, 39, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2025-03-03', NULL, 'Shipped'),
(40, 40, 'Taif, Makkah Region, Saudi Arabia', '2024-01-09', NULL, 'Shipped'),
(41, 41, 'Rabigh, Makkah Region, Saudi Arabia', '2024-05-11', '2024-05-18', 'Returned'),
(42, 42, 'Rabigh, Makkah Region, Saudi Arabia', '2024-05-20', NULL, 'Shipped'),
(43, 43, 'Al Lith, Makkah Region, Saudi Arabia', '2025-03-09', '2025-03-12', 'Delivered'),
(44, 44, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2024-02-12', '2024-02-17', 'Delivered'),
(45, 45, 'Jeddah, Makkah Region, Saudi Arabia', '2025-09-15', '2025-09-17', 'Returned'),
(46, 46, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2025-08-15', NULL, 'Shipped'),
(47, 47, 'Rabigh, Makkah Region, Saudi Arabia', '2025-01-17', NULL, 'Processing'),
(48, 48, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2025-05-13', NULL, 'Shipped'),
(49, 49, 'Rabigh, Makkah Region, Saudi Arabia', '2025-05-23', NULL, 'Shipped'),
(50, 50, 'Rabigh, Makkah Region, Saudi Arabia', '2024-03-29', '2024-04-02', 'Delivered'),
(51, 51, 'Rabigh, Makkah Region, Saudi Arabia', '2025-07-19', '2025-07-21', 'Returned'),
(52, 52, 'Rabigh, Makkah Region, Saudi Arabia', '2025-08-27', '2025-09-03', 'Returned'),
(53, 53, 'Al Lith, Makkah Region, Saudi Arabia', '2024-05-12', NULL, 'Processing'),
(54, 54, 'Taif, Makkah Region, Saudi Arabia', '2025-05-07', NULL, 'Processing'),
(55, 55, 'Rabigh, Makkah Region, Saudi Arabia', '2024-06-04', '2024-06-09', 'Returned'),
(56, 56, 'Jeddah, Makkah Region, Saudi Arabia', '2025-03-31', '2025-04-07', 'Delivered'),
(57, 57, 'Taif, Makkah Region, Saudi Arabia', '2024-03-15', '2024-03-18', 'Delivered'),
(58, 58, 'Jeddah, Makkah Region, Saudi Arabia', '2025-12-19', NULL, 'Shipped'),
(59, 59, 'Rabigh, Makkah Region, Saudi Arabia', '2024-04-04', '2024-04-09', 'Returned'),
(60, 60, 'Al Lith, Makkah Region, Saudi Arabia', '2024-07-05', '2024-07-09', 'Returned'),
(61, 61, 'Al Lith, Makkah Region, Saudi Arabia', '2025-12-13', NULL, 'Processing'),
(62, 62, 'Rabigh, Makkah Region, Saudi Arabia', '2025-07-10', NULL, 'Processing'),
(63, 63, 'Rabigh, Makkah Region, Saudi Arabia', '2025-03-27', NULL, 'Processing'),
(64, 64, 'Rabigh, Makkah Region, Saudi Arabia', '2025-02-23', NULL, 'Shipped'),
(65, 65, 'Jeddah, Makkah Region, Saudi Arabia', '2025-04-13', '2025-04-17', 'Returned'),
(66, 66, 'Al Lith, Makkah Region, Saudi Arabia', '2025-03-01', '2025-03-06', 'Returned'),
(67, 67, 'Rabigh, Makkah Region, Saudi Arabia', '2024-07-15', '2024-07-22', 'Delivered'),
(68, 68, 'Rabigh, Makkah Region, Saudi Arabia', '2024-04-15', '2024-04-17', 'Returned'),
(69, 69, 'Taif, Makkah Region, Saudi Arabia', '2025-11-22', '2025-11-29', 'Returned'),
(70, 70, 'Taif, Makkah Region, Saudi Arabia', '2025-03-21', NULL, 'Shipped'),
(71, 71, 'Jeddah, Makkah Region, Saudi Arabia', '2025-01-03', NULL, 'Processing'),
(72, 72, 'Rabigh, Makkah Region, Saudi Arabia', '2025-11-27', '2025-12-02', 'Returned'),
(73, 73, 'Taif, Makkah Region, Saudi Arabia', '2024-09-16', NULL, 'Processing'),
(74, 74, 'Rabigh, Makkah Region, Saudi Arabia', '2025-02-12', NULL, 'Processing'),
(75, 75, 'Rabigh, Makkah Region, Saudi Arabia', '2024-08-26', '2024-08-28', 'Returned'),
(76, 76, 'Rabigh, Makkah Region, Saudi Arabia', '2025-10-25', NULL, 'Processing'),
(77, 77, 'Jeddah, Makkah Region, Saudi Arabia', '2024-09-23', NULL, 'Shipped'),
(78, 78, 'Al Lith, Makkah Region, Saudi Arabia', '2024-09-30', '2024-10-05', 'Returned'),
(79, 79, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2025-01-18', '2025-01-21', 'Delivered'),
(80, 80, 'Rabigh, Makkah Region, Saudi Arabia', '2024-11-07', NULL, 'Processing'),
(81, 81, 'Rabigh, Makkah Region, Saudi Arabia', '2025-07-07', NULL, 'Processing'),
(82, 82, 'Rabigh, Makkah Region, Saudi Arabia', '2025-01-08', '2025-01-10', 'Delivered'),
(83, 83, 'Al Lith, Makkah Region, Saudi Arabia', '2025-08-02', '2025-08-06', 'Delivered'),
(84, 84, 'Taif, Makkah Region, Saudi Arabia', '2024-01-06', '2024-01-08', 'Delivered'),
(85, 85, 'Jeddah, Makkah Region, Saudi Arabia', '2024-06-30', '2024-07-02', 'Delivered'),
(86, 86, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2025-01-08', '2025-01-10', 'Returned'),
(87, 87, 'Rabigh, Makkah Region, Saudi Arabia', '2025-11-07', '2025-11-14', 'Returned'),
(88, 88, 'Rabigh, Makkah Region, Saudi Arabia', '2024-03-18', '2024-03-24', 'Returned'),
(89, 89, 'Rabigh, Makkah Region, Saudi Arabia', '2025-02-28', NULL, 'Processing'),
(90, 90, 'Al Lith, Makkah Region, Saudi Arabia', '2025-07-25', NULL, 'Shipped'),
(91, 91, 'Jeddah, Makkah Region, Saudi Arabia', '2024-12-27', '2025-01-03', 'Returned'),
(92, 92, 'Taif, Makkah Region, Saudi Arabia', '2024-10-01', '2024-10-04', 'Returned'),
(93, 93, 'Taif, Makkah Region, Saudi Arabia', '2025-06-28', '2025-07-01', 'Delivered'),
(94, 94, 'Rabigh, Makkah Region, Saudi Arabia', '2025-03-02', '2025-03-09', 'Returned'),
(95, 95, 'Jeddah, Makkah Region, Saudi Arabia', '2024-08-14', NULL, 'Shipped'),
(96, 96, 'Rabigh, Makkah Region, Saudi Arabia', '2024-05-03', '2024-05-08', 'Delivered'),
(97, 97, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2025-10-20', NULL, 'Shipped'),
(98, 98, 'Jeddah, Makkah Region, Saudi Arabia', '2024-09-07', NULL, 'Processing'),
(99, 99, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2024-12-24', '2024-12-30', 'Delivered'),
(100, 100, 'Taif, Makkah Region, Saudi Arabia', '2025-10-06', NULL, 'Shipped'),
(101, 101, 'Al Lith, Makkah Region, Saudi Arabia', '2025-08-30', '2025-09-03', 'Delivered'),
(102, 102, 'Rabigh, Makkah Region, Saudi Arabia', '2025-08-19', '2025-08-25', 'Returned'),
(103, 103, 'Taif, Makkah Region, Saudi Arabia', '2025-05-31', '2025-06-02', 'Returned'),
(104, 104, 'Jeddah, Makkah Region, Saudi Arabia', '2024-09-13', NULL, 'Shipped'),
(105, 105, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2024-12-05', NULL, 'Processing'),
(106, 106, 'Al Lith, Makkah Region, Saudi Arabia', '2025-12-03', '2025-12-07', 'Returned'),
(107, 107, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2024-07-04', '2024-07-10', 'Returned'),
(108, 108, 'Taif, Makkah Region, Saudi Arabia', '2025-01-21', NULL, 'Shipped'),
(109, 109, 'Jeddah, Makkah Region, Saudi Arabia', '2025-04-06', NULL, 'Processing'),
(110, 110, 'Rabigh, Makkah Region, Saudi Arabia', '2024-07-26', '2024-07-28', 'Returned'),
(111, 111, 'Al Lith, Makkah Region, Saudi Arabia', '2025-06-13', NULL, 'Processing'),
(112, 112, 'Taif, Makkah Region, Saudi Arabia', '2025-05-31', NULL, 'Shipped'),
(113, 113, 'Rabigh, Makkah Region, Saudi Arabia', '2024-05-23', NULL, 'Shipped'),
(114, 114, 'Jeddah, Makkah Region, Saudi Arabia', '2024-02-21', NULL, 'Shipped'),
(115, 115, 'Taif, Makkah Region, Saudi Arabia', '2024-03-13', '2024-03-18', 'Returned'),
(116, 116, 'Rabigh, Makkah Region, Saudi Arabia', '2024-09-19', NULL, 'Shipped'),
(117, 117, 'Rabigh, Makkah Region, Saudi Arabia', '2025-05-06', '2025-05-09', 'Delivered'),
(118, 118, 'Al Lith, Makkah Region, Saudi Arabia', '2025-04-30', NULL, 'Shipped'),
(119, 119, 'Jeddah, Makkah Region, Saudi Arabia', '2025-03-27', NULL, 'Processing'),
(120, 120, 'Al Lith, Makkah Region, Saudi Arabia', '2024-10-29', '2024-11-03', 'Returned'),
(121, 121, 'Jeddah, Makkah Region, Saudi Arabia', '2025-12-08', NULL, 'Shipped'),
(122, 122, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2025-11-27', '2025-11-30', 'Delivered'),
(123, 123, 'Rabigh, Makkah Region, Saudi Arabia', '2025-08-06', '2025-08-09', 'Returned'),
(124, 124, 'Rabigh, Makkah Region, Saudi Arabia', '2024-07-10', NULL, 'Processing'),
(125, 125, 'Jeddah, Makkah Region, Saudi Arabia', '2024-06-28', NULL, 'Shipped'),
(126, 126, 'Jeddah, Makkah Region, Saudi Arabia', '2024-06-11', '2024-06-15', 'Returned'),
(127, 127, 'Al Lith, Makkah Region, Saudi Arabia', '2025-09-21', NULL, 'Processing'),
(128, 128, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2024-05-09', '2024-05-15', 'Returned'),
(129, 129, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2024-02-28', NULL, 'Shipped'),
(130, 130, 'Al Lith, Makkah Region, Saudi Arabia', '2025-10-05', '2025-10-11', 'Delivered'),
(131, 131, 'Taif, Makkah Region, Saudi Arabia', '2024-02-15', '2024-02-18', 'Returned'),
(132, 132, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2024-02-02', NULL, 'Processing'),
(133, 133, 'Rabigh, Makkah Region, Saudi Arabia', '2025-03-03', NULL, 'Processing'),
(134, 134, 'Al Lith, Makkah Region, Saudi Arabia', '2024-09-05', NULL, 'Shipped'),
(135, 135, 'Rabigh, Makkah Region, Saudi Arabia', '2025-09-23', NULL, 'Shipped'),
(136, 136, 'Rabigh, Makkah Region, Saudi Arabia', '2024-11-12', NULL, 'Shipped'),
(137, 137, 'Rabigh, Makkah Region, Saudi Arabia', '2024-02-24', NULL, 'Processing'),
(138, 138, 'Rabigh, Makkah Region, Saudi Arabia', '2025-06-03', NULL, 'Processing'),
(139, 139, 'Rabigh, Makkah Region, Saudi Arabia', '2025-06-08', NULL, 'Shipped'),
(140, 140, 'Rabigh, Makkah Region, Saudi Arabia', '2025-09-15', '2025-09-22', 'Returned'),
(141, 141, 'Jeddah, Makkah Region, Saudi Arabia', '2025-09-02', '2025-09-06', 'Delivered'),
(142, 142, 'Jeddah, Makkah Region, Saudi Arabia', '2025-06-22', '2025-06-27', 'Returned'),
(143, 143, 'Rabigh, Makkah Region, Saudi Arabia', '2025-03-01', '2025-03-06', 'Returned'),
(144, 144, 'Al Lith, Makkah Region, Saudi Arabia', '2024-12-31', NULL, 'Processing'),
(145, 145, 'Rabigh, Makkah Region, Saudi Arabia', '2024-05-31', NULL, 'Shipped'),
(146, 146, 'Taif, Makkah Region, Saudi Arabia', '2024-07-26', '2024-07-28', 'Returned'),
(147, 147, 'Taif, Makkah Region, Saudi Arabia', '2025-06-28', '2025-07-05', 'Delivered'),
(148, 148, 'Taif, Makkah Region, Saudi Arabia', '2025-05-06', '2025-05-13', 'Delivered'),
(149, 149, 'Taif, Makkah Region, Saudi Arabia', '2025-02-12', NULL, 'Shipped'),
(150, 150, 'Taif, Makkah Region, Saudi Arabia', '2025-06-03', NULL, 'Shipped'),
(151, 151, 'Jeddah, Makkah Region, Saudi Arabia', '2025-08-05', '2025-08-10', 'Delivered'),
(152, 152, 'Jeddah, Makkah Region, Saudi Arabia', '2024-09-26', NULL, 'Processing'),
(153, 153, 'Taif, Makkah Region, Saudi Arabia', '2025-11-16', '2025-11-22', 'Delivered'),
(154, 154, 'Rabigh, Makkah Region, Saudi Arabia', '2025-07-19', NULL, 'Processing'),
(155, 155, 'Taif, Makkah Region, Saudi Arabia', '2024-04-27', '2024-05-02', 'Delivered'),
(156, 156, 'Al Lith, Makkah Region, Saudi Arabia', '2024-04-06', '2024-04-10', 'Returned'),
(157, 157, 'Rabigh, Makkah Region, Saudi Arabia', '2024-01-26', NULL, 'Processing'),
(158, 158, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2025-04-30', NULL, 'Processing'),
(159, 159, 'Jeddah, Makkah Region, Saudi Arabia', '2025-11-11', '2025-11-14', 'Returned'),
(160, 160, 'Rabigh, Makkah Region, Saudi Arabia', '2024-08-19', '2024-08-24', 'Delivered'),
(161, 161, 'Rabigh, Makkah Region, Saudi Arabia', '2024-04-28', '2024-05-05', 'Delivered'),
(162, 162, 'Rabigh, Makkah Region, Saudi Arabia', '2025-08-14', '2025-08-18', 'Delivered'),
(163, 163, 'Taif, Makkah Region, Saudi Arabia', '2025-10-05', NULL, 'Shipped'),
(164, 164, 'Rabigh, Makkah Region, Saudi Arabia', '2024-08-21', '2024-08-27', 'Delivered'),
(165, 165, 'Jeddah, Makkah Region, Saudi Arabia', '2025-01-15', '2025-01-18', 'Returned'),
(166, 166, 'Taif, Makkah Region, Saudi Arabia', '2024-08-02', '2024-08-09', 'Returned'),
(167, 167, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2025-04-25', '2025-04-30', 'Returned'),
(168, 168, 'Taif, Makkah Region, Saudi Arabia', '2024-11-24', '2024-11-28', 'Returned'),
(169, 169, 'Rabigh, Makkah Region, Saudi Arabia', '2024-07-21', NULL, 'Processing'),
(170, 170, 'Rabigh, Makkah Region, Saudi Arabia', '2024-06-24', '2024-06-27', 'Delivered'),
(171, 171, 'Taif, Makkah Region, Saudi Arabia', '2025-09-26', NULL, 'Shipped'),
(172, 172, 'Taif, Makkah Region, Saudi Arabia', '2024-04-21', NULL, 'Processing'),
(173, 173, 'Rabigh, Makkah Region, Saudi Arabia', '2024-08-21', '2024-08-26', 'Returned'),
(174, 174, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2024-01-13', '2024-01-15', 'Returned'),
(175, 175, 'Rabigh, Makkah Region, Saudi Arabia', '2024-08-05', '2024-08-08', 'Returned'),
(176, 176, 'Jeddah, Makkah Region, Saudi Arabia', '2024-05-30', NULL, 'Shipped'),
(177, 177, 'Rabigh, Makkah Region, Saudi Arabia', '2024-05-25', NULL, 'Shipped'),
(178, 178, 'Taif, Makkah Region, Saudi Arabia', '2024-07-11', '2024-07-18', 'Returned'),
(179, 179, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2024-06-08', NULL, 'Processing'),
(180, 180, 'Taif, Makkah Region, Saudi Arabia', '2025-03-19', NULL, 'Shipped'),
(181, 181, 'Rabigh, Makkah Region, Saudi Arabia', '2024-03-28', '2024-03-31', 'Returned'),
(182, 182, 'Al Lith, Makkah Region, Saudi Arabia', '2024-11-06', '2024-11-10', 'Delivered'),
(183, 183, 'Taif, Makkah Region, Saudi Arabia', '2024-11-09', '2024-11-13', 'Returned'),
(184, 184, 'Taif, Makkah Region, Saudi Arabia', '2024-09-08', '2024-09-14', 'Delivered'),
(185, 185, 'Jeddah, Makkah Region, Saudi Arabia', '2025-12-12', NULL, 'Processing'),
(186, 186, 'Taif, Makkah Region, Saudi Arabia', '2025-03-05', '2025-03-08', 'Returned'),
(187, 187, 'Rabigh, Makkah Region, Saudi Arabia', '2025-11-13', '2025-11-18', 'Delivered'),
(188, 188, 'Taif, Makkah Region, Saudi Arabia', '2025-04-21', '2025-04-23', 'Returned'),
(189, 189, 'Rabigh, Makkah Region, Saudi Arabia', '2024-05-26', NULL, 'Processing'),
(190, 190, 'Jeddah, Makkah Region, Saudi Arabia', '2024-09-08', '2024-09-11', 'Returned'),
(191, 191, 'Jeddah, Makkah Region, Saudi Arabia', '2025-10-08', NULL, 'Processing'),
(192, 192, 'Taif, Makkah Region, Saudi Arabia', '2024-10-14', NULL, 'Processing'),
(193, 193, 'Jeddah, Makkah Region, Saudi Arabia', '2025-10-19', NULL, 'Shipped'),
(194, 194, 'Taif, Makkah Region, Saudi Arabia', '2025-01-20', NULL, 'Processing'),
(195, 195, 'Al Lith, Makkah Region, Saudi Arabia', '2024-05-21', '2024-05-24', 'Delivered'),
(196, 196, 'Jeddah, Makkah Region, Saudi Arabia', '2025-04-16', '2025-04-21', 'Returned'),
(197, 197, 'Al Lith, Makkah Region, Saudi Arabia', '2024-08-13', NULL, 'Processing'),
(198, 198, 'Rabigh, Makkah Region, Saudi Arabia', '2024-05-01', '2024-05-07', 'Delivered'),
(199, 199, 'Taif, Makkah Region, Saudi Arabia', '2025-08-09', '2025-08-13', 'Returned'),
(200, 200, 'Taif, Makkah Region, Saudi Arabia', '2024-10-13', NULL, 'Processing'),
(201, 201, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2025-10-13', NULL, 'Shipped'),
(202, 202, 'Taif, Makkah Region, Saudi Arabia', '2025-05-23', '2025-05-30', 'Delivered'),
(203, 203, 'Jeddah, Makkah Region, Saudi Arabia', '2025-03-16', NULL, 'Shipped'),
(204, 204, 'Rabigh, Makkah Region, Saudi Arabia', '2025-02-10', '2025-02-15', 'Delivered'),
(205, 205, 'Rabigh, Makkah Region, Saudi Arabia', '2025-12-13', NULL, 'Processing'),
(206, 206, 'Rabigh, Makkah Region, Saudi Arabia', '2024-12-26', '2024-12-28', 'Delivered'),
(207, 207, 'Rabigh, Makkah Region, Saudi Arabia', '2024-12-28', NULL, 'Processing'),
(208, 208, 'Jeddah, Makkah Region, Saudi Arabia', '2025-09-15', '2025-09-20', 'Returned'),
(209, 209, 'Rabigh, Makkah Region, Saudi Arabia', '2024-09-05', NULL, 'Shipped'),
(210, 210, 'Taif, Makkah Region, Saudi Arabia', '2025-07-16', '2025-07-20', 'Returned'),
(211, 211, 'Al Lith, Makkah Region, Saudi Arabia', '2025-09-24', '2025-09-30', 'Delivered'),
(212, 212, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2025-11-16', '2025-11-18', 'Delivered'),
(213, 213, 'Rabigh, Makkah Region, Saudi Arabia', '2025-06-20', '2025-06-24', 'Returned'),
(214, 214, 'Rabigh, Makkah Region, Saudi Arabia', '2024-10-07', '2024-10-12', 'Returned'),
(215, 215, 'Al Qunfudhah, Makkah Region, Saudi Arabia', '2025-01-04', '2025-01-11', 'Returned'),
(216, 216, 'Rabigh, Makkah Region, Saudi Arabia', '2025-11-04', NULL, 'Shipped'),
(217, 217, 'Jeddah, Makkah Region, Saudi Arabia', '2025-05-31', NULL, 'Shipped'),
(218, 218, 'Jeddah, Makkah Region, Saudi Arabia', '2025-08-03', '2025-08-09', 'Delivered'),
(219, 219, 'Taif, Makkah Region, Saudi Arabia', '2024-01-03', NULL, 'Processing'),
(220, 220, 'Jeddah, Makkah Region, Saudi Arabia', '2024-08-26', '2024-09-01', 'Returned');
-- -- Describe the structure of the Shipments table (columns, data types, and keys)
DESCRIBE Shipments;

-- Customer reviews
INSERT INTO Product_Reviews (review_id, customer_id, product_id, rating, review_comment, review_date) VALUES
(1, 82, 16, 4, 'Good quality and fast delivery', '2024-04-29'),
(2, 20, 6, 2, 'Below expectations', '2024-08-27'),
(3, 85, 15, 4, 'Good quality and fast delivery', '2024-09-03'),
(4, 90, 35, 4, 'Good quality and fast delivery', '2025-12-06'),
(5, 90, 16, 2, 'Below expectations', '2025-12-15'),
(6, 52, 37, 3, 'Average product, acceptable', '2024-10-14'),
(7, 63, 4, 5, 'Excellent product, highly recommended', '2024-01-30'),
(8, 16, 22, 5, 'Excellent product, highly recommended', '2024-09-22'),
(9, 60, 26, 4, 'Good quality and fast delivery', '2024-03-14'),
(10, 92, 19, 4, 'Good quality and fast delivery', '2025-05-23'),
(11, 92, 14, 4, 'Good quality and fast delivery', '2025-05-23'),
(12, 41, 16, 5, 'Excellent product, highly recommended', '2024-10-02'),
(13, 41, 17, 4, 'Good quality and fast delivery', '2024-10-07'),
(14, 41, 26, 4, 'Good quality and fast delivery', '2024-10-01'),
(15, 32, 35, 5, 'Excellent product, highly recommended', '2025-01-26'),
(16, 86, 7, 5, 'Excellent product, highly recommended', '2024-09-23'),
(17, 86, 25, 5, 'Excellent product, highly recommended', '2024-09-28'),
(18, 43, 26, 5, 'Excellent product, highly recommended', '2024-10-28'),
(19, 67, 28, 4, 'Good quality and fast delivery', '2025-07-22'),
(20, 75, 29, 5, 'Excellent product, highly recommended', '2025-09-25'),
(21, 75, 33, 3, 'Average product, acceptable', '2025-09-18'),
(22, 75, 31, 5, 'Excellent product, highly recommended', '2025-09-20'),
(23, 58, 34, 4, 'Good quality and fast delivery', '2024-10-01'),
(24, 58, 32, 4, 'Good quality and fast delivery', '2024-10-01'),
(25, 62, 27, 4, 'Good quality and fast delivery', '2024-01-24'),
(26, 84, 2, 5, 'Excellent product, highly recommended', '2024-02-27'),
(27, 85, 1, 4, 'Good quality and fast delivery', '2025-01-27'),
(28, 25, 36, 5, 'Excellent product, highly recommended', '2024-04-13'),
(29, 55, 20, 5, 'Excellent product, highly recommended', '2025-07-30'),
(30, 69, 4, 1, 'Poor experience', '2024-05-23'),
(31, 58, 20, 3, 'Average product, acceptable', '2025-04-05'),
(32, 58, 37, 4, 'Good quality and fast delivery', '2025-04-18'),
(33, 58, 40, 4, 'Good quality and fast delivery', '2025-04-12'),
(34, 59, 38, 5, 'Excellent product, highly recommended', '2024-03-27'),
(35, 71, 30, 5, 'Excellent product, highly recommended', '2025-03-13'),
(36, 99, 19, 5, 'Excellent product, highly recommended', '2025-03-17'),
(37, 42, 27, 4, 'Good quality and fast delivery', '2024-07-27'),
(38, 38, 16, 5, 'Excellent product, highly recommended', '2025-01-11'),
(39, 38, 34, 5, 'Excellent product, highly recommended', '2025-01-21'),
(40, 38, 27, 1, 'Poor experience', '2025-01-21'),
(41, 81, 29, 3, 'Average product, acceptable', '2025-11-08'),
(42, 31, 35, 5, 'Excellent product, highly recommended', '2025-07-15'),
(43, 31, 4, 5, 'Excellent product, highly recommended', '2025-01-18'),
(44, 77, 9, 5, 'Excellent product, highly recommended', '2024-01-15'),
(45, 57, 39, 4, 'Good quality and fast delivery', '2024-04-03'),
(46, 57, 10, 5, 'Excellent product, highly recommended', '2024-03-27'),
(47, 30, 26, 5, 'Excellent product, highly recommended', '2025-03-06'),
(48, 17, 23, 5, 'Excellent product, highly recommended', '2025-08-04'),
(49, 89, 20, 5, 'Excellent product, highly recommended', '2024-10-05'),
(50, 12, 30, 3, 'Average product, acceptable', '2025-07-16'),
(51, 42, 9, 4, 'Good quality and fast delivery', '2024-05-20'),
(52, 36, 20, 5, 'Excellent product, highly recommended', '2025-09-14'),
(53, 9, 19, 5, 'Excellent product, highly recommended', '2024-12-10'),
(54, 9, 17, 4, 'Good quality and fast delivery', '2024-12-18'),
(55, 40, 15, 4, 'Good quality and fast delivery', '2024-07-12'),
(56, 77, 40, 4, 'Good quality and fast delivery', '2025-02-03'),
(57, 51, 6, 4, 'Good quality and fast delivery', '2025-06-18'),
(58, 16, 5, 4, 'Good quality and fast delivery', '2024-02-25'),
(59, 48, 5, 4, 'Good quality and fast delivery', '2024-10-01'),
(60, 48, 16, 5, 'Excellent product, highly recommended', '2024-10-05'),
(61, 90, 5, 4, 'Good quality and fast delivery', '2025-05-22'),
(62, 70, 13, 5, 'Excellent product, highly recommended', '2025-05-17'),
(63, 66, 10, 5, 'Excellent product, highly recommended', '2025-12-12'),
(64, 50, 24, 4, 'Good quality and fast delivery', '2025-08-11'),
(65, 10, 29, 5, 'Excellent product, highly recommended', '2024-05-26'),
(66, 65, 11, 5, 'Excellent product, highly recommended', '2024-03-10'),
(67, 17, 33, 5, 'Excellent product, highly recommended', '2025-10-17'),
(68, 7, 35, 5, 'Excellent product, highly recommended', '2024-02-28'),
(69, 39, 20, 5, 'Excellent product, highly recommended', '2025-09-11'),
(70, 70, 13, 4, 'Good quality and fast delivery', '2025-01-10'),
(71, 70, 16, 5, 'Excellent product, highly recommended', '2025-01-14'),
(72, 86, 4, 5, 'Excellent product, highly recommended', '2025-07-07'),
(73, 61, 19, 5, 'Excellent product, highly recommended', '2025-05-13'),
(74, 38, 40, 3, 'Average product, acceptable', '2025-08-19'),
(75, 8, 20, 3, 'Average product, acceptable', '2025-11-23'),
(76, 94, 20, 4, 'Good quality and fast delivery', '2024-08-29'),
(77, 25, 40, 2, 'Below expectations', '2024-05-14'),
(78, 25, 2, 4, 'Good quality and fast delivery', '2024-05-01'),
(79, 25, 16, 5, 'Excellent product, highly recommended', '2024-05-07'),
(80, 31, 4, 4, 'Good quality and fast delivery', '2024-08-25'),
(81, 62, 13, 4, 'Good quality and fast delivery', '2024-08-15'),
(82, 46, 12, 3, 'Average product, acceptable', '2024-07-03'),
(83, 23, 16, 5, 'Excellent product, highly recommended', '2024-05-08'),
(84, 50, 28, 5, 'Excellent product, highly recommended', '2024-06-09'),
(85, 18, 40, 4, 'Good quality and fast delivery', '2024-11-24'),
(86, 18, 29, 5, 'Excellent product, highly recommended', '2024-11-27'),
(87, 85, 40, 4, 'Good quality and fast delivery', '2025-11-23'),
(88, 15, 22, 4, 'Good quality and fast delivery', '2024-06-02'),
(89, 15, 30, 4, 'Good quality and fast delivery', '2024-06-02'),
(90, 27, 35, 5, 'Excellent product, highly recommended', '2024-11-01'),
(91, 68, 8, 4, 'Good quality and fast delivery', '2025-10-24'),
(92, 24, 27, 3, 'Average product, acceptable', '2025-02-05'),
(93, 63, 32, 2, 'Below expectations', '2024-05-31'),
(94, 8, 11, 5, 'Excellent product, highly recommended', '2025-08-24'),
(95, 8, 16, 5, 'Excellent product, highly recommended', '2024-10-28'),
(96, 28, 19, 5, 'Excellent product, highly recommended', '2025-06-09'),
(97, 28, 22, 5, 'Excellent product, highly recommended', '2025-05-31'),
(98, 7, 28, 4, 'Good quality and fast delivery', '2025-02-28'),
(99, 7, 6, 5, 'Excellent product, highly recommended', '2025-02-17'),
(100, 55, 25, 5, 'Excellent product, highly recommended', '2025-12-20'),
(101, 55, 6, 5, 'Excellent product, highly recommended', '2025-12-21'),
(102, 69, 6, 4, 'Good quality and fast delivery', '2025-10-04'),
(103, 69, 20, 3, 'Average product, acceptable', '2025-10-10'),
(104, 69, 33, 5, 'Excellent product, highly recommended', '2025-09-28'),
(105, 66, 37, 5, 'Excellent product, highly recommended', '2025-01-08'),
(106, 66, 11, 4, 'Good quality and fast delivery', '2025-01-20'),
(107, 66, 17, 5, 'Excellent product, highly recommended', '2025-01-09'),
(108, 16, 15, 5, 'Excellent product, highly recommended', '2025-06-03'),
(109, 38, 30, 5, 'Excellent product, highly recommended', '2025-08-05'),
(110, 38, 24, 4, 'Good quality and fast delivery', '2025-08-05');