complete_assignment.sql

use altschool_query;
-- Drop existing tables if they exist (in correct order to handle foreign keys)

DROP TABLE IF EXISTS order_items;
DROP TABLE IF EXISTS orders;
DROP TABLE IF EXISTS employees;
DROP TABLE IF EXISTS departments;
DROP TABLE IF EXISTS products;
DROP TABLE IF EXISTS customers;

-- =====================================================
-- TABLE CREATION STATEMENTS
-- =====================================================

-- Create customers table
CREATE TABLE customers (
    customer_id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) UNIQUE NOT NULL,
    phone VARCHAR(20),
    address JSON,
    preferences JSON,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Create products table
CREATE TABLE products (
    product_id INT AUTO_INCREMENT PRIMARY KEY,
    product_name VARCHAR(200) NOT NULL,
    price DECIMAL(10,2) NOT NULL,
    category VARCHAR(50),
    stock_quantity INT DEFAULT 0,
    attributes JSON,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Create departments table
CREATE TABLE departments (
    department_id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    location VARCHAR(100),
    metadata JSON,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Create employees table
CREATE TABLE employees (
    employee_id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    department_id INT,
    manager_id INT NULL,
    role VARCHAR(100),
    hire_date DATE,
    salary DECIMAL(10,2),
    contact_info JSON,
    skills JSON
);

-- Create orders table
CREATE TABLE orders (
    order_id INT AUTO_INCREMENT PRIMARY KEY,
    customer_id INT,
    order_date DATE NOT NULL,
    total_amount DECIMAL(12,2) NOT NULL,
    status ENUM('Pending', 'Processing', 'Shipped', 'Delivered', 'Cancelled') DEFAULT 'Pending',
    shipping_address JSON,
    metadata JSON,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (customer_id) REFERENCES customers(customer_id)
);

-- Create order_items table
CREATE TABLE order_items (
    item_id INT AUTO_INCREMENT PRIMARY KEY,
    order_id INT,
    product_id INT,
    quantity INT NOT NULL,
    price DECIMAL(10,2) NOT NULL,
    discount DECIMAL(10,2) DEFAULT 0.00,
    item_attributes JSON,
    FOREIGN KEY (order_id) REFERENCES orders(order_id),
    FOREIGN KEY (product_id) REFERENCES products(product_id)
);

INSERT INTO customers (name, email, phone, address, preferences)
VALUES
('Amara Olu', 'amara.olu190@example.com', '+2348021178815', '{"street": "195 Emeka Anyaoku", "city": "Kano", "zip": "700001"}', '{"marketing_opt_in": true, "categories": ["Food"]}'),
('Temitope Nwosu', 'temitope.nwosu452@example.com', '+2348083869645', '{"street": "59 Adetokunbo Ademola", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": false, "categories": ["Toys", "Books"]}'),
('Temitope Ogunleye', 'temitope.ogunleye385@example.com', '+2348080272461', '{"street": "124 Marina Road", "city": "Abuja", "zip": "900001"}', '{"marketing_opt_in": false, "categories": ["Fashion"]}'),
('Olu Mohammed', 'olu.mohammed841@example.com', '+2348012190965', '{"street": "94 Nnamdi Azikiwe", "city": "Port Harcourt", "zip": "500001"}', '{"marketing_opt_in": true, "categories": ["Food", "Toys", "Books"]}'),
('Fatima Okonkwo', 'fatima.okonkwo325@example.com', '+2348010921363', '{"street": "121 Anthony Enahoro", "city": "Abuja", "zip": "900001"}', '{"marketing_opt_in": true, "categories": ["Fashion"]}'),
('Obinna Obi', 'obinna.obi547@example.com', '+2348016959870', '{"street": "189 Allen Avenue", "city": "Maiduguri", "zip": "600001"}', '{"marketing_opt_in": false, "categories": ["Books", "Food", "Sports"]}'),
('Abdul Onyia', 'abdul.onyia861@example.com', '+2348094121036', '{"street": "170 Sultan Abubakar", "city": "Kaduna", "zip": "800001"}', '{"marketing_opt_in": true, "categories": ["Sports"]}'),
('Mohammed Salami', 'mohammed.salami386@example.com', '+2348062970862', '{"street": "176 Ahmadu Bello Way", "city": "Kano", "zip": "700001"}', '{"marketing_opt_in": false, "categories": ["Beauty", "Fashion", "Electronics"]}'),
('Jide Akinwande', 'jide.akinwande289@example.com', '+2348014689868', '{"street": "113 Yakubu Gowon", "city": "Lagos", "zip": "100001"}', '{"marketing_opt_in": true, "categories": ["Home & Garden"]}'),
('Wale Mohammed', 'wale.mohammed793@example.com', '+2348031268123', '{"street": "123 Ahmadu Bello Way", "city": "Lagos", "zip": "100001"}', '{"marketing_opt_in": false, "categories": ["Books", "Home & Garden", "Fashion"]}'),
('Deborah Aliyu', 'deborah.aliyu167@example.com', '+2348037417376', '{"street": "176 Emeka Anyaoku", "city": "Zaria", "zip": "810001"}', '{"marketing_opt_in": true, "categories": ["Books", "Sports"]}'),
('Zainab Okoh', 'zainab.okoh162@example.com', '+2348095248163', '{"street": "194 Allen Avenue", "city": "Onitsha", "zip": "430001"}', '{"marketing_opt_in": false, "categories": ["Books"]}'),
('Yusuf Okafor', 'yusuf.okafor40@example.com', '+2348018815489', '{"street": "150 Olusegun Obasanjo", "city": "Kaduna", "zip": "800001"}', '{"marketing_opt_in": true, "categories": ["Fashion"]}'),
('Sani Nwosu', 'sani.nwosu960@example.com', '+2348082090317', '{"street": "8 Marina Road", "city": "Kano", "zip": "700001"}', '{"marketing_opt_in": true, "categories": ["Toys", "Books", "Sports"]}'),
('Olu Alade', 'olu.alade119@example.com', '+2348021169954', '{"street": "197 Adekunle Fajuyi", "city": "Aba", "zip": "450001"}', '{"marketing_opt_in": false, "categories": ["Fashion", "Beauty"]}'),
('Adanna Bello', 'adanna.bello630@example.com', '+2348013472458', '{"street": "139 Nnamdi Azikiwe", "city": "Kaduna", "zip": "800001"}', '{"marketing_opt_in": false, "categories": ["Food", "Home & Garden", "Books"]}'),
('Tunde Okoro', 'tunde.okoro717@example.com', '+2348004909211', '{"street": "108 Samuel Ladoke Akintola", "city": "Maiduguri", "zip": "600001"}', '{"marketing_opt_in": false, "categories": ["Books", "Home & Garden", "Food"]}'),
('Chinedu Onyeama', 'chinedu.onyeama239@example.com', '+2348096253347', '{"street": "88 Allen Avenue", "city": "Benin City", "zip": "300001"}', '{"marketing_opt_in": true, "categories": ["Fashion"]}'),
('Obinna Okeke', 'obinna.okeke557@example.com', '+2348047893666', '{"street": "187 Murtala Mohammed", "city": "Maiduguri", "zip": "600001"}', '{"marketing_opt_in": false, "categories": ["Electronics", "Home & Garden"]}'),
('Sani Aliyu', 'sani.aliyu796@example.com', '+2348040007811', '{"street": "75 Nnamdi Azikiwe", "city": "Benin City", "zip": "300001"}', '{"marketing_opt_in": false, "categories": ["Sports", "Home & Garden"]}'),
('Adanna Okafor', 'adanna.okafor382@example.com', '+2348010122733', '{"street": "99 Marina Road", "city": "Abuja", "zip": "900001"}', '{"marketing_opt_in": true, "categories": ["Food", "Sports", "Home & Garden"]}'),
('Mohammed Ogbonna', 'mohammed.ogbonna626@example.com', '+2348050455114', '{"street": "103 Sultan Abubakar", "city": "Lagos", "zip": "100001"}', '{"marketing_opt_in": false, "categories": ["Toys", "Books"]}'),
('Kunle Okorie', 'kunle.okorie739@example.com', '+2348075454423', '{"street": "165 Nnamdi Azikiwe", "city": "Warri", "zip": "330001"}', '{"marketing_opt_in": true, "categories": ["Home & Garden", "Sports", "Toys"]}'),
('Kemi Eze', 'kemi.eze624@example.com', '+2348041266830', '{"street": "93 Awolowo Road", "city": "Aba", "zip": "450001"}', '{"marketing_opt_in": false, "categories": ["Beauty"]}'),
('Okonkwo Balogun', 'okonkwo.balogun323@example.com', '+2348042441565', '{"street": "192 Murtala Mohammed", "city": "Benin City", "zip": "300001"}', '{"marketing_opt_in": true, "categories": ["Books"]}'),
('Bola Adeleke', 'bola.adeleke493@example.com', '+2348000278766', '{"street": "47 Anthony Enahoro", "city": "Kaduna", "zip": "800001"}', '{"marketing_opt_in": true, "categories": ["Books"]}'),
('Okonkwo Okafor', 'okonkwo.okafor595@example.com', '+2348015314459', '{"street": "18 Adekunle Fajuyi", "city": "Aba", "zip": "450001"}', '{"marketing_opt_in": false, "categories": ["Beauty", "Food"]}'),
('Chinedu Aliyu', 'chinedu.aliyu856@example.com', '+2348057032947', '{"street": "48 Adetokunbo Ademola", "city": "Port Harcourt", "zip": "500001"}', '{"marketing_opt_in": false, "categories": ["Toys"]}'),
('Emeka Nwosu', 'emeka.nwosu567@example.com', '+2348004538620', '{"street": "70 Ibrahim Taiwo", "city": "Onitsha", "zip": "430001"}', '{"marketing_opt_in": true, "categories": ["Sports", "Electronics"]}'),
('Sani Ogbonna', 'sani.ogbonna868@example.com', '+2348041049074', '{"street": "117 Herbert Macaulay", "city": "Warri", "zip": "330001"}', '{"marketing_opt_in": true, "categories": ["Beauty", "Electronics"]}'),
('Bola Aliyu', 'bola.aliyu860@example.com', '+2348094133655', '{"street": "24 Ahmadu Bello Way", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": false, "categories": ["Home & Garden", "Books", "Food"]}'),
('Ngozi Aliyu', 'ngozi.aliyu712@example.com', '+2348039776022', '{"street": "65 Adekunle Fajuyi", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": true, "categories": ["Sports", "Books"]}'),
('Okonkwo Adewale', 'okonkwo.adewale675@example.com', '+2348037242641', '{"street": "31 Emeka Anyaoku", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": false, "categories": ["Toys"]}'),
('Chioma Obi', 'chioma.obi249@example.com', '+2348013154285', '{"street": "42 Ibrahim Taiwo", "city": "Abuja", "zip": "900001"}', '{"marketing_opt_in": false, "categories": ["Books", "Sports"]}'),
('Bola Okoro', 'bola.okoro359@example.com', '+2348008511310', '{"street": "143 Obafemi Awolowo", "city": "Warri", "zip": "330001"}', '{"marketing_opt_in": false, "categories": ["Toys", "Books", "Electronics"]}'),
('Amina Ojo', 'amina.ojo191@example.com', '+2348035084217', '{"street": "45 Emeka Anyaoku", "city": "Zaria", "zip": "810001"}', '{"marketing_opt_in": true, "categories": ["Home & Garden"]}'),
('Okonkwo Adeleke', 'okonkwo.adeleke621@example.com', '+2348065896819', '{"street": "118 Obafemi Awolowo", "city": "Onitsha", "zip": "430001"}', '{"marketing_opt_in": false, "categories": ["Sports", "Toys", "Food"]}'),
('Ibrahim Adebayo', 'ibrahim.adebayo589@example.com', '+2348022085646', '{"street": "169 Adekunle Fajuyi", "city": "Abuja", "zip": "900001"}', '{"marketing_opt_in": false, "categories": ["Food", "Electronics", "Beauty"]}'),
('Chioma Adeleke', 'chioma.adeleke880@example.com', '+2348039758882', '{"street": "43 Herbert Macaulay", "city": "Kaduna", "zip": "800001"}', '{"marketing_opt_in": false, "categories": ["Fashion", "Food", "Electronics"]}'),
('Chidinma Ibrahim', 'chidinma.ibrahim598@example.com', '+2348085244656', '{"street": "80 Samuel Ladoke Akintola", "city": "Maiduguri", "zip": "600001"}', '{"marketing_opt_in": true, "categories": ["Beauty", "Sports"]}'),
('Amara Ibrahim', 'amara.ibrahim189@example.com', '+2348007527144', '{"street": "50 Ibrahim Taiwo", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": false, "categories": ["Home & Garden", "Electronics", "Toys"]}'),
('Bola Adewale', 'bola.adewale725@example.com', '+2348043311834', '{"street": "132 Aminu Kano", "city": "Kano", "zip": "700001"}', '{"marketing_opt_in": true, "categories": ["Toys"]}'),
('Ibrahim Alade', 'ibrahim.alade755@example.com', '+2348062826183', '{"street": "126 Ibrahim Taiwo", "city": "Zaria", "zip": "810001"}', '{"marketing_opt_in": false, "categories": ["Beauty", "Fashion"]}'),
('Segun Aliyu', 'segun.aliyu463@example.com', '+2348011386811', '{"street": "83 Awolowo Road", "city": "Onitsha", "zip": "430001"}', '{"marketing_opt_in": true, "categories": ["Fashion", "Toys", "Home & Garden"]}'),
('Eze Chukwu', 'eze.chukwu139@example.com', '+2348056650863', '{"street": "81 Nnamdi Azikiwe", "city": "Benin City", "zip": "300001"}', '{"marketing_opt_in": false, "categories": ["Toys"]}'),
('Kunle Yusuf', 'kunle.yusuf93@example.com', '+2348093756413', '{"street": "116 Obafemi Awolowo", "city": "Onitsha", "zip": "430001"}', '{"marketing_opt_in": false, "categories": ["Beauty", "Electronics", "Fashion"]}'),
('Halima Okonkwo', 'halima.okonkwo531@example.com', '+2348044029239', '{"street": "123 Nnamdi Azikiwe", "city": "Calabar", "zip": "540001"}', '{"marketing_opt_in": true, "categories": ["Home & Garden"]}'),
('Chioma Onyeka', 'chioma.onyeka225@example.com', '+2348029463282', '{"street": "95 Oduduwa", "city": "Kaduna", "zip": "800001"}', '{"marketing_opt_in": false, "categories": ["Beauty", "Electronics"]}'),
('Wale Bello', 'wale.bello675@example.com', '+2348006752472', '{"street": "96 Olusegun Obasanjo", "city": "Calabar", "zip": "540001"}', '{"marketing_opt_in": false, "categories": ["Electronics", "Home & Garden", "Sports"]}'),
('Ibrahim Adeyemi', 'ibrahim.adeyemi393@example.com', '+2348060463331', '{"street": "184 Sultan Abubakar", "city": "Warri", "zip": "330001"}', '{"marketing_opt_in": false, "categories": ["Electronics"]}'),
('Okonkwo Okonkwo', 'okonkwo.okonkwo382@example.com', '+2348053395318', '{"street": "199 Marina Road", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": true, "categories": ["Books"]}'),
('Chinedu Okeke', 'chinedu.okeke393@example.com', '+2348006569909', '{"street": "146 Olusegun Obasanjo", "city": "Lagos", "zip": "100001"}', '{"marketing_opt_in": false, "categories": ["Books", "Home & Garden", "Fashion"]}'),
('Patience Okonkwo', 'patience.okonkwo56@example.com', '+2348022333830', '{"street": "54 Aminu Kano", "city": "Warri", "zip": "330001"}', '{"marketing_opt_in": false, "categories": ["Sports"]}'),
('Ade Aliyu', 'ade.aliyu830@example.com', '+2348056565347', '{"street": "174 Ibrahim Taiwo", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": true, "categories": ["Sports", "Food", "Toys"]}'),
('Chinedu Mustapha', 'chinedu.mustapha44@example.com', '+2348071194546', '{"street": "136 Obafemi Awolowo", "city": "Port Harcourt", "zip": "500001"}', '{"marketing_opt_in": true, "categories": ["Books", "Food", "Sports"]}'),
('Halima Afolayan', 'halima.afolayan618@example.com', '+2348093531399', '{"street": "10 Herbert Macaulay", "city": "Abuja", "zip": "900001"}', '{"marketing_opt_in": true, "categories": ["Beauty", "Toys"]}'),
('Ngozi Ibrahim', 'ngozi.ibrahim588@example.com', '+2348006263961', '{"street": "136 Anthony Enahoro", "city": "Ibadan", "zip": "200001"}', '{"marketing_opt_in": false, "categories": ["Beauty", "Home & Garden"]}'),
('Femi Okafor', 'femi.okafor575@example.com', '+2348070639059', '{"street": "13 Awolowo Road", "city": "Warri", "zip": "330001"}', '{"marketing_opt_in": false, "categories": ["Home & Garden"]}'),
('Ibrahim Umar', 'ibrahim.umar650@example.com', '+2348006085202', '{"street": "118 Obafemi Awolowo", "city": "Port Harcourt", "zip": "500001"}', '{"marketing_opt_in": true, "categories": ["Beauty", "Home & Garden"]}'),
('Bola Sule', 'bola.sule317@example.com', '+2348038246484', '{"street": "185 Emeka Anyaoku", "city": "Warri", "zip": "330001"}', '{"marketing_opt_in": false, "categories": ["Fashion", "Electronics", "Sports"]}'),
('Femi Mustapha', 'femi.mustapha881@example.com', '+2348023658564', '{"street": "161 Allen Avenue", "city": "Abeokuta", "zip": "110001"}', '{"marketing_opt_in": true, "categories": ["Home & Garden"]}'),
('Chinedu Yusuf', 'chinedu.yusuf989@example.com', '+2348093868973', '{"street": "78 Murtala Mohammed", "city": "Maiduguri", "zip": "600001"}', '{"marketing_opt_in": true, "categories": ["Home & Garden"]}'),
('Okonkwo Adewale', 'okonkwo.adewale187@example.com', '+2348089365804', '{"street": "189 Awolowo Road", "city": "Benin City", "zip": "300001"}', '{"marketing_opt_in": true, "categories": ["Food", "Fashion", "Home & Garden"]}'),
('Obinna Aliyu', 'obinna.aliyu903@example.com', '+2348045363859', '{"street": "33 Adekunle Fajuyi", "city": "Maiduguri", "zip": "600001"}', '{"marketing_opt_in": true, "categories": ["Home & Garden"]}'),
('Eze Yusuf', 'eze.yusuf914@example.com', '+2348015335568', '{"street": "84 Oduduwa", "city": "Kaduna", "zip": "800001"}', '{"marketing_opt_in": false, "categories": ["Food"]}'),
('Jide Okonkwo', 'jide.okonkwo195@example.com', '+2348052063524', '{"street": "85 Sultan Abubakar", "city": "Onitsha", "zip": "430001"}', '{"marketing_opt_in": false, "categories": ["Sports", "Beauty"]}'),
('Tunde Adebayo', 'tunde.adebayo788@example.com', '+2348095191361', '{"street": "108 Murtala Mohammed", "city": "Benin City", "zip": "300001"}', '{"marketing_opt_in": false, "categories": ["Food", "Toys", "Beauty"]}'),
('Abdul Nwosu', 'abdul.nwosu903@example.com', '+2348006212101', '{"street": "188 Yakubu Gowon", "city": "Benin City", "zip": "300001"}', '{"marketing_opt_in": false, "categories": ["Fashion"]}'),
('Yusuf Olu', 'yusuf.olu888@example.com', '+2348073000626', '{"street": "174 Marina Road", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": false, "categories": ["Sports", "Home & Garden", "Toys"]}'),
('Mohammed Oladipo', 'mohammed.oladipo719@example.com', '+2348072333427', '{"street": "105 Allen Avenue", "city": "Port Harcourt", "zip": "500001"}', '{"marketing_opt_in": false, "categories": ["Home & Garden"]}'),
('Okonkwo Eze', 'okonkwo.eze18@example.com', '+2348070580506', '{"street": "103 Adetokunbo Ademola", "city": "Aba", "zip": "450001"}', '{"marketing_opt_in": false, "categories": ["Beauty", "Food"]}'),
('Bola Okonkwo', 'bola.okonkwo77@example.com', '+2348086089661', '{"street": "111 Olusegun Obasanjo", "city": "Abuja", "zip": "900001"}', '{"marketing_opt_in": true, "categories": ["Food", "Beauty", "Electronics"]}'),
('Chika Balogun', 'chika.balogun820@example.com', '+2348058194763', '{"street": "90 Adetokunbo Ademola", "city": "Warri", "zip": "330001"}', '{"marketing_opt_in": false, "categories": ["Electronics", "Beauty"]}'),
('Blessing Akinwande', 'blessing.akinwande611@example.com', '+2348091337285', '{"street": "131 Marina Road", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": true, "categories": ["Beauty", "Electronics"]}'),
('Funke Balogun', 'funke.balogun11@example.com', '+2348025233413', '{"street": "139 Yakubu Gowon", "city": "Ibadan", "zip": "200001"}', '{"marketing_opt_in": false, "categories": ["Electronics", "Home & Garden"]}'),
('Chioma Adewale', 'chioma.adewale621@example.com', '+2348034594750', '{"street": "10 Ahmadu Bello Way", "city": "Onitsha", "zip": "430001"}', '{"marketing_opt_in": false, "categories": ["Food", "Toys"]}'),
('Sani Aliyu', 'sani.aliyu20@example.com', '+2348079060690', '{"street": "46 Adetokunbo Ademola", "city": "Benin City", "zip": "300001"}', '{"marketing_opt_in": true, "categories": ["Electronics", "Food", "Toys"]}'),
('Patience Olu', 'patience.olu844@example.com', '+2348066999440', '{"street": "88 Anthony Enahoro", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": false, "categories": ["Home & Garden", "Sports", "Toys"]}'),
('Ngozi Balogun', 'ngozi.balogun949@example.com', '+2348015569945', '{"street": "130 Oduduwa", "city": "Zaria", "zip": "810001"}', '{"marketing_opt_in": false, "categories": ["Home & Garden", "Sports"]}'),
('Halima Adeyemi', 'halima.adeyemi631@example.com', '+2348061206538', '{"street": "136 Allen Avenue", "city": "Kano", "zip": "700001"}', '{"marketing_opt_in": true, "categories": ["Sports", "Home & Garden"]}'),
('Musa Afolayan', 'musa.afolayan280@example.com', '+2348067886235', '{"street": "53 Olusegun Obasanjo", "city": "Abeokuta", "zip": "110001"}', '{"marketing_opt_in": true, "categories": ["Books", "Home & Garden", "Fashion"]}'),
('Amina Okonkwo', 'amina.okonkwo605@example.com', '+2348080173354', '{"street": "78 Ahmadu Bello Way", "city": "Onitsha", "zip": "430001"}', '{"marketing_opt_in": true, "categories": ["Sports", "Electronics", "Books"]}'),
('Chioma Chukwu', 'chioma.chukwu365@example.com', '+2348007536652', '{"street": "173 Samuel Ladoke Akintola", "city": "Port Harcourt", "zip": "500001"}', '{"marketing_opt_in": true, "categories": ["Home & Garden"]}'),
('Zainab Akintola', 'zainab.akintola36@example.com', '+2348029878019', '{"street": "186 Obafemi Awolowo", "city": "Lagos", "zip": "100001"}', '{"marketing_opt_in": false, "categories": ["Food"]}'),
('Abdul Uche', 'abdul.uche464@example.com', '+2348088429142', '{"street": "47 Nnamdi Azikiwe", "city": "Ibadan", "zip": "200001"}', '{"marketing_opt_in": true, "categories": ["Food", "Home & Garden", "Electronics"]}'),
('Temitope Okorie', 'temitope.okorie412@example.com', '+2348023410842', '{"street": "89 Emeka Anyaoku", "city": "Abuja", "zip": "900001"}', '{"marketing_opt_in": false, "categories": ["Fashion", "Home & Garden"]}'),
('Zara Okonkwo', 'zara.okonkwo107@example.com', '+2348029924284', '{"street": "181 Sultan Abubakar", "city": "Warri", "zip": "330001"}', '{"marketing_opt_in": true, "categories": ["Electronics"]}'),
('Okonkwo Aliyu', 'okonkwo.aliyu108@example.com', '+2348031203351', '{"street": "65 Awolowo Road", "city": "Abuja", "zip": "900001"}', '{"marketing_opt_in": true, "categories": ["Electronics"]}'),
('Sani Afolayan', 'sani.afolayan114@example.com', '+2348058931272', '{"street": "32 Aminu Kano", "city": "Benin City", "zip": "300001"}', '{"marketing_opt_in": true, "categories": ["Sports", "Electronics"]}'),
('Ibrahim Yusuf', 'ibrahim.yusuf199@example.com', '+2348075587561', '{"street": "106 Oduduwa", "city": "Lagos", "zip": "100001"}', '{"marketing_opt_in": true, "categories": ["Sports", "Food", "Beauty"]}'),
('Ade Olu', 'ade.olu591@example.com', '+2348041871641', '{"street": "76 Marina Road", "city": "Warri", "zip": "330001"}', '{"marketing_opt_in": false, "categories": ["Fashion", "Electronics"]}'),
('Mohammed Ibrahim', 'mohammed.ibrahim306@example.com', '+2348070694976', '{"street": "80 Marina Road", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": true, "categories": ["Electronics"]}'),
('Kemi Alade', 'kemi.alade455@example.com', '+2348004494938', '{"street": "7 Michael Okpara", "city": "Abeokuta", "zip": "110001"}', '{"marketing_opt_in": true, "categories": ["Toys"]}'),
('Ifeoma Onyeka', 'ifeoma.onyeka957@example.com', '+2348066829688', '{"street": "13 Allen Avenue", "city": "Kaduna", "zip": "800001"}', '{"marketing_opt_in": false, "categories": ["Home & Garden"]}'),
('Funke Ibrahim', 'funke.ibrahim698@example.com', '+2348067297970', '{"street": "115 Allen Avenue", "city": "Onitsha", "zip": "430001"}', '{"marketing_opt_in": false, "categories": ["Toys", "Sports"]}'),
('Bola Aliyu', 'bola.aliyu745@example.com', '+2348043386537', '{"street": "186 Emeka Anyaoku", "city": "Benin City", "zip": "300001"}', '{"marketing_opt_in": false, "categories": ["Electronics", "Home & Garden"]}'),
('Ifeoma Chukwu', 'ifeoma.chukwu279@example.com', '+2348095442787', '{"street": "45 Ahmadu Bello Way", "city": "Calabar", "zip": "540001"}', '{"marketing_opt_in": true, "categories": ["Sports", "Electronics", "Toys"]}'),
('Chukwu Afolayan', 'chukwu.afolayan787@example.com', '+2348033255153', '{"street": "162 Adetokunbo Ademola", "city": "Abeokuta", "zip": "110001"}', '{"marketing_opt_in": true, "categories": ["Home & Garden", "Sports", "Fashion"]}'),
('Zara Okafor', 'zara.okafor674@example.com', '+2348021289860', '{"street": "45 Yakubu Gowon", "city": "Port Harcourt", "zip": "500001"}', '{"marketing_opt_in": true, "categories": ["Books", "Food"]}'),
('Okonkwo Adewale', 'okonkwo.adewale305@example.com', '+2348060852969', '{"street": "125 Allen Avenue", "city": "Ibadan", "zip": "200001"}', '{"marketing_opt_in": true, "categories": ["Food", "Fashion"]}'),
('Abdul Afolayan', 'abdul.afolayan311@example.com', '+2348049074728', '{"street": "12 Olusegun Obasanjo", "city": "Zaria", "zip": "810001"}', '{"marketing_opt_in": false, "categories": ["Toys", "Food"]}'),
('Ngozi Ogunleye', 'ngozi.ogunleye334@example.com', '+2348056258856', '{"street": "85 Michael Okpara", "city": "Abuja", "zip": "900001"}', '{"marketing_opt_in": false, "categories": ["Fashion", "Food", "Home & Garden"]}'),
('Chidinma Onyeka', 'chidinma.onyeka883@example.com', '+2348069217114', '{"street": "33 Ahmadu Bello Way", "city": "Warri", "zip": "330001"}', '{"marketing_opt_in": false, "categories": ["Toys"]}'),
('Abdul Akintola', 'abdul.akintola649@example.com', '+2348019942359', '{"street": "197 Nnamdi Azikiwe", "city": "Aba", "zip": "450001"}', '{"marketing_opt_in": true, "categories": ["Books"]}'),
('Sani Umar', 'sani.umar455@example.com', '+2348028581632', '{"street": "173 Allen Avenue", "city": "Ibadan", "zip": "200001"}', '{"marketing_opt_in": true, "categories": ["Books", "Beauty"]}'),
('Ifeoma Okorie', 'ifeoma.okorie17@example.com', '+2348008907267', '{"street": "55 Murtala Mohammed", "city": "Lagos", "zip": "100001"}', '{"marketing_opt_in": false, "categories": ["Home & Garden", "Sports", "Books"]}'),
('Amara Olu', 'amara.olu951@example.com', '+2348041067120', '{"street": "162 Marina Road", "city": "Benin City", "zip": "300001"}', '{"marketing_opt_in": false, "categories": ["Electronics", "Sports"]}'),
('Zara Onyeka', 'zara.onyeka353@example.com', '+2348086979268', '{"street": "103 Anthony Enahoro", "city": "Port Harcourt", "zip": "500001"}', '{"marketing_opt_in": false, "categories": ["Food", "Home & Garden"]}'),
('Emeka Alade', 'emeka.alade33@example.com', '+2348090249093', '{"street": "12 Sultan Abubakar", "city": "Kano", "zip": "700001"}', '{"marketing_opt_in": false, "categories": ["Food"]}'),
('Kemi Eze', 'kemi.eze380@example.com', '+2348050587590', '{"street": "18 Obafemi Awolowo", "city": "Kano", "zip": "700001"}', '{"marketing_opt_in": true, "categories": ["Books", "Electronics", "Food"]}'),
('Bola Ogbonna', 'bola.ogbonna837@example.com', '+2348041625203', '{"street": "136 Herbert Macaulay", "city": "Zaria", "zip": "810001"}', '{"marketing_opt_in": true, "categories": ["Fashion"]}'),
('Abdul Ibrahim', 'abdul.ibrahim439@example.com', '+2348074544750', '{"street": "181 Samuel Ladoke Akintola", "city": "Abuja", "zip": "900001"}', '{"marketing_opt_in": true, "categories": ["Home & Garden", "Beauty"]}'),
('Jide Umar', 'jide.umar179@example.com', '+2348064259445', '{"street": "88 Awolowo Road", "city": "Benin City", "zip": "300001"}', '{"marketing_opt_in": true, "categories": ["Home & Garden", "Electronics", "Food"]}'),
('Emeka Obi', 'emeka.obi533@example.com', '+2348089829793', '{"street": "169 Marina Road", "city": "Aba", "zip": "450001"}', '{"marketing_opt_in": false, "categories": ["Electronics", "Food"]}'),
('Zainab Balogun', 'zainab.balogun943@example.com', '+2348008204349', '{"street": "70 Ibrahim Taiwo", "city": "Calabar", "zip": "540001"}', '{"marketing_opt_in": true, "categories": ["Beauty", "Food"]}'),
('Okonkwo Afolayan', 'okonkwo.afolayan787@example.com', '+2348085117535', '{"street": "144 Anthony Enahoro", "city": "Onitsha", "zip": "430001"}', '{"marketing_opt_in": false, "categories": ["Food"]}'),
('Ngozi Olu', 'ngozi.olu88@example.com', '+2348009585128', '{"street": "164 Marina Road", "city": "Kano", "zip": "700001"}', '{"marketing_opt_in": true, "categories": ["Electronics", "Beauty"]}'),
('Okonkwo Oladipo', 'okonkwo.oladipo300@example.com', '+2348008321055', '{"street": "121 Michael Okpara", "city": "Kaduna", "zip": "800001"}', '{"marketing_opt_in": true, "categories": ["Books", "Sports"]}'),
('Temitope Akintola', 'temitope.akintola810@example.com', '+2348044792999', '{"street": "23 Aminu Kano", "city": "Zaria", "zip": "810001"}', '{"marketing_opt_in": false, "categories": ["Books", "Electronics", "Fashion"]}'),
('Eze Okoro', 'eze.okoro848@example.com', '+2348070527886', '{"street": "36 Awolowo Road", "city": "Zaria", "zip": "810001"}', '{"marketing_opt_in": true, "categories": ["Electronics", "Beauty", "Books"]}'),
('Jide Okoh', 'jide.okoh659@example.com', '+2348066878570', '{"street": "105 Adekunle Fajuyi", "city": "Zaria", "zip": "810001"}', '{"marketing_opt_in": false, "categories": ["Toys", "Electronics"]}'),
('Chukwu Okonkwo', 'chukwu.okonkwo85@example.com', '+2348099850758', '{"street": "8 Ahmadu Bello Way", "city": "Aba", "zip": "450001"}', '{"marketing_opt_in": true, "categories": ["Fashion", "Home & Garden", "Food"]}'),
('Amara Nwosu', 'amara.nwosu861@example.com', '+2348066008429', '{"street": "149 Awolowo Road", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": true, "categories": ["Food", "Fashion"]}'),
('Obinna Okonkwo', 'obinna.okonkwo86@example.com', '+2348042692624', '{"street": "22 Ibrahim Taiwo", "city": "Lagos", "zip": "100001"}', '{"marketing_opt_in": false, "categories": ["Home & Garden"]}'),
('Abdul Mustapha', 'abdul.mustapha698@example.com', '+2348026998388', '{"street": "39 Herbert Macaulay", "city": "Kano", "zip": "700001"}', '{"marketing_opt_in": false, "categories": ["Sports", "Fashion"]}'),
('Ade Okafor', 'ade.okafor260@example.com', '+2348032682084', '{"street": "107 Anthony Enahoro", "city": "Abeokuta", "zip": "110001"}', '{"marketing_opt_in": false, "categories": ["Toys", "Electronics", "Fashion"]}'),
('Ifeoma Eze', 'ifeoma.eze721@example.com', '+2348041650570', '{"street": "27 Awolowo Road", "city": "Zaria", "zip": "810001"}', '{"marketing_opt_in": false, "categories": ["Electronics", "Beauty"]}'),
('Mohammed Uche', 'mohammed.uche998@example.com', '+2348031470015', '{"street": "83 Oduduwa", "city": "Abuja", "zip": "900001"}', '{"marketing_opt_in": false, "categories": ["Home & Garden", "Books"]}'),
('Wale Ibrahim', 'wale.ibrahim587@example.com', '+2348012552023', '{"street": "187 Allen Avenue", "city": "Zaria", "zip": "810001"}', '{"marketing_opt_in": false, "categories": ["Beauty", "Books"]}'),
('Bola Obi', 'bola.obi737@example.com', '+2348055374299', '{"street": "162 Herbert Macaulay", "city": "Ibadan", "zip": "200001"}', '{"marketing_opt_in": false, "categories": ["Electronics"]}'),
('Temitope Okonkwo', 'temitope.okonkwo852@example.com', '+2348003391112', '{"street": "127 Adekunle Fajuyi", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": true, "categories": ["Books", "Toys", "Home & Garden"]}'),
('Ifeoma Onyeama', 'ifeoma.onyeama275@example.com', '+2348014110901', '{"street": "101 Adekunle Fajuyi", "city": "Ibadan", "zip": "200001"}', '{"marketing_opt_in": true, "categories": ["Fashion"]}'),
('Funke Adeyemi', 'funke.adeyemi48@example.com', '+2348006333215', '{"street": "11 Anthony Enahoro", "city": "Abeokuta", "zip": "110001"}', '{"marketing_opt_in": false, "categories": ["Food", "Toys"]}'),
('Musa Okoh', 'musa.okoh301@example.com', '+2348048776609', '{"street": "199 Aminu Kano", "city": "Ibadan", "zip": "200001"}', '{"marketing_opt_in": false, "categories": ["Books", "Sports"]}'),
('Bola Okonkwo', 'bola.okonkwo898@example.com', '+2348044993362', '{"street": "16 Marina Road", "city": "Zaria", "zip": "810001"}', '{"marketing_opt_in": true, "categories": ["Beauty", "Toys"]}'),
('Adanna Oladipo', 'adanna.oladipo328@example.com', '+2348030004065', '{"street": "177 Michael Okpara", "city": "Zaria", "zip": "810001"}', '{"marketing_opt_in": true, "categories": ["Books"]}'),
('Amina Okafor', 'amina.okafor32@example.com', '+2348098884000', '{"street": "199 Yakubu Gowon", "city": "Abuja", "zip": "900001"}', '{"marketing_opt_in": true, "categories": ["Books", "Electronics", "Sports"]}'),
('Musa Olu', 'musa.olu836@example.com', '+2348096198956', '{"street": "189 Oduduwa", "city": "Benin City", "zip": "300001"}', '{"marketing_opt_in": false, "categories": ["Toys", "Books", "Food"]}'),
('Temitope Adeleke', 'temitope.adeleke407@example.com', '+2348026653083', '{"street": "152 Michael Okpara", "city": "Lagos", "zip": "100001"}', '{"marketing_opt_in": false, "categories": ["Home & Garden"]}'),
('Abdul Onyeka', 'abdul.onyeka791@example.com', '+2348058939816', '{"street": "16 Herbert Macaulay", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": true, "categories": ["Fashion"]}'),
('Zara Bello', 'zara.bello553@example.com', '+2348081523134', '{"street": "54 Oduduwa", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": true, "categories": ["Books", "Sports", "Toys"]}'),
('Amina Onyeama', 'amina.onyeama5@example.com', '+2348074826829', '{"street": "97 Awolowo Road", "city": "Lagos", "zip": "100001"}', '{"marketing_opt_in": false, "categories": ["Fashion", "Electronics"]}'),
('Blessing Afolayan', 'blessing.afolayan762@example.com', '+2348080085810', '{"street": "57 Oduduwa", "city": "Zaria", "zip": "810001"}', '{"marketing_opt_in": true, "categories": ["Books", "Fashion"]}'),
('Musa Okoh', 'musa.okoh211@example.com', '+2348019460860', '{"street": "13 Marina Road", "city": "Onitsha", "zip": "430001"}', '{"marketing_opt_in": true, "categories": ["Electronics"]}'),
('Fatima Eze', 'fatima.eze175@example.com', '+2348068291790', '{"street": "73 Ahmadu Bello Way", "city": "Zaria", "zip": "810001"}', '{"marketing_opt_in": true, "categories": ["Fashion"]}'),
('Eze Adeyemi', 'eze.adeyemi737@example.com', '+2348086621481', '{"street": "94 Herbert Macaulay", "city": "Port Harcourt", "zip": "500001"}', '{"marketing_opt_in": false, "categories": ["Beauty", "Books"]}'),
('Ifeoma Oladipo', 'ifeoma.oladipo937@example.com', '+2348027477999', '{"street": "177 Herbert Macaulay", "city": "Abeokuta", "zip": "110001"}', '{"marketing_opt_in": true, "categories": ["Fashion", "Home & Garden"]}'),
('Ade Onyema', 'ade.onyema587@example.com', '+2348043716525', '{"street": "78 Awolowo Road", "city": "Warri", "zip": "330001"}', '{"marketing_opt_in": false, "categories": ["Toys"]}'),
('Olu Obi', 'olu.obi247@example.com', '+2348019550307', '{"street": "107 Sultan Abubakar", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": false, "categories": ["Books", "Home & Garden", "Sports"]}'),
('Amara Mohammed', 'amara.mohammed803@example.com', '+2348025198357', '{"street": "167 Oduduwa", "city": "Kano", "zip": "700001"}', '{"marketing_opt_in": false, "categories": ["Food", "Electronics", "Toys"]}'),
('Eze Onyeka', 'eze.onyeka357@example.com', '+2348044063615', '{"street": "142 Emeka Anyaoku", "city": "Onitsha", "zip": "430001"}', '{"marketing_opt_in": false, "categories": ["Books", "Electronics", "Fashion"]}'),
('Segun Ogbonna', 'segun.ogbonna547@example.com', '+2348071228287', '{"street": "13 Herbert Macaulay", "city": "Aba", "zip": "450001"}', '{"marketing_opt_in": false, "categories": ["Fashion", "Beauty"]}'),
('Chioma Balogun', 'chioma.balogun457@example.com', '+2348003797873', '{"street": "1 Allen Avenue", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": false, "categories": ["Sports", "Home & Garden", "Books"]}'),
('Mohammed Eze', 'mohammed.eze144@example.com', '+2348038839091', '{"street": "188 Aminu Kano", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": true, "categories": ["Toys", "Fashion"]}'),
('Ifeoma Onyeka', 'ifeoma.onyeka455@example.com', '+2348051188745', '{"street": "61 Obafemi Awolowo", "city": "Abuja", "zip": "900001"}', '{"marketing_opt_in": true, "categories": ["Sports"]}'),
('Musa Ogunleye', 'musa.ogunleye550@example.com', '+2348016074254', '{"street": "100 Olusegun Obasanjo", "city": "Onitsha", "zip": "430001"}', '{"marketing_opt_in": false, "categories": ["Books", "Food", "Home & Garden"]}'),
('Tunde Akinwande', 'tunde.akinwande160@example.com', '+2348066778118', '{"street": "137 Adekunle Fajuyi", "city": "Lagos", "zip": "100001"}', '{"marketing_opt_in": false, "categories": ["Books", "Sports", "Toys"]}'),
('Femi Adeleke', 'femi.adeleke997@example.com', '+2348029956825', '{"street": "181 Oduduwa", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": true, "categories": ["Home & Garden", "Toys"]}'),
('Musa Onyeka', 'musa.onyeka173@example.com', '+2348063333235', '{"street": "148 Awolowo Road", "city": "Abeokuta", "zip": "110001"}', '{"marketing_opt_in": false, "categories": ["Sports"]}'),
('Mohammed Onyia', 'mohammed.onyia20@example.com', '+2348013734339', '{"street": "190 Ahmadu Bello Way", "city": "Port Harcourt", "zip": "500001"}', '{"marketing_opt_in": false, "categories": ["Beauty", "Books", "Sports"]}'),
('Temitope Bakare', 'temitope.bakare566@example.com', '+2348057115156', '{"street": "38 Aminu Kano", "city": "Warri", "zip": "330001"}', '{"marketing_opt_in": false, "categories": ["Books"]}'),
('Emeka Eze', 'emeka.eze142@example.com', '+2348080333453', '{"street": "195 Oduduwa", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": true, "categories": ["Fashion", "Sports", "Home & Garden"]}'),
('Okonkwo Alade', 'okonkwo.alade860@example.com', '+2348004818882', '{"street": "181 Ibrahim Taiwo", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": false, "categories": ["Beauty", "Books"]}'),
('Ade Adeleke', 'ade.adeleke719@example.com', '+2348087003321', '{"street": "88 Obafemi Awolowo", "city": "Onitsha", "zip": "430001"}', '{"marketing_opt_in": true, "categories": ["Food"]}'),
('Kemi Oladipo', 'kemi.oladipo705@example.com', '+2348049731789', '{"street": "135 Obafemi Awolowo", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": true, "categories": ["Sports"]}'),
('Fatima Alade', 'fatima.alade450@example.com', '+2348053376998', '{"street": "19 Ahmadu Bello Way", "city": "Abeokuta", "zip": "110001"}', '{"marketing_opt_in": false, "categories": ["Toys", "Fashion"]}'),
('Amina Adebayo', 'amina.adebayo627@example.com', '+2348015162634', '{"street": "90 Emeka Anyaoku", "city": "Abuja", "zip": "900001"}', '{"marketing_opt_in": false, "categories": ["Toys", "Food", "Books"]}'),
('Ifeoma Uche', 'ifeoma.uche942@example.com', '+2348091059082', '{"street": "171 Ibrahim Taiwo", "city": "Port Harcourt", "zip": "500001"}', '{"marketing_opt_in": true, "categories": ["Sports", "Books", "Home & Garden"]}'),
('Musa Ibrahim', 'musa.ibrahim26@example.com', '+2348098594790', '{"street": "154 Adekunle Fajuyi", "city": "Ibadan", "zip": "200001"}', '{"marketing_opt_in": false, "categories": ["Beauty", "Sports", "Toys"]}'),
('Wale Obi', 'wale.obi265@example.com', '+2348028262768', '{"street": "71 Anthony Enahoro", "city": "Maiduguri", "zip": "600001"}', '{"marketing_opt_in": true, "categories": ["Food", "Toys"]}'),
('Amina Uche', 'amina.uche506@example.com', '+2348070629744', '{"street": "49 Nnamdi Azikiwe", "city": "Abuja", "zip": "900001"}', '{"marketing_opt_in": true, "categories": ["Food", "Books", "Electronics"]}'),
('Funke Mohammed', 'funke.mohammed266@example.com', '+2348032436959', '{"street": "43 Sultan Abubakar", "city": "Onitsha", "zip": "430001"}', '{"marketing_opt_in": true, "categories": ["Books"]}'),
('Kunle Chukwu', 'kunle.chukwu525@example.com', '+2348099289696', '{"street": "159 Allen Avenue", "city": "Abuja", "zip": "900001"}', '{"marketing_opt_in": false, "categories": ["Beauty"]}'),
('Jide Ojo', 'jide.ojo656@example.com', '+2348010895118', '{"street": "189 Adekunle Fajuyi", "city": "Lagos", "zip": "100001"}', '{"marketing_opt_in": false, "categories": ["Sports", "Beauty", "Electronics"]}'),
('Patience Onyia', 'patience.onyia422@example.com', '+2348014718620', '{"street": "74 Herbert Macaulay", "city": "Kano", "zip": "700001"}', '{"marketing_opt_in": true, "categories": ["Food", "Books"]}'),
('Zara Mustapha', 'zara.mustapha234@example.com', '+2348096276325', '{"street": "160 Ibrahim Taiwo", "city": "Abeokuta", "zip": "110001"}', '{"marketing_opt_in": false, "categories": ["Electronics", "Sports"]}'),
('Okonkwo Eze', 'okonkwo.eze93@example.com', '+2348029447582', '{"street": "119 Ahmadu Bello Way", "city": "Abeokuta", "zip": "110001"}', '{"marketing_opt_in": false, "categories": ["Sports"]}'),
('Blessing Ogunleye', 'blessing.ogunleye45@example.com', '+2348010918372', '{"street": "22 Ahmadu Bello Way", "city": "Abeokuta", "zip": "110001"}', '{"marketing_opt_in": true, "categories": ["Toys", "Home & Garden"]}'),
('Tunde Umar', 'tunde.umar165@example.com', '+2348099417024', '{"street": "109 Anthony Enahoro", "city": "Maiduguri", "zip": "600001"}', '{"marketing_opt_in": false, "categories": ["Home & Garden", "Electronics", "Food"]}'),
('Chinedu Uche', 'chinedu.uche173@example.com', '+2348075440623', '{"street": "90 Emeka Anyaoku", "city": "Kaduna", "zip": "800001"}', '{"marketing_opt_in": true, "categories": ["Electronics", "Toys", "Beauty"]}'),
('Okonkwo Adeleke', 'okonkwo.adeleke667@example.com', '+2348039722225', '{"street": "181 Yakubu Gowon", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": true, "categories": ["Toys"]}'),
('Ngozi Umar', 'ngozi.umar700@example.com', '+2348099799247', '{"street": "155 Ahmadu Bello Way", "city": "Warri", "zip": "330001"}', '{"marketing_opt_in": true, "categories": ["Sports", "Food"]}'),
('Obinna Adeleke', 'obinna.adeleke773@example.com', '+2348021366219', '{"street": "41 Adekunle Fajuyi", "city": "Kano", "zip": "700001"}', '{"marketing_opt_in": true, "categories": ["Electronics"]}'),
('Patience Umar', 'patience.umar48@example.com', '+2348046178680', '{"street": "137 Ibrahim Taiwo", "city": "Aba", "zip": "450001"}', '{"marketing_opt_in": true, "categories": ["Home & Garden", "Beauty"]}'),
('Eze Aliyu', 'eze.aliyu733@example.com', '+2348065458601', '{"street": "142 Sultan Abubakar", "city": "Onitsha", "zip": "430001"}', '{"marketing_opt_in": true, "categories": ["Sports", "Fashion", "Toys"]}'),
('Amara Aliyu', 'amara.aliyu16@example.com', '+2348006543710', '{"street": "178 Nnamdi Azikiwe", "city": "Lagos", "zip": "100001"}', '{"marketing_opt_in": true, "categories": ["Food"]}'),
('Ibrahim Alade', 'ibrahim.alade785@example.com', '+2348024825931', '{"street": "156 Michael Okpara", "city": "Lagos", "zip": "100001"}', '{"marketing_opt_in": true, "categories": ["Food", "Electronics", "Fashion"]}'),
('Fatima Umar', 'fatima.umar289@example.com', '+2348032128502', '{"street": "123 Adekunle Fajuyi", "city": "Abeokuta", "zip": "110001"}', '{"marketing_opt_in": false, "categories": ["Home & Garden", "Beauty"]}'),
('Amara Okoro', 'amara.okoro644@example.com', '+2348099822593', '{"street": "67 Oduduwa", "city": "Abeokuta", "zip": "110001"}', '{"marketing_opt_in": true, "categories": ["Electronics"]}'),
('Grace Ogbonna', 'grace.ogbonna637@example.com', '+2348078811042', '{"street": "152 Adekunle Fajuyi", "city": "Onitsha", "zip": "430001"}', '{"marketing_opt_in": false, "categories": ["Sports"]}'),
('Temitope Onyeka', 'temitope.onyeka711@example.com', '+2348033463402', '{"street": "135 Emeka Anyaoku", "city": "Benin City", "zip": "300001"}', '{"marketing_opt_in": true, "categories": ["Beauty", "Books"]}'),
('Jide Ibrahim', 'jide.ibrahim469@example.com', '+2348073197010', '{"street": "159 Ibrahim Taiwo", "city": "Aba", "zip": "450001"}', '{"marketing_opt_in": false, "categories": ["Books"]}'),
('Segun Eze', 'segun.eze613@example.com', '+2348084051519', '{"street": "136 Ahmadu Bello Way", "city": "Maiduguri", "zip": "600001"}', '{"marketing_opt_in": false, "categories": ["Toys", "Food"]}'),
('Grace Afolayan', 'grace.afolayan206@example.com', '+2348096197482', '{"street": "72 Emeka Anyaoku", "city": "Enugu", "zip": "400001"}', '{"marketing_opt_in": true, "categories": ["Electronics", "Toys"]}'),
('Musa Okonkwo', 'musa.okonkwo258@example.com', '+2348031280211', '{"street": "155 Herbert Macaulay", "city": "Calabar", "zip": "540001"}', '{"marketing_opt_in": true, "categories": ["Books"]}'),
('Halima Umar', 'halima.umar545@example.com', '+2348069152799', '{"street": "132 Oduduwa", "city": "Calabar", "zip": "540001"}', '{"marketing_opt_in": true, "categories": ["Toys", "Books", "Food"]}'),
('Temitope Akinwande', 'temitope.akinwande133@example.com', '+2348031969160', '{"street": "18 Herbert Macaulay", "city": "Abeokuta", "zip": "110001"}', '{"marketing_opt_in": true, "categories": ["Electronics", "Beauty", "Home & Garden"]}'),
('Temitope Ogunleye', 'temitope.ogunleye352@example.com', '+2348016278469', '{"street": "87 Ibrahim Taiwo", "city": "Kano", "zip": "700001"}', '{"marketing_opt_in": true, "categories": ["Toys", "Fashion", "Sports"]}'),
('Jide Okafor', 'jide.okafor425@example.com', '+2348092286045', '{"street": "51 Nnamdi Azikiwe", "city": "Onitsha", "zip": "430001"}', '{"marketing_opt_in": true, "categories": ["Electronics", "Toys"]}'),
('Wale Mohammed', 'wale.mohammed40@example.com', '+2348013136976', '{"street": "146 Herbert Macaulay", "city": "Lagos", "zip": "100001"}', '{"marketing_opt_in": true, "categories": ["Books", "Home & Garden"]}');

INSERT INTO products (product_name, price, category, stock_quantity, attributes)
VALUES
('Pro Biography', 14.35, 'Books', 831, '{"format": "e-Book", "ISBN": "978-0-437-32323-1", "genre": "Non-Fiction"}'),
('Science Fiction Novel', 24.79, 'Books', 495, '{"format": "Paperback", "ISBN": "978-1-188-72744-6", "genre": "Non-Fiction"}'),
('Cookbook', 869.65, 'Books', 615, '{"author": "Donald Frye", "pages": 478, "publisher": "Larson and Sons", "language": "English"}'),
('Advanced Formal Oxfords', 224.87, 'Footwear', 348, '{"closure": "Lace-up", "sole_material": "PU", "waterproof": false}'),
('Smart History Book', 1034.56, 'Books', 417, '{"author": "Tracy Oconnor", "pages": 796, "publisher": "Mcdonald, Phillips and Miller", "language": "English"}'),
('Premium Blazer', 79.48, 'Fashion', 350, '{"care_instructions": "Machine Wash", "style": "Vintage"}'),
('Moisturizer', 7.35, 'Beauty', 539, '{"organic": false, "cruelty_free": true}'),
('Premium Wall Clock', 384.15, 'Home & Garden', 580, '{"dimensions": "33x173cm", "color": "maroon", "material": "Ceramic"}'),
('Bedding Set', 82.47, 'Home & Garden', 910, '{"assembly_required": false, "weight_capacity": "104kg"}'),
('Gaming Mouse', 79.2, 'Electronics', 106, '{"RAM": "8GB", "storage": "1000GB HDD", "screen_size": "13.3 inch"}'),
('History Book', 96.03, 'Books', 823, '{"format": "Paperback", "ISBN": "978-0-527-68439-6", "genre": "Non-Fiction"}'),
('Moisturizer', 76.79, 'Beauty', 242, '{"organic": false, "cruelty_free": true}'),
('Flip Flops', 62.01, 'Footwear', 610, '{"closure": "Lace-up", "sole_material": "PU", "waterproof": false}'),
('Perfume', 819.61, 'Beauty', 160, '{"organic": false, "cruelty_free": true}'),
('Advanced Dress Shirt', 15.22, 'Fashion', 829, '{"care_instructions": "Dry Clean Only", "style": "Casual"}'),
('Mechanical Keyboard', 84.99, 'Electronics', 590, '{"resolution": "FHD", "connectivity": "USB-C", "processor": "Intel i5"}'),
('Blazer', 225.65, 'Fashion', 629, '{"care_instructions": "Machine Wash", "style": "Modern"}'),
('Premium Coffee Table', 285.88, 'Home & Garden', 56, '{"dimensions": "20x91cm", "color": "white", "material": "Metal"}'),
('Luxury Sandals', 514.39, 'Footwear', 802, '{"size": "47", "color": "Red", "material": "Synthetic"}'),
('Formal Oxfords', 112.39, 'Footwear', 283, '{"closure": "Velcro", "sole_material": "PU", "waterproof": true}'),
('Fitness Tracker', 462.01, 'Electronics', 107, '{"color": "Black", "battery_life": "20h", "weight": "906g"}'),
('Mechanical Keyboard', 480.69, 'Electronics', 986, '{"RAM": "16GB", "storage": "256GB HDD", "screen_size": "13.3 inch"}'),
('Makeup Kit', 37.61, 'Beauty', 833, '{"skin_type": "Sensitive", "volume": "316ml", "fragrance": "Floral"}'),
('Premium Gaming Mouse', 516.72, 'Electronics', 372, '{"resolution": "4K", "connectivity": "Wi-Fi 6", "processor": "AMD Ryzen 7"}'),
('Wall Clock', 266.23, 'Home & Garden', 265, '{"assembly_required": true, "weight_capacity": "161kg"}'),
('Biography', 1343.73, 'Books', 451, '{"author": "James Watts", "pages": 795, "publisher": "Adkins-Hall", "language": "English"}'),
('Science Fiction Novel', 51.81, 'Books', 177, '{"format": "Paperback", "ISBN": "978-1-4403-0720-1", "genre": "Non-Fiction"}'),
('Body Lotion', 142.17, 'Beauty', 678, '{"organic": true, "cruelty_free": false}'),
('Face Serum', 48.82, 'Beauty', 185, '{"skin_type": "All", "volume": "441ml", "fragrance": "Floral"}'),
('Decorative Vase', 969.02, 'Home & Garden', 788, '{"assembly_required": true, "weight_capacity": "303kg"}'),
('Pro Skirt', 484.48, 'Fashion', 417, '{"care_instructions": "Dry Clean Only", "style": "Vintage"}'),
('Wireless Skirt', 14.71, 'Fashion', 301, '{"care_instructions": "Dry Clean Only", "style": "Vintage"}'),
('Wireless Headphones', 188.36, 'Electronics', 244, '{"color": "White", "battery_life": "17h", "weight": "524g"}'),
('Science Fiction Novel', 1741.56, 'Books', 698, '{"format": "e-Book", "ISBN": "978-1-08-555583-8", "genre": "Fiction"}'),
('Body Lotion', 252.09, 'Beauty', 436, '{"skin_type": "Sensitive", "volume": "121ml", "fragrance": "Floral"}'),
('Eco-Friendly History Book', 9.38, 'Books', 457, '{"author": "Rebecca Hays", "pages": 789, "publisher": "Petersen Ltd", "language": "English"}'),
('Premium T-Shirt', 10.79, 'Fashion', 429, '{"size": "XL", "color": "teal", "material": "Silk"}'),
('Pro Body Lotion', 662.78, 'Beauty', 301, '{"skin_type": "Sensitive", "volume": "141ml", "fragrance": "Floral"}'),
('Advanced Summer Dress', 479.64, 'Fashion', 269, '{"care_instructions": "Machine Wash", "style": "Formal"}'),
('Training Shoes', 210.68, 'Footwear', 28, '{"closure": "Lace-up", "sole_material": "Rubber", "waterproof": true}'),
('Bedding Set', 296.57, 'Home & Garden', 903, '{"assembly_required": true, "weight_capacity": "421kg"}'),
('Decorative Vase', 82.83, 'Home & Garden', 437, '{"assembly_required": false, "weight_capacity": "388kg"}'),
('Cookware Set', 779.0, 'Home & Garden', 195, '{"dimensions": "185x79cm", "color": "aqua", "material": "Metal"}'),
('Face Serum', 51.81, 'Beauty', 485, '{"skin_type": "Sensitive", "volume": "35ml", "fragrance": "Floral"}'),
('Luxury Flip Flops', 458.82, 'Footwear', 949, '{"closure": "Velcro", "sole_material": "EVA", "waterproof": false}'),
('Garden Chair', 55.01, 'Home & Garden', 417, '{"dimensions": "176x46cm", "color": "teal", "material": "Ceramic"}'),
('Eco-Friendly Decorative Vase', 58.23, 'Home & Garden', 24, '{"assembly_required": true, "weight_capacity": "102kg"}'),
('Advanced Sunscreen', 60.6, 'Beauty', 430, '{"skin_type": "Dry", "volume": "231ml", "fragrance": "Unscented"}'),
('Garden Chair', 10.46, 'Home & Garden', 428, '{"dimensions": "73x72cm", "color": "yellow", "material": "Metal"}'),
('Pro External SSD', 652.14, 'Electronics', 266, '{"RAM": "4GB", "storage": "1000GB SSD", "screen_size": "15.6 inch"}'),
('Smart Garden Chair', 30.77, 'Home & Garden', 29, '{"assembly_required": true, "weight_capacity": "397kg"}'),
('Flip Flops', 533.48, 'Footwear', 176, '{"size": "39", "color": "White", "material": "Synthetic"}'),
('Bedding Set', 640.6, 'Home & Garden', 301, '{"assembly_required": false, "weight_capacity": "406kg"}'),
('Summer Dress', 16.34, 'Fashion', 152, '{"care_instructions": "Machine Wash", "style": "Vintage"}'),
('Wall Clock', 1054.48, 'Home & Garden', 307, '{"dimensions": "112x45cm", "color": "fuchsia", "material": "Ceramic"}'),
('Wireless Shorts', 980.26, 'Fashion', 433, '{"size": "S", "color": "green", "material": "Wool"}'),
('Sweater', 57.18, 'Fashion', 769, '{"size": "XL", "color": "green", "material": "Cotton"}'),
('Wireless Headphones', 174.4, 'Electronics', 486, '{"color": "Blue", "battery_life": "21h", "weight": "801g"}'),
('Running Shoes', 417.69, 'Footwear', 481, '{"closure": "Slip-on", "sole_material": "Rubber", "waterproof": false}'),
('Luxury Hair Conditioner', 16.87, 'Beauty', 375, '{"skin_type": "All", "volume": "223ml", "fragrance": "Floral"}'),
('Pro Storage Cabinet', 149.26, 'Home & Garden', 79, '{"assembly_required": true, "weight_capacity": "337kg"}'),
('Poetry Collection', 57.12, 'Books', 175, '{"format": "Paperback", "ISBN": "978-1-207-36232-0", "genre": "Fiction"}'),
('Eco-Friendly Fitness Tracker', 44.39, 'Electronics', 206, '{"RAM": "8GB", "storage": "128GB HDD", "screen_size": "15.6 inch"}'),
('Luxury Shampoo', 69.25, 'Beauty', 353, '{"organic": false, "cruelty_free": true}'),
('Coffee Table', 98.28, 'Home & Garden', 760, '{"dimensions": "54x186cm", "color": "silver", "material": "Plastic"}'),
('Tool Kit', 39.71, 'Home & Garden', 523, '{"assembly_required": false, "weight_capacity": "317kg"}'),
('Lipstick', 187.31, 'Beauty', 534, '{"skin_type": "Sensitive", "volume": "444ml", "fragrance": "Citrus"}'),
('Sunscreen', 669.23, 'Beauty', 48, '{"organic": false, "cruelty_free": false}'),
('Running Shoes', 58.81, 'Footwear', 260, '{"closure": "Velcro", "sole_material": "EVA", "waterproof": true}'),
('External SSD', 20.16, 'Electronics', 237, '{"RAM": "4GB", "storage": "512GB SSD", "screen_size": "17.3 inch"}'),
('Dress Shirt', 57.63, 'Fashion', 11, '{"care_instructions": "Dry Clean Only", "style": "Formal"}'),
('Formal Oxfords', 80.03, 'Footwear', 290, '{"size": "41", "color": "White", "material": "Canvas"}'),
('Sunscreen', 597.35, 'Beauty', 552, '{"organic": false, "cruelty_free": false}'),
('Advanced Hair Conditioner', 761.95, 'Beauty', 37, '{"skin_type": "Sensitive", "volume": "136ml", "fragrance": "Citrus"}'),
('Smart Portable Speaker', 93.65, 'Electronics', 490, '{"resolution": "HD", "connectivity": "USB-C", "processor": "Apple M1"}'),
('Training Shoes', 85.53, 'Footwear', 197, '{"closure": "Slip-on", "sole_material": "PU", "waterproof": false}'),
('Mechanical Keyboard', 1915.87, 'Electronics', 963, '{"color": "Black", "battery_life": "21h", "weight": "301g"}'),
('Portable Speaker', 202.81, 'Electronics', 210, '{"color": "Blue", "battery_life": "45h", "weight": "325g"}'),
('Formal Oxfords', 236.68, 'Footwear', 121, '{"size": "38", "color": "Black", "material": "Canvas"}'),
('Casual Sneakers', 14.11, 'Footwear', 18, '{"closure": "Lace-up", "sole_material": "PU", "waterproof": false}'),
('Training Shoes', 709.54, 'Footwear', 748, '{"closure": "Lace-up", "sole_material": "Rubber", "waterproof": false}'),
('Smart Storage Cabinet', 206.42, 'Home & Garden', 184, '{"assembly_required": false, "weight_capacity": "194kg"}'),
('Moisturizer', 28.22, 'Beauty', 187, '{"organic": false, "cruelty_free": true}'),
('Flip Flops', 5.26, 'Footwear', 278, '{"closure": "Slip-on", "sole_material": "PU", "waterproof": false}'),
('Shampoo', 83.13, 'Beauty', 208, '{"organic": false, "cruelty_free": true}'),
('Bedding Set', 424.67, 'Home & Garden', 190, '{"assembly_required": true, "weight_capacity": "37kg"}'),
('Sunscreen', 203.79, 'Beauty', 260, '{"skin_type": "Oily", "volume": "115ml", "fragrance": "Woody"}'),
('Premium Casual Sneakers', 212.58, 'Footwear', 811, '{"size": "47", "color": "Black", "material": "Canvas"}'),
('Advanced Tool Kit', 8.58, 'Home & Garden', 390, '{"assembly_required": true, "weight_capacity": "113kg"}'),
('Sunscreen', 213.3, 'Beauty', 700, '{"skin_type": "Sensitive", "volume": "362ml", "fragrance": "Woody"}'),
('Training Shoes', 390.74, 'Footwear', 557, '{"closure": "Velcro", "sole_material": "PU", "waterproof": false}'),
('Sandals', 21.71, 'Footwear', 79, '{"size": "45", "color": "Blue", "material": "Canvas"}'),
('Sweater', 25.19, 'Fashion', 858, '{"size": "S", "color": "white", "material": "Wool"}'),
('Perfume', 926.61, 'Beauty', 65, '{"organic": false, "cruelty_free": false}'),
('Mechanical Keyboard', 481.54, 'Electronics', 856, '{"resolution": "FHD", "connectivity": "Bluetooth 5.0", "processor": "AMD Ryzen 7"}'),
('T-Shirt', 28.37, 'Fashion', 62, '{"size": "L", "color": "fuchsia", "material": "Silk"}'),
('Flip Flops', 15.43, 'Footwear', 208, '{"closure": "Lace-up", "sole_material": "PU", "waterproof": false}'),
('Sweater', 79.42, 'Fashion', 852, '{"care_instructions": "Dry Clean Only", "style": "Vintage"}'),
('Running Shoes', 98.84, 'Footwear', 166, '{"closure": "Lace-up", "sole_material": "EVA", "waterproof": false}'),
('Bluetooth Earbuds', 1280.19, 'Electronics', 58, '{"color": "Silver", "battery_life": "29h", "weight": "671g"}'),
('Jeans', 44.47, 'Fashion', 294, '{"care_instructions": "Dry Clean Only", "style": "Formal"}'),
('Casual Sneakers', 99.58, 'Footwear', 216, '{"closure": "Velcro", "sole_material": "PU", "waterproof": true}'),
('Bluetooth Earbuds', 89.83, 'Electronics', 866, '{"resolution": "FHD", "connectivity": "USB-C", "processor": "Intel i5"}'),
('Cookbook', 316.75, 'Books', 965, '{"author": "Peter Powell", "pages": 505, "publisher": "Scott-Daniel", "language": "English"}'),
('Body Lotion', 613.76, 'Beauty', 74, '{"organic": false, "cruelty_free": true}'),
('Cookbook', 319.69, 'Books', 842, '{"format": "Hardcover", "ISBN": "978-0-18-248363-1", "genre": "Fiction"}'),
('Formal Oxfords', 72.26, 'Footwear', 292, '{"size": "44", "color": "White", "material": "Mesh"}'),
('Advanced Summer Dress', 48.6, 'Fashion', 915, '{"size": "L", "color": "maroon", "material": "Wool"}'),
('External SSD', 979.05, 'Electronics', 473, '{"color": "Silver", "battery_life": "34h", "weight": "137g"}'),
('Shampoo', 10.01, 'Beauty', 215, '{"organic": false, "cruelty_free": false}'),
('Cookbook', 141.97, 'Books', 527, '{"author": "Logan Wolf", "pages": 589, "publisher": "Hunter, Garcia and Castro", "language": "English"}'),
('Hair Conditioner', 477.87, 'Beauty', 741, '{"organic": false, "cruelty_free": true}'),
('Childrens Book', 251.99, 'Books', 15, '{"author": "Judith Shaw", "pages": 685, "publisher": "Stuart PLC", "language": "English"}'),
('Lipstick', 363.57, 'Beauty', 571, '{"skin_type": "All", "volume": "453ml", "fragrance": "Floral"}'),
('Dress Shoes', 158.09, 'Footwear', 163, '{"closure": "Velcro", "sole_material": "Rubber", "waterproof": true}'),
('Shampoo', 31.94, 'Beauty', 280, '{"skin_type": "All", "volume": "105ml", "fragrance": "Citrus"}'),
('Cookware Set', 378.95, 'Home & Garden', 566, '{"assembly_required": false, "weight_capacity": "156kg"}'),
('Programming Textbook', 121.93, 'Books', 904, '{"format": "Paperback", "ISBN": "978-1-80888-438-2", "genre": "Non-Fiction"}'),
('Programming Textbook', 64.07, 'Books', 375, '{"author": "Kelly Buchanan", "pages": 624, "publisher": "Strickland Inc", "language": "English"}'),
('Eco-Friendly Fitness Tracker', 76.92, 'Electronics', 381, '{"resolution": "FHD", "connectivity": "Bluetooth 5.0", "processor": "AMD Ryzen 7"}'),
('Wireless Jacket', 41.2, 'Fashion', 899, '{"size": "L", "color": "fuchsia", "material": "Silk"}'),
('Cookbook', 242.49, 'Books', 216, '{"author": "Mario Hayes", "pages": 728, "publisher": "Moore-Garcia", "language": "English"}'),
('Wireless Sunscreen', 195.19, 'Beauty', 194, '{"organic": true, "cruelty_free": true}'),
('Bluetooth Earbuds', 35.63, 'Electronics', 56, '{"resolution": "4K", "connectivity": "Wi-Fi 6", "processor": "Apple M1"}'),
('Running Shoes', 230.13, 'Footwear', 301, '{"closure": "Velcro", "sole_material": "EVA", "waterproof": false}'),
('Casual Sneakers', 543.68, 'Footwear', 421, '{"size": "45", "color": "Blue", "material": "Canvas"}'),
('Cookware Set', 476.2, 'Home & Garden', 390, '{"assembly_required": false, "weight_capacity": "9kg"}'),
('Smart Portable Speaker', 17.45, 'Electronics', 390, '{"RAM": "8GB", "storage": "128GB HDD", "screen_size": "15.6 inch"}'),
('Self-Help Guide', 196.73, 'Books', 64, '{"author": "Rhonda Sweeney", "pages": 452, "publisher": "Li, Meza and Brown", "language": "English"}'),
('Running Shoes', 31.15, 'Footwear', 64, '{"size": "41", "color": "Red", "material": "Mesh"}'),
('Fitness Tracker', 342.36, 'Electronics', 55, '{"RAM": "32GB", "storage": "128GB SSD", "screen_size": "15.6 inch"}'),
('Hair Conditioner', 314.48, 'Beauty', 34, '{"skin_type": "Sensitive", "volume": "354ml", "fragrance": "Woody"}'),
('Storage Cabinet', 1005.15, 'Home & Garden', 917, '{"assembly_required": true, "weight_capacity": "138kg"}'),
('Smart Biography', 413.95, 'Books', 599, '{"format": "e-Book", "ISBN": "978-1-971699-94-3", "genre": "Fiction"}'),
('Wireless Childrens Book', 819.58, 'Books', 290, '{"author": "Megan Nelson", "pages": 503, "publisher": "Le, Hahn and Turner", "language": "English"}'),
('Wireless Headphones', 66.32, 'Electronics', 699, '{"RAM": "32GB", "storage": "256GB SSD", "screen_size": "17.3 inch"}'),
('Flip Flops', 345.81, 'Footwear', 391, '{"closure": "Lace-up", "sole_material": "Rubber", "waterproof": false}'),
('Poetry Collection', 11.93, 'Books', 535, '{"format": "Hardcover", "ISBN": "978-0-9763998-5-8", "genre": "Non-Fiction"}'),
('Hair Conditioner', 38.33, 'Beauty', 715, '{"skin_type": "Oily", "volume": "259ml", "fragrance": "Woody"}'),
('Cookbook', 98.86, 'Books', 193, '{"author": "Mark Hill", "pages": 159, "publisher": "Thomas, Marquez and Perry", "language": "English"}'),
('Fitness Tracker', 90.84, 'Electronics', 435, '{"color": "White", "battery_life": "26h", "weight": "346g"}'),
('Wall Clock', 79.67, 'Home & Garden', 993, '{"assembly_required": true, "weight_capacity": "387kg"}'),
('Skirt', 1715.12, 'Fashion', 789, '{"care_instructions": "Dry Clean Only", "style": "Vintage"}'),
('Premium Coffee Table', 511.78, 'Home & Garden', 104, '{"dimensions": "170x100cm", "color": "blue", "material": "Ceramic"}'),
('Wireless Storage Cabinet', 588.05, 'Home & Garden', 373, '{"assembly_required": false, "weight_capacity": "494kg"}'),
('Eco-Friendly Gaming Mouse', 1816.92, 'Electronics', 258, '{"color": "Silver", "battery_life": "29h", "weight": "226g"}'),
('E-Reader', 28.35, 'Electronics', 176, '{"color": "White", "battery_life": "41h", "weight": "748g"}'),
('Programming Textbook', 431.67, 'Books', 633, '{"author": "Charles Willis", "pages": 264, "publisher": "Harris-Young", "language": "English"}'),
('History Book', 29.35, 'Books', 366, '{"format": "Paperback", "ISBN": "978-0-86650-578-9", "genre": "Non-Fiction"}'),
('Shampoo', 85.73, 'Beauty', 68, '{"organic": true, "cruelty_free": false}'),
('Business Strategy', 720.1, 'Books', 261, '{"author": "Andrew Clements", "pages": 389, "publisher": "Mcdonald, Williams and Garcia", "language": "English"}'),
('Bluetooth Earbuds', 87.25, 'Electronics', 406, '{"RAM": "16GB", "storage": "128GB SSD", "screen_size": "15.6 inch"}'),
('Dress Shirt', 482.45, 'Fashion', 85, '{"care_instructions": "Machine Wash", "style": "Modern"}'),
('Hiking Boots', 223.98, 'Footwear', 429, '{"closure": "Lace-up", "sole_material": "EVA", "waterproof": false}'),
('Advanced Casual Sneakers', 389.73, 'Footwear', 334, '{"size": "41", "color": "Blue", "material": "Synthetic"}'),
('History Book', 910.69, 'Books', 40, '{"format": "e-Book", "ISBN": "978-1-67776-799-1", "genre": "Fiction"}'),
('Advanced Sunscreen', 671.68, 'Beauty', 635, '{"organic": false, "cruelty_free": false}'),
('Programming Textbook', 69.72, 'Books', 395, '{"author": "Anthony Fisher", "pages": 237, "publisher": "Owens Group", "language": "English"}'),
('Sunscreen', 35.51, 'Beauty', 254, '{"skin_type": "Sensitive", "volume": "76ml", "fragrance": "Citrus"}'),
('Eco-Friendly Running Shoes', 382.44, 'Footwear', 477, '{"size": "46", "color": "Red", "material": "Mesh"}'),
('Storage Cabinet', 311.21, 'Home & Garden', 156, '{"dimensions": "162x180cm", "color": "green", "material": "Ceramic"}'),
('Storage Cabinet', 66.41, 'Home & Garden', 686, '{"dimensions": "89x78cm", "color": "black", "material": "Metal"}'),
('Mechanical Keyboard', 898.7, 'Electronics', 568, '{"color": "White", "battery_life": "17h", "weight": "738g"}'),
('Sunscreen', 300.13, 'Beauty', 308, '{"skin_type": "Sensitive", "volume": "299ml", "fragrance": "Woody"}'),
('Sweater', 979.69, 'Fashion', 415, '{"size": "S", "color": "lime", "material": "Wool"}'),
('Luxury Garden Chair', 295.85, 'Home & Garden', 466, '{"assembly_required": true, "weight_capacity": "208kg"}'),
('Wireless E-Reader', 88.32, 'Electronics', 568, '{"RAM": "4GB", "storage": "512GB SSD", "screen_size": "13.3 inch"}'),
('Luxury Face Serum', 14.41, 'Beauty', 186, '{"skin_type": "Oily", "volume": "390ml", "fragrance": "Woody"}'),
('Mechanical Keyboard', 340.88, 'Electronics', 968, '{"color": "Black", "battery_life": "15h", "weight": "88g"}'),
('Business Strategy', 40.19, 'Books', 345, '{"author": "Dana Stevens", "pages": 217, "publisher": "Martin-Dean", "language": "English"}'),
('Eco-Friendly Biography', 66.32, 'Books', 175, '{"format": "Paperback", "ISBN": "978-0-87210-382-5", "genre": "Non-Fiction"}'),
('Shorts', 34.22, 'Fashion', 32, '{"care_instructions": "Machine Wash", "style": "Vintage"}'),
('Advanced Shorts', 300.27, 'Fashion', 458, '{"care_instructions": "Machine Wash", "style": "Modern"}'),
('Basketball Shoes', 51.1, 'Footwear', 365, '{"size": "42", "color": "White", "material": "Canvas"}'),
('Jacket', 252.64, 'Fashion', 416, '{"size": "M", "color": "purple", "material": "Polyester"}'),
('Hair Conditioner', 234.86, 'Beauty', 855, '{"skin_type": "Dry", "volume": "326ml", "fragrance": "Citrus"}'),
('Jacket', 239.03, 'Fashion', 562, '{"care_instructions": "Machine Wash", "style": "Formal"}'),
('Fitness Tracker', 869.15, 'Electronics', 197, '{"color": "Blue", "battery_life": "40h", "weight": "623g"}'),
('T-Shirt', 240.63, 'Fashion', 36, '{"care_instructions": "Machine Wash", "style": "Casual"}'),
('Premium Lipstick', 37.88, 'Beauty', 598, '{"skin_type": "All", "volume": "120ml", "fragrance": "Woody"}'),
('Casual Sneakers', 39.28, 'Footwear', 331, '{"size": "38", "color": "Gray", "material": "Mesh"}'),
('Luxury Sweater', 74.86, 'Fashion', 286, '{"care_instructions": "Dry Clean Only", "style": "Formal"}'),
('Wireless Headphones', 789.69, 'Electronics', 985, '{"color": "Blue", "battery_life": "16h", "weight": "50g"}'),
('Summer Dress', 19.46, 'Fashion', 427, '{"size": "XL", "color": "lime", "material": "Wool"}'),
('Sunscreen', 72.16, 'Beauty', 819, '{"skin_type": "Sensitive", "volume": "302ml", "fragrance": "Citrus"}'),
('Pro Cookware Set', 360.45, 'Home & Garden', 794, '{"assembly_required": false, "weight_capacity": "467kg"}'),
('Fitness Tracker', 229.33, 'Electronics', 18, '{"resolution": "FHD", "connectivity": "Wi-Fi 6", "processor": "AMD Ryzen 7"}'),
('Cookbook', 295.99, 'Books', 109, '{"author": "Eric Martin", "pages": 696, "publisher": "Kelley, Dixon and King", "language": "English"}'),
('Dress Shoes', 1898.23, 'Footwear', 145, '{"size": "37", "color": "Black", "material": "Mesh"}'),
('Jacket', 26.14, 'Fashion', 482, '{"size": "XL", "color": "gray", "material": "Wool"}'),
('Advanced Flip Flops', 3.87, 'Footwear', 125, '{"size": "44", "color": "Blue", "material": "Leather"}'),
('Business Strategy', 10.2, 'Books', 160, '{"author": "Brenda Terry", "pages": 190, "publisher": "Mitchell Group", "language": "English"}'),
('Makeup Kit', 70.9, 'Beauty', 190, '{"organic": false, "cruelty_free": true}'),
('Wireless Cookware Set', 452.63, 'Home & Garden', 206, '{"dimensions": "166x36cm", "color": "purple", "material": "Wood"}'),
('Garden Chair', 60.37, 'Home & Garden', 882, '{"dimensions": "158x134cm", "color": "yellow", "material": "Plastic"}'),
('Sandals', 1542.38, 'Footwear', 32, '{"size": "37", "color": "Black", "material": "Leather"}'),
('Gaming Mouse', 56.65, 'Electronics', 481, '{"resolution": "HD", "connectivity": "Wi-Fi 6", "processor": "Intel i5"}'),
('Smart Desk Lamp', 1608.23, 'Home & Garden', 231, '{"dimensions": "184x94cm", "color": "purple", "material": "Metal"}'),
('Jacket', 96.64, 'Fashion', 336, '{"care_instructions": "Dry Clean Only", "style": "Formal"}'),
('Wireless Coffee Table', 614.29, "Home & Garden", 460, '{"dimensions": "75x155cm", "color": "green", "material": "Plastic"}');


INSERT INTO orders (customer_id, order_date, total_amount, status, shipping_address, metadata)
VALUES
(149, '2025-02-20', 1106.3, 'Cancelled', '{"street": "181 Ibrahim Taiwo", "city": "Kaduna", "zip": "800001"}', '{"source": "desktop", "coupon": "FREESHIP"}'),
(188, '2025-02-10', 27595.87, 'Delivered', '{"street": "7 Ahmadu Bello Way", "city": "Kano", "zip": "700001"}', '{"source": "mobile"}'),
(90, '2025-06-25', 7153.79, 'Pending', '{"street": "139 Emeka Anyaoku", "city": "Port Harcourt", "zip": "500001"}', '{"source": "mobile", "coupon": "NEWUSER25"}'),
(82, '2025-04-07', 59237.03, 'Shipped', '{"street": "187 Murtala Mohammed", "city": "Ibadan", "zip": "200001"}', '{"source": "tablet", "gift_wrap": true, "coupon": "SUMMER20"}'),
(123, '2025-03-14', 7347.7, 'Shipped', '{"street": "95 Aminu Kano", "city": "Lagos", "zip": "100001"}', '{"source": "mobile", "gift_wrap": true, "coupon": "WINTER30"}'),
(23, '2025-06-09', 27513.79, 'Delivered', '{"street": "44 Nnamdi Azikiwe", "city": "Aba", "zip": "450001"}', '{"source": "mobile", "gift_wrap": true, "coupon": "SAVE15"}'),
(39, '2025-04-11', 18528.82, 'Pending', '{"street": "69 Emeka Anyaoku", "city": "Kano", "zip": "700001"}', '{"source": "desktop", "coupon": "WELCOME10"}'),
(91, '2025-03-08', 5990.14, 'Pending', '{"street": "92 Murtala Mohammed", "city": "Abuja", "zip": "900001"}', '{"source": "tablet", "coupon": "WELCOME10"}'),
(115, '2025-01-04', 227273.11, 'Shipped', '{"street": "97 Marina Road", "city": "Zaria", "zip": "810001"}', '{"source": "mobile", "coupon": "SUMMER20"}'),
(167, '2025-06-05', 9162.66, 'Shipped', '{"street": "11 Anthony Enahoro", "city": "Abuja", "zip": "900001"}', '{"source": "tablet", "coupon": "NEWUSER25"}'),
(24, '2025-02-12', 140294.08, 'Delivered', '{"street": "150 Emeka Anyaoku", "city": "Ibadan", "zip": "200001"}', '{"source": "desktop", "coupon": "NEWUSER25"}'),
(94, '2025-02-10', 4995.55, 'Processing', '{"street": "154 Nnamdi Azikiwe", "city": "Kano", "zip": "700001"}', '{"source": "tablet", "coupon": "WINTER30"}'),
(184, '2025-02-20', 7851.02, 'Pending', '{"street": "150 Nnamdi Azikiwe", "city": "Kano", "zip": "700001"}', '{"source": "tablet", "coupon": "SAVE15", "notes": "Handle with care"}'),
(63, '2025-02-22', 48253.52, 'Delivered', '{"street": "190 Ibrahim Taiwo", "city": "Abuja", "zip": "900001"}', '{"source": "mobile", "coupon": "SAVE15"}'),
(176, '2025-06-09', 47841.55, 'Shipped', '{"street": "73 Adetokunbo Ademola", "city": "Lagos", "zip": "100001"}', '{"source": "mobile", "notes": "Don''t ring doorbell"}'),
(101, '2025-02-25', 3963.39, 'Processing', '{"street": "166 Yakubu Gowon", "city": "Benin City", "zip": "300001"}', '{"source": "desktop", "gift_wrap": true, "coupon": "SAVE15"}'),
(167, '2025-02-23', 6507.51, 'Delivered', '{"street": "166 Yakubu Gowon", "city": "Kaduna", "zip": "800001"}', '{"source": "desktop", "coupon": "FREESHIP"}'),
(159, '2025-02-17', 6249.14, 'Shipped', '{"street": "40 Adetokunbo Ademola", "city": "Port Harcourt", "zip": "500001"}', '{"source": "desktop", "coupon": "WINTER30"}'),
(175, '2025-04-10', 214265.12, 'Pending', '{"street": "129 Obafemi Awolowo", "city": "Ibadan", "zip": "200001"}', '{"source": "desktop", "gift_wrap": true, "coupon": "FREESHIP"}'),
(194, '2025-04-15', 9576.66, 'Processing', '{"street": "63 Obafemi Awolowo", "city": "Kano", "zip": "700001"}', '{"source": "desktop", "coupon": "SUMMER20"}'),
(128, '2025-01-01', 4458.16, 'Shipped', '{"street": "48 Sultan Abubakar", "city": "Ibadan", "zip": "200001"}', '{"source": "desktop", "notes": "Call before delivery"}'),
(131, '2025-06-10', 16553.6, 'Delivered', '{"street": "74 Ahmadu Bello Way", "city": "Kano", "zip": "700001"}', '{"source": "tablet", "coupon": "FREESHIP"}'),
(127, '2025-07-02', 28067.02, 'Shipped', '{"street": "63 Anthony Enahoro", "city": "Lagos", "zip": "100001"}', '{"source": "mobile", "coupon": "NEWUSER25", "notes": "Leave at front desk"}'),
(89, '2025-04-24', 7585.15, 'Delivered', '{"street": "98 Ahmadu Bello Way", "city": "Benin City", "zip": "300001"}', '{"source": "desktop", "coupon": "WINTER30"}'),
(12, '2025-04-22', 39482.38, 'Shipped', '{"street": "83 Murtala Mohammed", "city": "Port Harcourt", "zip": "500001"}', '{"source": "desktop", "coupon": "FREESHIP"}'),
(125, '2025-04-20', 2760.29, 'Cancelled', '{"street": "55 Adetokunbo Ademola", "city": "Ibadan", "zip": "200001"}', '{"source": "tablet", "gift_wrap": true, "coupon": "NEWUSER25"}'),
(106, '2025-06-11', 34536.55, 'Pending', '{"street": "69 Olusegun Obasanjo", "city": "Aba", "zip": "450001"}', '{"source": "desktop", "coupon": "FREESHIP"}'),
(101, '2025-01-09', 7412.02, 'Shipped', '{"street": "186 Adetokunbo Ademola", "city": "Kano", "zip": "700001"}', '{"source": "mobile", "coupon": "SAVE15"}'),
(178, '2025-03-07', 4375.36, 'Pending', '{"street": "86 Samuel Ladoke Akintola", "city": "Abuja", "zip": "900001"}', '{"source": "mobile", "gift_wrap": true, "coupon": "WELCOME10"}'),
(20, '2025-04-02', 9148.03, 'Shipped', '{"street": "42 Awolowo Road", "city": "Maiduguri", "zip": "600001"}', '{"source": "desktop", "gift_wrap": true}'),
(3, '2025-05-14', 25517.42, 'Processing', '{"street": "142 Aminu Kano", "city": "Lagos", "zip": "100001"}', '{"source": "desktop"}'),
(104, '2025-05-15', 9971.31, 'Shipped', '{"street": "60 Olusegun Obasanjo", "city": "Kano", "zip": "700001"}', '{"source": "mobile", "coupon": "WELCOME10"}'),
(153, '2025-04-04', 17010.78, 'Pending', '{"street": "93 Sultan Abubakar", "city": "Benin City", "zip": "300001"}', '{"source": "tablet"}'),
(19, '2025-06-24', 2266.18, 'Cancelled', '{"street": "9 Michael Okpara", "city": "Maiduguri", "zip": "600001"}', '{"source": "desktop", "gift_wrap": true}'),
(129, '2025-01-31', 77148.22, 'Pending', '{"street": "2 Ibrahim Taiwo", "city": "Abuja", "zip": "900001"}', '{"source": "mobile", "coupon": "WELCOME10"}'),
(196, '2025-03-17', 3111.44, 'Processing', '{"street": "167 Obafemi Awolowo", "city": "Kano", "zip": "700001"}', '{"source": "mobile", "coupon": "SAVE15"}'),
(35, '2025-04-08', 44152.63, 'Delivered', '{"street": "9 Allen Avenue", "city": "Maiduguri", "zip": "600001"}', '{"source": "mobile"}'),
(111, '2025-02-11', 8869.96, 'Pending', '{"street": "16 Ibrahim Taiwo", "city": "Abuja", "zip": "900001"}', '{"source": "mobile", "coupon": "NEWUSER25"}'),
(186, '2025-03-04', 214470.14, 'Shipped', '{"street": "118 Emeka Anyaoku", "city": "Aba", "zip": "450001"}', '{"source": "tablet", "coupon": "SUMMER20"}'),
(113, '2025-02-12', 2738.55, 'Delivered', '{"street": "106 Olusegun Obasanjo", "city": "Zaria", "zip": "810001"}', '{"source": "mobile", "coupon": "SUMMER20"}'),
(66, '2025-01-04', 2221.27, 'Shipped', '{"street": "65 Oduduwa", "city": "Lagos", "zip": "100001"}', '{"source": "tablet"}'),
(87, '2025-04-28', 1416.49, 'Processing', '{"street": "114 Allen Avenue", "city": "Kaduna", "zip": "800001"}', '{"source": "mobile"}'),
(57, '2025-02-12', 7470.33, 'Shipped', '{"street": "98 Nnamdi Azikiwe", "city": "Port Harcourt", "zip": "500001"}', '{"source": "tablet", "coupon": "FREESHIP", "notes": "Call before delivery"}'),
(159, '2025-05-10', 4590.78, 'Processing', '{"street": "10 Olusegun Obasanjo", "city": "Aba", "zip": "450001"}', '{"source": "mobile", "coupon": "WINTER30", "notes": "Birthday present"}'),
(89, '2025-02-28', 9241.51, 'Processing', '{"street": "61 Obafemi Awolowo", "city": "Port Harcourt", "zip": "500001"}', '{"source": "desktop", "coupon": "WINTER30"}'),
(166, '2025-03-13', 32752.65, 'Processing', '{"street": "16 Allen Avenue", "city": "Ibadan", "zip": "200001"}', '{"source": "desktop", "coupon": "SUMMER20"}'),
(95, '2025-05-21', 6465.36, 'Delivered', '{"street": "15 Adekunle Fajuyi", "city": "Abuja", "zip": "900001"}', '{"source": "mobile", "coupon": "WELCOME10"}'),
(121, '2025-02-20', 3546.35, 'Cancelled', '{"street": "175 Adetokunbo Ademola", "city": "Abuja", "zip": "900001"}', '{"source": "mobile"}'),
(108, '2025-03-16', 41168.03, 'Shipped', '{"street": "89 Oduduwa", "city": "Zaria", "zip": "810001"}', '{"source": "tablet", "coupon": "NEWUSER25"}'),
(73, '2025-05-28', 1640.3, 'Delivered', '{"street": "99 Ahmadu Bello Way", "city": "Aba", "zip": "450001"}', '{"source": "tablet", "gift_wrap": true, "coupon": "NEWUSER25"}'),
(187, '2025-05-30', 25551.46, 'Shipped', '{"street": "75 Adekunle Fajuyi", "city": "Aba", "zip": "450001"}', '{"source": "desktop", "coupon": "NEWUSER25"}'),
(115, '2025-03-17', 111607.77, 'Shipped', '{"street": "132 Sultan Abubakar", "city": "Kaduna", "zip": "800001"}', '{"source": "tablet", "coupon": "SAVE15"}'),
(136, '2025-02-06', 9424.69, 'Shipped', '{"street": "146 Samuel Ladoke Akintola", "city": "Port Harcourt", "zip": "500001"}', '{"source": "mobile", "coupon": "SUMMER20"}'),
(109, '2025-03-19', 1467.29, 'Delivered', '{"street": "182 Marina Road", "city": "Port Harcourt", "zip": "500001"}', '{"source": "tablet", "coupon": "NEWUSER25"}'),
(111, '2025-01-12', 37808.69, 'Delivered', '{"street": "97 Michael Okpara", "city": "Benin City", "zip": "300001"}', '{"source": "mobile", "coupon": "WELCOME10"}'),
(115, '2025-06-08', 34676.57, 'Pending', '{"street": "47 Emeka Anyaoku", "city": "Lagos", "zip": "100001"}', '{"source": "mobile", "gift_wrap": true, "coupon": "WINTER30", "notes": "Call before delivery"}'),
(142, '2025-03-19', 2621.33, 'Shipped', '{"street": "104 Nnamdi Azikiwe", "city": "Port Harcourt", "zip": "500001"}', '{"source": "mobile", "gift_wrap": true, "coupon": "FREESHIP"}'),
(79, '2025-06-11', 72251.41, 'Delivered', '{"street": "153 Awolowo Road", "city": "Benin City", "zip": "300001"}', '{"source": "tablet", "coupon": "NEWUSER25"}'),
(97, '2025-01-21', 2114.18, 'Pending', '{"street": "122 Obafemi Awolowo", "city": "Abuja", "zip": "900001"}', '{"source": "desktop", "gift_wrap": true, "coupon": "NEWUSER25"}'),
(102, '2025-04-18', 5405.1, 'Pending', '{"street": "22 Aminu Kano", "city": "Ibadan", "zip": "200001"}', '{"source": "desktop", "gift_wrap": true}'),
(24, '2025-04-13', 55056.27, 'Shipped', '{"street": "191 Adekunle Fajuyi", "city": "Ibadan", "zip": "200001"}', '{"source": "mobile", "coupon": "NEWUSER25"}'),
(193, '2025-01-18', 2604.22, 'Pending', '{"street": "81 Nnamdi Azikiwe", "city": "Maiduguri", "zip": "600001"}', '{"source": "tablet", "coupon": "NEWUSER25"}'),
(171, '2025-02-22', 34729.26, 'Delivered', '{"street": "20 Adetokunbo Ademola", "city": "Port Harcourt", "zip": "500001"}', '{"source": "tablet", "gift_wrap": true, "coupon": "WELCOME10"}'),
(110, '2025-01-05', 51460.65, 'Processing', '{"street": "150 Awolowo Road", "city": "Zaria", "zip": "810001"}', '{"source": "mobile", "coupon": "SUMMER20"}'),
(200, '2025-04-26', 4026.09, 'Processing', '{"street": "33 Adekunle Fajuyi", "city": "Abuja", "zip": "900001"}', '{"source": "tablet", "coupon": "FREESHIP"}'),
(28, '2025-01-27', 16681.21, 'Shipped', '{"street": "193 Olusegun Obasanjo", "city": "Lagos", "zip": "100001"}', '{"source": "desktop", "coupon": "FREESHIP"}'),
(147, '2025-06-12', 5985.39, 'Delivered', '{"street": "8 Aminu Kano", "city": "Aba", "zip": "450001"}', '{"source": "mobile", "gift_wrap": true, "coupon": "NEWUSER25"}'),
(60, '2025-05-23', 23876.66, 'Delivered', '{"street": "165 Awolowo Road", "city": "Lagos", "zip": "100001"}', '{"source": "tablet", "coupon": "NEWUSER25"}'),
(18, '2025-05-02', 1721.46, 'Processing', '{"street": "70 Adekunle Fajuyi", "city": "Abuja", "zip": "900001"}', '{"source": "mobile", "coupon": "FREESHIP"}'),
(48, '2025-01-12', 43850.58, 'Pending', '{"street": "165 Obafemi Awolowo", "city": "Lagos", "zip": "100001"}', '{"source": "desktop", "gift_wrap": true, "coupon": "NEWUSER25"}'),
(79, '2025-03-09', 39422.73, 'Processing', '{"street": "74 Murtala Mohammed", "city": "Port Harcourt", "zip": "500001"}', '{"source": "tablet", "coupon": "WINTER30"}'),
(142, '2025-04-18', 6125.24, 'Processing', '{"street": "37 Murtala Mohammed", "city": "Abuja", "zip": "900001"}', '{"source": "mobile", "coupon": "WELCOME10"}'),
(80, '2025-04-20', 80389.44, 'Shipped', '{"street": "16 Aminu Kano", "city": "Lagos", "zip": "100001"}', '{"source": "desktop", "coupon": "WINTER30"}'),
(10, '2025-06-20', 1356.59, 'Pending', '{"street": "100 Obafemi Awolowo", "city": "Abuja", "zip": "900001"}', '{"source": "tablet", "gift_wrap": true, "coupon": "NEWUSER25"}'),
(141, '2025-02-16', 9261.46, 'Shipped', '{"street": "98 Allen Avenue", "city": "Zaria", "zip": "810001"}', '{"source": "tablet", "coupon": "WINTER30"}'),
(41, '2025-06-27', 17077.83, 'Shipped', '{"street": "32 Anthony Enahoro", "city": "Maiduguri", "zip": "600001"}', '{"source": "tablet", "coupon": "SUMMER20", "notes": "Signature required"}'),
(30, '2025-05-07', 5139.03, 'Delivered', '{"street": "105 Ahmadu Bello Way", "city": "Maiduguri", "zip": "600001"}', '{"source": "tablet", "coupon": "SAVE15"}'),
(168, '2025-04-12', 79028.84, 'Processing', '{"street": "113 Ibrahim Taiwo", "city": "Kaduna", "zip": "800001"}', '{"source": "mobile", "coupon": "SAVE15"}'),
(106, '2025-01-18', 12602.22, 'Pending', '{"street": "30 Murtala Mohammed", "city": "Maiduguri", "zip": "600001"}', '{"source": "mobile", "coupon": "SAVE15"}'),
(41, '2025-05-07', 7318.99, 'Shipped', '{"street": "163 Murtala Mohammed", "city": "Lagos", "zip": "100001"}', '{"source": "desktop", "coupon": "WINTER30"}'),
(141, '2025-04-25', 4063.67, 'Shipped', '{"street": "48 Awolowo Road", "city": "Lagos", "zip": "100001"}', '{"source": "mobile", "coupon": "NEWUSER25"}'),
(51, '2025-01-02', 27072.67, 'Pending', '{"street": "18 Ibrahim Taiwo", "city": "Maiduguri", "zip": "600001"}', '{"source": "mobile", "coupon": "FREESHIP"}'),
(29, '2025-03-30', 42084.7, 'Processing', '{"street": "65 Nnamdi Azikiwe", "city": "Maiduguri", "zip": "600001"}', '{"source": "mobile", "coupon": "SUMMER20", "notes": "Handle with care"}'),
(17, '2025-06-08', 83500.95, 'Delivered', '{"street": "34 Adetokunbo Ademola", "city": "Kaduna", "zip": "800001"}', '{"source": "tablet", "coupon": "WELCOME10"}'),
(137, '2025-03-02', 31082.07, 'Pending', '{"street": "146 Emeka Anyaoku", "city": "Maiduguri", "zip": "600001"}', '{"source": "mobile", "gift_wrap": true, "coupon": "WINTER30"}'),
(89, '2025-06-09', 5485.28, 'Processing', '{"street": "172 Olusegun Obasanjo", "city": "Maiduguri", "zip": "600001"}', '{"source": "desktop", "gift_wrap": true, "coupon": "WINTER30"}'),
(140, '2025-07-03', 249571.16, 'Shipped', '{"street": "197 Marina Road", "city": "Aba", "zip": "450001"}', '{"source": "mobile", "coupon": "WINTER30"}'),
(118, '2025-03-20', 55711.57, 'Delivered', '{"street": "54 Olusegun Obasanjo", "city": "Maiduguri", "zip": "600001"}', '{"source": "mobile", "gift_wrap": true, "coupon": "FREESHIP"}'),
(45, '2025-01-09', 31592.08, 'Processing', '{"street": "117 Anthony Enahoro", "city": "Zaria", "zip": "810001"}', '{"source": "tablet", "gift_wrap": true, "coupon": "WELCOME10"}'),
(70, '2025-01-09', 4960.15, 'Shipped', '{"street": "98 Obafemi Awolowo", "city": "Zaria", "zip": "810001"}', '{"source": "mobile", "gift_wrap": true, "coupon": "SAVE15"}'),
(97, '2025-01-22', 161078.09, 'Delivered', '{"street": "43 Allen Avenue", "city": "Port Harcourt", "zip": "500001"}', '{"source": "desktop", "coupon": "SUMMER20"}'),
(196, '2025-04-05', 9109.27, 'Cancelled', '{"street": "179 Awolowo Road", "city": "Aba", "zip": "450001"}', '{"source": "desktop", "coupon": "WELCOME10"}'),
(26, '2025-06-05', 137107.47, 'Shipped', '{"street": "126 Adekunle Fajuyi", "city": "Kaduna", "zip": "800001"}', '{"source": "mobile", "gift_wrap": true, "coupon": "WINTER30"}'),
(86, '2025-05-22', 4130.89, 'Shipped', '{"street": "107 Marina Road", "city": "Kano", "zip": "700001"}', '{"source": "tablet", "coupon": "SAVE15"}'),
(148, '2025-05-01', 6075.37, 'Shipped', '{"street": "46 Marina Road", "city": "Lagos", "zip": "100001"}', '{"source": "tablet", "gift_wrap": true}'),
(170, '2025-06-15', 6045.38, 'Delivered', '{"street": "40 Marina Road", "city": "Zaria", "zip": "810001"}', '{"source": "tablet", "coupon": "SAVE15"}'),
(69, '2025-02-02', 168296.61, 'Processing', '{"street": "76 Samuel Ladoke Akintola", "city": "Zaria", "zip": "810001"}', '{"source": "desktop", "gift_wrap": true}'),
(10, '2025-06-03', 9270.7, 'Shipped', '{"street": "36 Obafemi Awolowo", "city": "Ibadan", "zip": "200001"}', '{"source": "desktop", "coupon": "FREESHIP"}'),
(26, '2025-05-10', 236946.72, 'Pending', '{"street": "95 Obafemi Awolowo", "city": "Port Harcourt", "zip": "500001"}', '{"source": "mobile", "coupon": "WELCOME10"}'),
(111, '2025-06-17', 8843.83, 'Delivered', '{"street": "17 Obafemi Awolowo", "city": "Port Harcourt", "zip": "500001"}', '{"source": "desktop", "coupon": "WINTER30"}'),
(106, '2025-03-13', 10450.25, 'Shipped', '{"street": "119 Awolowo Road", "city": "Ibadan", "zip": "200001"}', '{"source": "tablet", "coupon": "FREESHIP"}'),
(112, '2025-05-14', 4065.1, 'Cancelled', '{"street": "131 Yakubu Gowon", "city": "Aba", "zip": "450001"}', '{"source": "mobile", "coupon": "WINTER30"}'),
(65, '2025-02-25', 26202.9, 'Pending', '{"street": "196 Ahmadu Bello Way", "city": "Kaduna", "zip": "800001"}', '{"source": "mobile", "coupon": "WINTER30"}'),
(7, '2025-06-16', 5367.03, 'Shipped', '{"street": "98 Herbert Macaulay", "city": "Maiduguri", "zip": "600001"}', '{"source": "mobile"}'),
(156, '2025-04-08', 2430.12, 'Cancelled', '{"street": "52 Obafemi Awolowo", "city": "Zaria", "zip": "810001"}', '{"source": "desktop", "coupon": "NEWUSER25"}'),
(155, '2025-03-01', 3141.18, 'Processing', '{"street": "78 Oduduwa", "city": "Kaduna", "zip": "800001"}', '{"source": "tablet", "coupon": "WELCOME10", "notes": "Don''t ring doorbell"}'),
(116, '2025-06-09', 4752.69, 'Delivered', '{"street": "38 Aminu Kano", "city": "Ibadan", "zip": "200001"}', '{"source": "desktop", "coupon": "WELCOME10"}'),
(179, '2025-03-08', 136648.19, 'Pending', '{"street": "86 Ibrahim Taiwo", "city": "Maiduguri", "zip": "600001"}', '{"source": "tablet", "coupon": "SUMMER20", "notes": "Gift for anniversary"}'),
(24, '2025-02-11', 111213.25, 'Delivered', '{"street": "29 Marina Road", "city": "Maiduguri", "zip": "600001"}', '{"source": "desktop"}'),
(146, '2025-02-08', 8766.92, 'Pending', '{"street": "29 Obafemi Awolowo", "city": "Zaria", "zip": "810001"}', '{"source": "mobile", "coupon": "WELCOME10"}'),
(198, '2025-05-03', 21845.32, 'Delivered', '{"street": "179 Obafemi Awolowo", "city": "Ibadan", "zip": "200001"}', '{"source": "tablet", "coupon": "WINTER30"}'),
(50, '2025-05-27', 99083.2, 'Cancelled', '{"street": "145 Nnamdi Azikiwe", "city": "Port Harcourt", "zip": "500001"}', '{"source": "tablet"}'),
(186, '2025-05-01', 1006.6, 'Shipped', '{"street": "23 Allen Avenue", "city": "Ibadan", "zip": "200001"}', '{"source": "tablet", "coupon": "WINTER30"}'),
(123, '2025-05-02', 3378.65, 'Processing', '{"street": "178 Ahmadu Bello Way", "city": "Port Harcourt", "zip": "500001"}', '{"source": "desktop", "coupon": "FREESHIP"}'),
(121, '2025-05-21', 13823.79, 'Processing', '{"street": "150 Awolowo Road", "city": "Ibadan", "zip": "200001"}', '{"source": "desktop"}'),
(106, '2025-01-20', 14823.02, 'Shipped', '{"street": "133 Murtala Mohammed", "city": "Aba", "zip": "450001"}', '{"source": "desktop", "coupon": "NEWUSER25"}'),
(70, '2025-04-15', 39087.04, 'Pending', '{"street": "65 Aminu Kano", "city": "Aba", "zip": "450001"}', '{"source": "mobile", "gift_wrap": true, "coupon": "SUMMER20"}'),
(177, '2025-01-08', 12311.58, 'Processing', '{"street": "88 Ahmadu Bello Way", "city": "Maiduguri", "zip": "600001"}', '{"source": "tablet", "coupon": "WINTER30"}'),
(146, '2025-06-20', 2842.42, 'Shipped', '{"street": "167 Yakubu Gowon", "city": "Ibadan", "zip": "200001"}', '{"source": "mobile"}'),
(165, '2025-03-07', 7377.2, 'Processing', '{"street": "142 Michael Okpara", "city": "Benin City", "zip": "300001"}', '{"source": "mobile", "coupon": "WELCOME10"}'),
(165, '2025-03-27', 3329.39, 'Delivered', '{"street": "100 Awolowo Road", "city": "Benin City", "zip": "300001"}', '{"source": "tablet", "gift_wrap": true, "coupon": "WINTER30"}'),
(129, '2025-02-22', 180697.73, 'Delivered', '{"street": "68 Marina Road", "city": "Kano", "zip": "700001"}', '{"source": "desktop", "coupon": "SAVE15"}'),
(28, '2025-03-29', 1453.66, 'Delivered', '{"street": "199 Sultan Abubakar", "city": "Kano", "zip": "700001"}', '{"source": "desktop", "coupon": "FREESHIP"}'),
(49, '2025-02-19', 1949.7, 'Processing', '{"street": "11 Olusegun Obasanjo", "city": "Abuja", "zip": "900001"}', '{"source": "tablet", "notes": "Birthday present"}'),
(146, '2025-04-09', 1090.24, 'Shipped', '{"street": "83 Adetokunbo Ademola", "city": "Aba", "zip": "450001"}', '{"source": "mobile", "coupon": "WELCOME10"}'),
(108, '2025-01-15', 54092.66, 'Shipped', '{"street": "30 Olusegun Obasanjo", "city": "Abuja", "zip": "900001"}', '{"source": "mobile", "coupon": "FREESHIP"}'),
(110, '2025-02-23', 98717.31, 'Shipped', '{"street": "153 Adetokunbo Ademola", "city": "Abuja", "zip": "900001"}', '{"source": "tablet", "coupon": "SUMMER20"}'),
(86, '2025-05-11', 19720.79, 'Shipped', '{"street": "189 Michael Okpara", "city": "Zaria", "zip": "810001"}', '{"source": "mobile", "coupon": "WELCOME10"}'),
(7, '2025-03-08', 5340.27, 'Delivered', '{"street": "124 Ahmadu Bello Way", "city": "Benin City", "zip": "300001"}', '{"source": "tablet"}'),
(81, '2025-01-27', 26926.8, 'Delivered', '{"street": "101 Allen Avenue", "city": "Ibadan", "zip": "200001"}', '{"source": "mobile", "coupon": "NEWUSER25"}'),
(162, '2025-05-29', 4005.15, 'Cancelled', '{"street": "144 Ahmadu Bello Way", "city": "Port Harcourt", "zip": "500001"}', '{"source": "desktop", "gift_wrap": true, "coupon": "SAVE15"}'),
(79, '2025-04-26', 63035.7, 'Cancelled', '{"street": "57 Awolowo Road", "city": "Zaria", "zip": "810001"}', '{"source": "tablet", "gift_wrap": true, "coupon": "WELCOME10"}'),
(131, '2025-04-25', 76280.29, 'Shipped', '{"street": "62 Ibrahim Taiwo", "city": "Port Harcourt", "zip": "500001"}', '{"source": "mobile", "coupon": "WELCOME10"}'),
(131, '2025-04-30', 3537.85, 'Shipped', '{"street": "65 Marina Road", "city": "Maiduguri", "zip": "600001"}', '{"source": "tablet", "coupon": "SAVE15"}'),
(71, '2025-06-26', 2091.87, 'Pending', '{"street": "48 Awolowo Road", "city": "Kaduna", "zip": "800001"}', '{"source": "desktop", "gift_wrap": true, "coupon": "NEWUSER25"}'),
(35, '2025-05-12', 57524.71, 'Pending', '{"street": "33 Sultan Abubakar", "city": "Kaduna", "zip": "800001"}', '{"source": "tablet", "coupon": "WELCOME10", "notes": "Call before delivery"}'),
(134, '2025-01-28', 39669.29, 'Delivered', '{"street": "80 Allen Avenue", "city": "Kano", "zip": "700001"}', '{"source": "desktop", "coupon": "NEWUSER25"}'),
(137, '2025-03-20', 4678.78, 'Pending', '{"street": "40 Olusegun Obasanjo", "city": "Lagos", "zip": "100001"}', '{"source": "mobile", "gift_wrap": true, "coupon": "SAVE15"}'),
(99, '2025-01-30', 1462.53, 'Shipped', '{"street": "153 Oduduwa", "city": "Kano", "zip": "700001"}', '{"source": "mobile", "coupon": "NEWUSER25"}'),
(157, '2025-06-28', 8613.5, 'Shipped', '{"street": "99 Herbert Macaulay", "city": "Aba", "zip": "450001"}', '{"source": "tablet"}'),
(47, '2025-05-09', 75962.1, 'Cancelled', '{"street": "127 Murtala Mohammed", "city": "Port Harcourt", "zip": "500001"}', '{"source": "desktop"}'),
(165, '2025-05-17', 65651.2, 'Processing', '{"street": "69 Adekunle Fajuyi", "city": "Zaria", "zip": "810001"}', '{"source": "tablet", "coupon": "SAVE15"}'),
(141, '2025-07-01', 38167.12, 'Processing', '{"street": "169 Murtala Mohammed", "city": "Maiduguri", "zip": "600001"}', '{"source": "tablet", "coupon": "NEWUSER25"}'),
(112, '2025-02-20', 2137.61, 'Cancelled', '{"street": "156 Allen Avenue", "city": "Maiduguri", "zip": "600001"}', '{"source": "desktop", "gift_wrap": true, "coupon": "NEWUSER25"}'),
(141, '2025-05-24', 3811.19, 'Pending', '{"street": "114 Samuel Ladoke Akintola", "city": "Aba", "zip": "450001"}', '{"source": "desktop", "coupon": "SAVE15"}'),
(112, '2025-04-01', 8068.43, 'Shipped', '{"street": "32 Sultan Abubakar", "city": "Kano", "zip": "700001"}', '{"source": "tablet", "coupon": "WINTER30"}'),
(72, '2025-05-19', 2171.7, 'Processing', '{"street": "155 Emeka Anyaoku", "city": "Kaduna", "zip": "800001"}', '{"source": "tablet", "coupon": "FREESHIP"}'),
(168, '2025-01-29', 4823.75, 'Pending', '{"street": "86 Michael Okpara", "city": "Benin City", "zip": "300001"}', '{"source": "mobile", "coupon": "FREESHIP"}'),
(49, '2025-06-02', 17180.51, 'Pending', '{"street": "50 Emeka Anyaoku", "city": "Zaria", "zip": "810001"}', '{"source": "mobile", "coupon": "WELCOME10"}'),
(81, '2025-04-26', 7277.38, 'Processing', '{"street": "61 Olusegun Obasanjo", "city": "Ibadan", "zip": "200001"}', '{"source": "desktop", "coupon": "SUMMER20"}'),
(22, '2025-05-04', 4901.9, 'Pending', '{"street": "23 Adetokunbo Ademola", "city": "Zaria", "zip": "810001"}', '{"source": "tablet", "coupon": "WINTER30"}'),
(200, '2025-05-08', 1168.68, 'Processing', '{"street": "50 Olusegun Obasanjo", "city": "Zaria", "zip": "810001"}', '{"source": "tablet", "coupon": "SAVE15"}'),
(178, '2025-02-23', 2033.04, 'Processing', '{"street": "170 Olusegun Obasanjo", "city": "Abuja", "zip": "900001"}', '{"source": "tablet", "coupon": "WINTER30"}'),
(177, '2025-04-11', 9384.08, 'Processing', '{"street": "52 Olusegun Obasanjo", "city": "Kano", "zip": "700001"}', '{"source": "mobile", "coupon": "FREESHIP"}'),
(31, '2025-03-15', 61702.2, 'Processing', '{"street": "94 Sultan Abubakar", "city": "Aba", "zip": "450001"}', '{"source": "mobile"}'),
(19, '2025-06-20', 7641.7, 'Pending', '{"street": "87 Michael Okpara", "city": "Zaria", "zip": "810001"}', '{"source": "desktop", "coupon": "NEWUSER25"}'),
(16, '2025-04-09', 9181.11, 'Processing', '{"street": "189 Obafemi Awolowo", "city": "Kaduna", "zip": "800001"}', '{"source": "desktop", "coupon": "WELCOME10", "notes": "Handle with care"}'),
(60, '2025-03-14', 1829.76, 'Delivered', '{"street": "196 Ibrahim Taiwo", "city": "Lagos", "zip": "100001"}', '{"source": "mobile", "gift_wrap": true, "coupon": "SUMMER20", "notes": "Signature required"}'),
(118, '2025-05-13', 65311.81, 'Shipped', '{"street": "138 Olusegun Obasanjo", "city": "Port Harcourt", "zip": "500001"}', '{"source": "desktop", "coupon": "FREESHIP"}'),
(188, '2025-05-25', 14906.85, 'Processing', '{"street": "116 Ibrahim Taiwo", "city": "Kano", "zip": "700001"}', '{"source": "tablet", "gift_wrap": true, "coupon": "NEWUSER25"}'),
(30, '2025-06-06', 6205.7, 'Processing', '{"street": "135 Murtala Mohammed", "city": "Abuja", "zip": "900001"}', '{"source": "mobile", "coupon": "SUMMER20"}'),
(113, '2025-01-05', 89630.22, 'Pending', '{"street": "16 Nnamdi Azikiwe", "city": "Aba", "zip": "450001"}', '{"source": "tablet", "coupon": "SUMMER20"}'),
(155, '2025-04-19', 5359.5, 'Processing', '{"street": "41 Oduduwa", "city": "Benin City", "zip": "300001"}', '{"source": "desktop", "gift_wrap": true, "coupon": "WINTER30"}'),
(86, '2025-06-16', 49850.03, 'Processing', '{"street": "165 Samuel Ladoke Akintola", "city": "Zaria", "zip": "810001"}', '{"source": "mobile", "coupon": "SAVE15"}'),
(114, '2025-03-17', 7362.6, 'Shipped', '{"street": "73 Herbert Macaulay", "city": "Zaria", "zip": "810001"}', '{"source": "tablet", "gift_wrap": true, "coupon": "NEWUSER25"}'),
(85, '2025-05-25', 6182.25, 'Cancelled', '{"street": "109 Yakubu Gowon", "city": "Kano", "zip": "700001"}', '{"source": "desktop", "gift_wrap": true}'),
(92, '2025-06-29', 1174.7, 'Pending', '{"street": "174 Obafemi Awolowo", "city": "Port Harcourt", "zip": "500001"}', '{"source": "mobile", "gift_wrap": true, "coupon": "NEWUSER25"}'),
(165, '2025-06-11', 1910.33, 'Cancelled', '{"street": "79 Ahmadu Bello Way", "city": "Ibadan", "zip": "200001"}', '{"source": "tablet"}'),
(27, '2025-04-01', 18585.43, 'Delivered', '{"street": "132 Marina Road", "city": "Kaduna", "zip": "800001"}', '{"source": "desktop", "coupon": "WELCOME10"}'),
(82, '2025-04-03', 4837.61, 'Processing', '{"street": "63 Samuel Ladoke Akintola", "city": "Ibadan", "zip": "200001"}', '{"source": "mobile", "coupon": "NEWUSER25"}'),
(143, '2025-06-11', 54534.87, 'Delivered', '{"street": "164 Sultan Abubakar", "city": "Benin City", "zip": "300001"}', '{"source": "tablet", "coupon": "WINTER30"}'),
(15, '2025-03-27', 5166.95, 'Shipped', '{"street": "150 Ahmadu Bello Way", "city": "Abuja", "zip": "900001"}', '{"source": "tablet", "coupon": "WELCOME10"}'),
(86, '2025-01-25', 12096.7, 'Processing', '{"street": "122 Awolowo Road", "city": "Kaduna", "zip": "800001"}', '{"source": "mobile", "coupon": "WELCOME10"}'),
(99, '2025-02-12', 2619.67, 'Shipped', '{"street": "11 Ibrahim Taiwo", "city": "Maiduguri", "zip": "600001"}', '{"source": "mobile", "coupon": "WELCOME10"}'),
(163, '2025-01-29', 2219.6, 'Shipped', '{"street": "104 Allen Avenue", "city": "Benin City", "zip": "300001"}', '{"source": "mobile", "coupon": "SAVE15"}'),
(90, '2025-05-10', 2008.54, 'Shipped', '{"street": "185 Sultan Abubakar", "city": "Kano", "zip": "700001"}', '{"source": "desktop", "coupon": "NEWUSER25"}'),
(177, '2025-04-29', 14694.03, 'Processing', '{"street": "173 Murtala Mohammed", "city": "Port Harcourt", "zip": "500001"}', '{"source": "desktop"}'),
(181, '2025-02-03', 37127.98, 'Shipped', '{"street": "55 Michael Okpara", "city": "Maiduguri", "zip": "600001"}', '{"source": "desktop"}'),
(126, '2025-04-14', 57402.63, 'Delivered', '{"street": "173 Anthony Enahoro", "city": "Aba", "zip": "450001"}', '{"source": "desktop", "coupon": "NEWUSER25"}'),
(163, '2025-02-04', 3686.56, 'Shipped', '{"street": "177 Olusegun Obasanjo", "city": "Ibadan", "zip": "200001"}', '{"source": "mobile", "coupon": "WINTER30"}'),
(64, '2025-03-29', 16330.19, 'Shipped', '{"street": "3 Anthony Enahoro", "city": "Port Harcourt", "zip": "500001"}', '{"source": "mobile"}'),
(82, '2025-05-03', 8211.42, 'Processing', '{"street": "54 Allen Avenue", "city": "Zaria", "zip": "810001"}', '{"source": "mobile", "coupon": "NEWUSER25"}'),
(183, '2025-03-26', 30096.96, 'Processing', '{"street": "115 Obafemi Awolowo", "city": "Ibadan", "zip": "200001"}', '{"source": "mobile", "gift_wrap": true}'),
(38, '2025-06-04', 1856.03, 'Shipped', '{"street": "192 Awolowo Road", "city": "Port Harcourt", "zip": "500001"}', '{"source": "tablet", "coupon": "WELCOME10", "notes": "Gift for anniversary"}'),
(156, '2025-01-22', 7230.09, 'Processing', '{"street": "43 Herbert Macaulay", "city": "Maiduguri", "zip": "600001"}', '{"source": "tablet", "gift_wrap": true, "coupon": "FREESHIP"}'),
(67, '2025-03-01', 22266.62, 'Cancelled', '{"street": "143 Adekunle Fajuyi", "city": "Aba", "zip": "450001"}', '{"source": "mobile"}'),
(59, '2025-06-04', 13561.63, 'Shipped', '{"street": "19 Oduduwa", "city": "Kaduna", "zip": "800001"}', '{"source": "desktop", "coupon": "SUMMER20"}'),
(130, '2025-04-15', 7389.17, 'Shipped', '{"street": "193 Murtala Mohammed", "city": "Port Harcourt", "zip": "500001"}', '{"source": "mobile"}'),
(87, '2025-02-01', 9610.48, 'Processing', '{"street": "192 Sultan Abubakar", "city": "Kano", "zip": "700001"}', '{"source": "tablet", "coupon": "SUMMER20"}'),
(178, '2025-05-23', 38351.78, 'Shipped', '{"street": "102 Allen Avenue", "city": "Abuja", "zip": "900001"}', '{"source": "tablet", "coupon": "SAVE15"}'),
(35, '2025-01-29', 8193.36, 'Processing', '{"street": "104 Awolowo Road", "city": "Aba", "zip": "450001"}', '{"source": "tablet", "coupon": "SUMMER20"}'),
(153, '2025-01-18', 11981.89, 'Shipped', '{"street": "162 Marina Road", "city": "Aba", "zip": "450001"}', '{"source": "desktop", "coupon": "WELCOME10"}'),
(137, '2025-05-18', 8082.25, 'Shipped', '{"street": "49 Ahmadu Bello Way", "city": "Maiduguri", "zip": "600001"}', '{"source": "desktop", "coupon": "SUMMER20"}'),
(76, '2025-05-30', 8366.95, 'Cancelled', '{"street": "29 Emeka Anyaoku", "city": "Port Harcourt", "zip": "500001"}', '{"source": "desktop", "coupon": "SUMMER20"}'),
(132, '2025-04-02', 7397.79, 'Processing', '{"street": "117 Marina Road", "city": "Maiduguri", "zip": "600001"}', '{"source": "tablet", "gift_wrap": true, "coupon": "NEWUSER25"}'),
(18, '2025-01-12', 15371.06, 'Processing', '{"street": "153 Oduduwa", "city": "Ibadan", "zip": "200001"}', '{"source": "tablet", "coupon": "SUMMER20"}'),
(196, '2025-04-13', 126535.6, 'Pending', '{"street": "99 Ahmadu Bello Way", "city": "Kaduna", "zip": "800001"}', '{"source": "tablet", "coupon": "WELCOME10"}'),
(19, '2025-03-03', 8141.96, 'Processing', '{"street": "113 Murtala Mohammed", "city": "Port Harcourt", "zip": "500001"}', '{"source": "desktop", "notes": "Don''t ring doorbell"}'),
(99, '2025-05-05', 68254.6, 'Processing', '{"street": "188 Emeka Anyaoku", "city": "Port Harcourt", "zip": "500001"}', '{"source": "desktop", "coupon": "SUMMER20"}'),
(23, '2025-03-08', 26298.21, 'Processing', '{"street": "84 Herbert Macaulay", "city": "Maiduguri", "zip": "600001"}', '{"source": "mobile", "gift_wrap": true, "coupon": "FREESHIP"}');


INSERT INTO order_items (order_id, product_id, quantity, price, discount, item_attributes)
VALUES
(1, 113, 6, 2465.63, 0.0, '{"warranty": "6 months", "bundle_offer": true}'),
(1, 97, 10, 9547.19, 0.0, '{"warranty": "2 years", "color": "Red"}'),
(2, 13, 3, 2672.75, 0.0, '{"color": "Red"}'),
(2, 103, 3, 12394.89, 0.0, '{}'),
(2, 154, 1, 41760.37, 0.0, '{"bundle_offer": true}'),
(2, 107, 6, 31513.04, 0.0, '{"bundle_offer": true}'),
(2, 73, 2, 7411.19, 0.0, '{"size": "S"}'),
(3, 42, 2, 55496.24, 0.0, '{}'),
(3, 22, 2, 11552.88, 2018.19, '{"warranty": "2 years"}'),
(4, 46, 1, 24888.52, 0.0, '{"size": "XL"}'),
(4, 63, 1, 2206.48, 0.0, '{"warranty": "1 year", "size": "S"}'),
(4, 70, 3, 27651.08, 0.0, '{"size": "S"}'),
(5, 58, 3, 19438.85, 0.0, '{"size": "S"}'),
(5, 146, 10, 14878.28, 0.0, '{"warranty": "6 months"}'),
(5, 112, 1, 8997.37, 0.0, '{"color": "White"}'),
(6, 83, 2, 6948.19, 0.0, '{"RAM_upgrade": "32GB"}'),
(7, 188, 2, 2054.61, 0.0, '{"warranty": "6 months", "bundle_offer": true}'),
(7, 130, 3, 9319.7, 613.12, '{"color": "Red"}'),
(7, 46, 2, 29960.01, 2051.63, '{"bundle_offer": true, "storage_upgrade": "2TB HDD"}'),
(7, 148, 1, 4408.62, 0.0, '{"size": "XL", "installation": "Basic"}'),
(7, 196, 1, 19194.13, 2212.35, '{"bundle_offer": true, "color": "Green", "gift_wrap": true}'),
(8, 30, 3, 3713.92, 0.0, '{"color": "Black"}'),
(9, 98, 9, 5195.02, 0.0, '{"warranty": "2 years", "size": "M"}'),
(9, 83, 3, 1957.74, 0.0, '{"bundle_offer": true, "gift_wrap": true}'),
(9, 103, 3, 18889.75, 3141.91, '{"bundle_offer": true}'),
(10, 35, 9, 44366.27, 0.0, '{"size": "XL"}'),
(10, 179, 3, 39485.88, 2824.83, '{"bundle_offer": true}'),
(10, 194, 2, 18828.5, 0.0, '{"bundle_offer": true, "size": "XL", "color": "Red"}'),
(11, 157, 3, 26296.04, 0.0, '{"bundle_offer": true}'),
(11, 31, 9, 16281.83, 2495.32, '{"bundle_offer": true, "size": "XL", "engraving": "Date"}'),
(11, 167, 5, 2964.42, 0.0, '{"installation": "Premium"}'),
(11, 78, 3, 10077.99, 0.0, '{}'),
(11, 178, 3, 4406.71, 0.0, '{"bundle_offer": true, "size": "S"}'),
(12, 68, 3, 2577.83, 0.0, '{"size": "M"}'),
(13, 198, 3, 12720.39, 0.0, '{"warranty": "1 year", "bundle_offer": true, "color": "Red"}'),
(14, 100, 1, 38772.28, 0.0, '{"warranty": "1 year", "size": "L"}'),
(14, 66, 2, 5682.76, 0.0, '{"warranty": "1 year", "bundle_offer": true}'),
(15, 58, 3, 5640.02, 1127.29, '{"warranty": "2 years", "color": "White"}'),
(15, 33, 1, 9580.37, 0.0, '{"warranty": "2 years", "size": "M", "RAM_upgrade": "32GB"}'),
(15, 2, 1, 19689.1, 2737.49, '{"warranty": "6 months", "size": "XL"}'),
(15, 24, 2, 3106.96, 328.7, '{"warranty": "2 years", "size": "L", "color": "Red"}'),
(15, 8, 2, 75131.63, 8240.49, '{"size": "M", "storage_upgrade": "2TB HDD"}'),
(16, 130, 1, 2121.36, 303.87, '{"bundle_offer": true}'),
(16, 16, 2, 12455.85, 0.0, '{"bundle_offer": true, "color": "Black", "gift_wrap": true}'),
(16, 67, 3, 1253.06, 0.0, '{}'),
(17, 79, 2, 3826.93, 586.96, '{"warranty": "2 years"}'),
(18, 12, 1, 19319.07, 1161.36, '{"warranty": "6 months", "RAM_upgrade": "32GB"}'),
(18, 175, 3, 9624.35, 0.0, '{"bundle_offer": true}'),
(18, 3, 2, 46910.03, 0.0, '{"size": "S", "color": "Red", "RAM_upgrade": "64GB"}'),
(18, 38, 3, 40553.29, 0.0, '{}'),
(19, 178, 1, 19603.12, 0.0, '{"warranty": "6 months", "color": "Green"}'),
(19, 153, 2, 18367.22, 0.0, '{"bundle_offer": true}'),
(19, 77, 1, 1052.98, 0.0, '{"warranty": "2 years", "installation": "Basic"}'),
(19, 53, 3, 25700.8, 0.0, '{"warranty": "1 year"}'),
(20, 4, 3, 5133.56, 0.0, '{"bundle_offer": true}'),
(20, 58, 2, 18803.07, 0.0, '{"bundle_offer": true}'),
(21, 188, 5, 9092.46, 1302.73, '{"warranty": "1 year", "size": "XL"}'),
(21, 148, 3, 1828.58, 0.0, '{"bundle_offer": true, "color": "Black"}'),
(21, 74, 10, 5882.95, 0.0, '{"warranty": "1 year"}'),
(21, 187, 1, 6821.76, 0.0, '{"color": "White"}'),
(22, 160, 4, 7374.02, 0.0, '{"warranty": "6 months"}'),
(22, 133, 2, 2627.29, 0.0, '{}'),
(23, 20, 2, 9837.88, 0.0, '{"warranty": "2 years", "color": "Black"}'),
(24, 194, 1, 10202.84, 0.0, '{"size": "M"}'),
(24, 163, 3, 24885.24, 0.0, '{"bundle_offer": true}'),
(24, 44, 2, 19237.45, 0.0, '{"warranty": "2 years"}'),
(24, 16, 2, 693.88, 0.0, '{"warranty": "2 years"}'),
(25, 142, 1, 23349.91, 2783.41, '{"color": "Red"}'),
(25, 97, 3, 70340.63, 0.0, '{"bundle_offer": true, "color": "Red", "RAM_upgrade": "16GB"}'),
(26, 97, 7, 16813.06, 0.0, '{"warranty": "2 years", "size": "M", "RAM_upgrade": "64GB"}'),
(26, 85, 2, 21532.47, 0.0, '{}'),
(26, 123, 2, 32969.03, 0.0, '{"color": "Blue"}'),
(27, 173, 2, 2948.57, 474.64, '{"size": "S"}'),
(27, 29, 4, 29790.71, 0.0, '{}'),
(27, 20, 3, 953.18, 95.06, '{}'),
(28, 127, 3, 26207.87, 0.0, '{"size": "XL"}'),
(28, 42, 2, 6032.83, 0.0, '{"bundle_offer": true}'),
(28, 153, 2, 136386.55, 12641.17, '{"bundle_offer": true, "color": "Red"}'),
(29, 171, 3, 5855.79, 435.01, '{"size": "XL", "color": "Black"}'),
(29, 89, 2, 28914.01, 0.0, '{"bundle_offer": true}'),
(29, 76, 3, 5299.26, 0.0, '{"warranty": "6 months", "color": "Red"}'),
(29, 36, 1, 4016.77, 0.0, '{"warranty": "6 months"}'),
(30, 84, 3, 97569.54, 13985.49, '{"warranty": "2 years", "size": "XL", "color": "White"}'),
(30, 41, 6, 17912.96, 2556.02, '{"bundle_offer": true}'),
(30, 83, 3, 8443.11, 0.0, '{}'),
(31, 149, 2, 18012.7, 2379.38, '{"size": "XL"}'),
(32, 37, 8, 6706.26, 1291.8, '{"warranty": "2 years"}'),
(32, 35, 8, 15498.15, 0.0, '{"color": "Green"}'),
(33, 187, 2, 14996.16, 1136.09, '{"bundle_offer": true, "size": "M"}'),
(33, 161, 5, 13389.01, 1523.36, '{"warranty": "1 year", "size": "S"}'),
(34, 107, 2, 24752.89, 0.0, '{"warranty": "6 months"}'),
(34, 183, 1, 45972.8, 0.0, '{"RAM_upgrade": "16GB"}'),
(34, 85, 3, 7902.3, 0.0, '{"color": "Green", "RAM_upgrade": "32GB"}'),
(34, 162, 2, 89622.1, 13634.58, '{"warranty": "6 months", "bundle_offer": true, "size": "M", "color": "Green"}'),
(34, 87, 9, 37651.43, 0.0, '{"color": "White"}'),
(35, 26, 2, 9973.19, 0.0, '{"bundle_offer": true}'),
(36, 189, 3, 95745.25, 0.0, '{"warranty": "2 years"}'),
(36, 197, 7, 18028.74, 1858.3, '{}'),
(36, 115, 1, 8200.59, 0.0, '{"size": "S", "color": "Black"}'),
(37, 69, 3, 11133.18, 0.0, '{"warranty": "2 years"}'),
(37, 37, 1, 13536.63, 0.0, '{"warranty": "1 year"}'),
(37, 177, 1, 111122.15, 52507.24, '{"bundle_offer": true}'),
(37, 147, 2, 10763.53, 0.0, '{"size": "XL", "color": "Green"}'),
(37, 167, 4, 86733.65, 7877.28, '{}'),
(38, 106, 2, 16757.84, 0.0, '{}'),
(39, 163, 1, 5614.0, 0.0, '{}'),
(39, 86, 3, 4870.31, 312.74, '{"color": "White"}'),
(39, 26, 3, 13213.66, 0.0, '{"size": "S", "gift_wrap": true}'),
(40, 70, 3, 15986.98, 0.0, '{}'),
(40, 196, 2, 14772.75, 0.0, '{"color": "Black"}'),
(40, 192, 2, 12629.14, 0.0, '{"warranty": "1 year", "bundle_offer": true}'),
(40, 81, 3, 24452.25, 1880.06, '{"bundle_offer": true}'),
(40, 58, 3, 46191.22, 0.0, '{}'),
(41, 53, 1, 7243.39, 730.53, '{"warranty": "2 years", "bundle_offer": true}'),
(41, 128, 2, 5260.95, 0.0, '{}'),
(41, 164, 4, 26524.32, 3029.42, '{"bundle_offer": true}'),
(41, 132, 2, 41519.67, 0.0, '{"bundle_offer": true, "size": "XL", "color": "Green", "engraving": "Message"}'),
(41, 29, 9, 76213.17, 0.0, '{"warranty": "6 months", "bundle_offer": true}'),
(42, 30, 1, 14893.02, 0.0, '{"warranty": "1 year", "bundle_offer": true, "color": "White"}'),
(43, 178, 3, 66110.49, 0.0, '{"warranty": "2 years", "bundle_offer": true}'),
(43, 26, 3, 5078.35, 0.0, '{"warranty": "1 year"}'),
(43, 13, 2, 3245.81, 0.0, '{}'),
(43, 122, 2, 15242.14, 0.0, '{"size": "M"}'),
(44, 174, 1, 9932.18, 0.0, '{"size": "S"}'),
(45, 188, 3, 13833.78, 0.0, '{"color": "Green"}'),
(45, 161, 1, 17465.41, 0.0, '{"bundle_offer": true, "size": "XL"}'),
(45, 37, 3, 4825.15, 0.0, '{"warranty": "1 year", "size": "M", "RAM_upgrade": "16GB"}'),
(46, 6, 1, 14276.13, 0.0, '{"bundle_offer": true}'),
(46, 47, 1, 24414.3, 0.0, '{"size": "S"}'),
(46, 143, 2, 17791.24, 0.0, '{"warranty": "1 year", "color": "Blue"}'),
(47, 196, 2, 25476.41, 0.0, '{"warranty": "1 year"}'),
(47, 25, 1, 68392.43, 0.0, '{"warranty": "1 year", "color": "Black"}'),
(47, 190, 1, 39007.39, 3121.98, '{"storage_upgrade": "1TB SSD"}'),
(48, 80, 2, 16078.76, 4573.3, '{"size": "M", "RAM_upgrade": "16GB"}'),
(48, 156, 3, 143289.07, 13055.01, '{"warranty": "2 years", "bundle_offer": true}'),
(49, 133, 2, 5321.76, 629.75, '{"bundle_offer": true, "color": "Green"}'),
(50, 6, 3, 8447.95, 0.0, '{"warranty": "2 years"}'),
(50, 108, 5, 16588.29, 0.0, '{"warranty": "2 years", "color": "Red", "installation": "Premium"}'),
(50, 78, 5, 142487.55, 0.0, '{"bundle_offer": true}'),
(50, 24, 7, 13031.88, 0.0, '{"bundle_offer": true, "size": "M", "color": "Blue", "gift_wrap": true}'),
(51, 31, 9, 10823.58, 1147.39, '{}'),
(51, 154, 2, 18168.27, 0.0, '{"bundle_offer": true, "size": "S", "color": "Red"}'),
(51, 133, 3, 1903.52, 0.0, '{}'),
(51, 127, 2, 29361.46, 0.0, '{"bundle_offer": true, "size": "M"}'),
(51, 169, 2, 15951.54, 0.0, '{"bundle_offer": true, "size": "S"}'),
(52, 163, 3, 2708.17, 0.0, '{"size": "L"}'),
(53, 160, 1, 5069.72, 638.64, '{}'),
(53, 156, 3, 4089.55, 0.0, '{}'),
(53, 113, 3, 13398.69, 2285.82, '{"warranty": "2 years"}'),
(53, 152, 3, 21628.79, 0.0, '{"bundle_offer": true, "color": "Red"}'),
(53, 101, 1, 9204.99, 0.0, '{"bundle_offer": true, "size": "XL", "RAM_upgrade": "64GB"}'),
(54, 175, 1, 24696.3, 7509.55, '{"bundle_offer": true, "size": "XL"}'),
(54, 135, 1, 7918.24, 0.0, '{"warranty": "2 years", "color": "Red"}'),
(55, 156, 3, 4291.12, 354.55, '{}'),
(55, 184, 2, 36056.41, 0.0, '{}'),
(55, 112, 6, 6905.84, 994.83, '{}'),
(56, 180, 2, 5583.82, 0.0, '{"bundle_offer": true}'),
(56, 54, 3, 13941.64, 927.52, '{"color": "Black"}'),
(57, 55, 1, 21350.41, 0.0, '{"size": "XL"}'),
(57, 41, 2, 4031.15, 0.0, '{"warranty": "2 years", "size": "XL"}'),
(57, 153, 1, 9777.62, 756.91, '{"warranty": "2 years", "bundle_offer": true}'),
(57, 25, 1, 2734.45, 353.39, '{"warranty": "6 months", "color": "Green"}'),
(58, 154, 1, 13074.09, 0.0, '{"bundle_offer": true}'),
(58, 18, 1, 8568.89, 0.0, '{"warranty": "6 months", "size": "L"}'),
(59, 36, 1, 9820.75, 0.0, '{"warranty": "2 years", "bundle_offer": true, "RAM_upgrade": "16GB"}'),
(60, 190, 1, 115610.0, 9561.83, '{}'),
(60, 171, 8, 24054.85, 0.0, '{}'),
(60, 168, 3, 49360.55, 0.0, '{"bundle_offer": true}'),
(60, 200, 7, 10467.41, 0.0, '{"warranty": "2 years", "size": "L", "color": "Red"}'),
(61, 42, 2, 6769.16, 0.0, '{"size": "M"}'),
(61, 70, 7, 18996.36, 0.0, '{"bundle_offer": true}'),
(62, 163, 3, 6870.38, 0.0, '{"warranty": "6 months", "color": "Black"}'),
(62, 148, 5, 3715.23, 0.0, '{"warranty": "1 year", "bundle_offer": true}'),
(63, 46, 5, 21583.8, 3927.14, '{}'),
(63, 136, 2, 7492.29, 0.0, '{"warranty": "1 year", "installation": "Basic"}'),
(63, 53, 3, 7503.05, 0.0, '{"bundle_offer": true}'),
(64, 44, 7, 8806.89, 620.29, '{}'),
(64, 128, 6, 9627.33, 0.0, '{"bundle_offer": true, "color": "Blue"}'),
(64, 130, 6, 7455.15, 0.0, '{"bundle_offer": true, "color": "White"}'),
(65, 83, 6, 46171.58, 4897.38, '{"bundle_offer": true}'),
(65, 135, 3, 8236.72, 3288.94, '{"size": "M"}'),
(65, 50, 1, 44539.58, 11573.27, '{"warranty": "6 months", "size": "S", "RAM_upgrade": "32GB"}'),
(66, 9, 9, 21404.56, 3530.69, '{}'),
(66, 134, 3, 3523.05, 0.0, '{"bundle_offer": true, "size": "XL"}'),
(66, 99, 8, 8552.37, 0.0, '{"warranty": "1 year", "size": "L", "color": "White"}'),
(66, 161, 3, 5973.44, 0.0, '{"warranty": "6 months", "bundle_offer": true, "size": "L"}'),
(66, 186, 6, 10268.16, 1819.01, '{"color": "Red"}'),
(67, 74, 6, 17877.25, 2556.13, '{"warranty": "1 year", "size": "L", "color": "Green"}'),
(67, 59, 1, 61311.32, 10071.53, '{}'),
(67, 34, 2, 48405.11, 4409.53, '{"warranty": "1 year", "size": "M"}'),
(68, 83, 10, 20581.22, 1887.65, '{"warranty": "6 months"}'),
(69, 48, 2, 14268.93, 0.0, '{}'),
(69, 38, 2, 68650.88, 0.0, '{"warranty": "1 year", "bundle_offer": true, "size": "XL", "color": "Red", "gift_wrap": true}'),
(69, 125, 1, 19489.06, 0.0, '{"color": "Blue"}'),
(70, 174, 1, 8012.59, 1568.19, '{"warranty": "1 year"}'),
(70, 87, 2, 6022.49, 0.0, '{"color": "Green"}'),
(71, 8, 3, 3103.19, 609.04, '{"size": "L"}'),
(72, 77, 9, 10992.79, 0.0, '{}'),
(72, 52, 3, 9529.77, 0.0, '{"warranty": "6 months", "size": "L"}'),
(72, 90, 6, 3114.02, 0.0, '{"bundle_offer": true, "size": "S"}'),
(72, 32, 1, 23509.98, 0.0, '{}'),
(72, 105, 1, 7606.81, 0.0, '{"warranty": "2 years", "size": "M", "storage_upgrade": "2TB HDD"}'),
(73, 194, 2, 3548.95, 0.0, '{}'),
(73, 140, 1, 16792.64, 0.0, '{"warranty": "6 months"}'),
(73, 138, 1, 17588.76, 0.0, '{"color": "Red"}'),
(73, 20, 2, 17683.56, 0.0, '{}'),
(73, 55, 1, 28697.42, 0.0, '{"warranty": "1 year", "bundle_offer": true}'),
(74, 129, 5, 4067.79, 0.0, '{"bundle_offer": true}'),
(74, 3, 3, 5810.64, 0.0, '{"warranty": "6 months", "bundle_offer": true, "size": "M"}'),
(74, 17, 3, 14949.53, 0.0, '{}'),
(74, 88, 2, 37122.75, 0.0, '{}'),
(75, 190, 5, 28637.84, 4161.66, '{"warranty": "1 year", "storage_upgrade": "2TB HDD"}'),
(75, 71, 3, 6001.42, 1063.16, '{"size": "M"}'),
(75, 114, 2, 647.78, 0.0, '{}'),
(75, 25, 2, 10781.87, 0.0, '{"bundle_offer": true}'),
(75, 80, 1, 12243.25, 2304.18, '{"warranty": "6 months"}'),
(76, 54, 3, 13124.8, 0.0, '{"warranty": "6 months", "bundle_offer": true}'),
(76, 34, 3, 19200.0, 1909.33, '{}'),
(76, 85, 2, 13337.05, 0.0, '{"warranty": "6 months"}'),
(76, 139, 9, 39089.7, 0.0, '{"bundle_offer": true}'),
(76, 39, 3, 10678.59, 1025.93, '{"size": "L", "installation": "Professional"}'),
(77, 164, 3, 18068.55, 0.0, '{"warranty": "2 years", "color": "Green"}'),
(77, 185, 1, 6639.98, 911.55, '{"warranty": "1 year"}'),
(77, 45, 2, 3779.51, 0.0, '{"warranty": "6 months"}'),
(77, 129, 3, 11300.25, 589.07, '{"bundle_offer": true, "size": "M", "color": "Green"}'),
(77, 127, 9, 13828.02, 0.0, '{"warranty": "6 months", "color": "Blue"}'),
(78, 49, 6, 6732.87, 0.0, '{"warranty": "2 years", "color": "Blue"}'),
(78, 4, 1, 3025.04, 0.0, '{"warranty": "6 months"}'),
(78, 23, 2, 7364.58, 0.0, '{"warranty": "1 year"}'),
(78, 159, 2, 18012.75, 2814.29, '{"size": "S", "color": "White"}'),
(79, 129, 3, 13444.98, 0.0, '{"warranty": "2 years", "size": "L"}'),
(79, 118, 3, 72337.93, 14222.94, '{"size": "XL"}'),
(79, 117, 3, 3754.29, 0.0, '{"color": "White"}'),
(79, 101, 3, 989.31, 0.0, '{"warranty": "2 years", "bundle_offer": true, "color": "Black"}'),
(79, 161, 1, 2238.12, 445.19, '{}'),
(80, 123, 2, 7174.09, 972.45, '{"size": "M"}'),
(81, 71, 2, 25938.41, 2006.43, '{"size": "M"}'),
(81, 177, 1, 3336.7, 0.0, '{"warranty": "6 months", "color": "Green"}'),
(81, 22, 2, 15362.24, 0.0, '{}'),
(81, 168, 1, 19510.07, 0.0, '{}'),
(81, 53, 3, 12429.97, 0.0, '{"bundle_offer": true}'),
(82, 184, 3, 20895.81, 0.0, '{"bundle_offer": true, "installation": "Professional"}'),
(82, 93, 2, 49368.95, 6319.39, '{"bundle_offer": true, "storage_upgrade": "2TB HDD"}'),
(82, 187, 1, 92586.38, 6447.45, '{"color": "White"}'),
(82, 94, 3, 75938.24, 6596.83, '{"size": "L", "color": "White"}'),
(83, 147, 7, 15471.89, 0.0, '{"bundle_offer": true, "size": "XL"}'),
(83, 174, 2, 11777.52, 0.0, '{"size": "L", "color": "Black"}'),
(83, 72, 2, 5326.5, 0.0, '{}'),
(84, 194, 2, 69084.74, 0.0, '{"warranty": "2 years"}'),
(84, 87, 3, 1195.23, 534.24, '{"warranty": "1 year", "RAM_upgrade": "32GB"}'),
(84, 18, 3, 105913.16, 0.0, '{"size": "L"}'),
(85, 51, 3, 9705.09, 0.0, '{"warranty": "1 year", "bundle_offer": true, "size": "S", "color": "Green", "gift_wrap": true}'),
(85, 65, 3, 49595.5, 0.0, '{"warranty": "2 years", "bundle_offer": true, "size": "M"}'),
(85, 53, 3, 9625.18, 4169.82, '{}'),
(86, 24, 3, 9031.98, 0.0, '{"size": "L"}'),
(86, 79, 1, 23195.77, 0.0, '{"color": "Black"}'),
(86, 181, 1, 4520.2, 264.46, '{"size": "S", "color": "White", "gift_wrap": true}'),
(87, 120, 1, 18115.12, 0.0, '{"warranty": "2 years", "bundle_offer": true, "color": "Green"}'),
(87, 172, 2, 6208.25, 0.0, '{"bundle_offer": true, "size": "L"}'),
(88, 134, 10, 45514.78, 0.0, '{"bundle_offer": true}'),
(88, 141, 2, 19760.87, 3504.27, '{"size": "M"}'),
(88, 158, 6, 4552.76, 0.0, '{"warranty": "6 months", "bundle_offer": true}'),
(89, 96, 3, 6741.78, 0.0, '{"warranty": "6 months", "bundle_offer": true}'),
(89, 68, 2, 22136.67, 4260.42, '{"color": "Red"}'),
(89, 75, 1, 87743.97, 0.0, '{"size": "XL", "color": "Red"}'),
(89, 5, 4, 18676.92, 0.0, '{"bundle_offer": true}'),
(90, 7, 4, 13903.36, 0.0, '{"warranty": "6 months", "gift_wrap": true}'),
(91, 60, 6, 24496.64, 0.0, '{"size": "M", "color": "Blue"}'),
(91, 35, 9, 4779.49, 0.0, '{"warranty": "1 year", "bundle_offer": true, "color": "Red"}'),
(91, 169, 2, 44162.7, 0.0, '{"warranty": "6 months"}'),
(91, 44, 1, 52219.5, 0.0, '{"size": "L"}'),
(91, 153, 9, 85961.25, 0.0, '{"bundle_offer": true}'),
(92, 177, 4, 7461.2, 0.0, '{"warranty": "2 years", "bundle_offer": true}'),
(93, 161, 3, 23638.33, 2380.91, '{"warranty": "2 years"}'),
(93, 80, 3, 8384.46, 466.24, '{"size": "XL"}'),
(93, 152, 9, 3273.73, 0.0, '{"warranty": "6 months", "bundle_offer": true, "size": "S"}'),
(93, 139, 2, 29695.17, 3910.89, '{"color": "Red"}'),
(93, 26, 7, 5776.48, 0.0, '{"warranty": "6 months"}'),
(94, 40, 2, 3639.05, 346.25, '{"warranty": "2 years"}'),
(94, 7, 3, 5691.96, 0.0, '{"size": "M", "color": "White"}'),
(94, 4, 4, 105288.67, 0.0, '{"bundle_offer": true}'),
(94, 108, 8, 1308.58, 121.53, '{"warranty": "1 year"}'),
(95, 79, 1, 8833.59, 1404.57, '{"warranty": "2 years", "color": "Green", "gift_wrap": true}'),
(95, 148, 9, 61301.15, 4206.64, '{"warranty": "2 years"}'),
(95, 138, 3, 19349.25, 0.0, '{"bundle_offer": true, "engraving": "Initials"}'),
(96, 131, 3, 8262.62, 0.0, '{"bundle_offer": true, "size": "M"}'),
(96, 23, 3, 24376.18, 2327.4, '{"bundle_offer": true, "size": "M"}'),
(96, 115, 1, 15810.66, 0.0, '{}'),
(97, 106, 3, 9990.57, 0.0, '{"warranty": "1 year", "bundle_offer": true}'),
(98, 79, 3, 35281.2, 0.0, '{"warranty": "6 months"}'),
(98, 179, 3, 20638.2, 0.0, '{"warranty": "2 years"}'),
(98, 127, 6, 11724.83, 0.0, '{"warranty": "6 months"}'),
(99, 49, 1, 142729.79, 18011.5, '{"bundle_offer": true, "color": "White"}'),
(99, 157, 3, 11468.38, 0.0, '{"bundle_offer": true, "size": "M"}'),
(99, 78, 1, 7306.21, 0.0, '{"size": "L", "installation": "Basic"}'),
(100, 116, 1, 122139.39, 0.0, '{"bundle_offer": true, "size": "M"}'),
(100, 49, 1, 16693.79, 0.0, '{"bundle_offer": true}'),
(100, 133, 3, 35212.34, 0.0, '{}'),
(101, 17, 1, 2401.42, 0.0, '{"warranty": "6 months"}'),
(101, 129, 2, 11454.07, 0.0, '{"warranty": "2 years", "bundle_offer": true, "size": "XL"}'),
(101, 119, 1, 24431.02, 0.0, '{"bundle_offer": true, "size": "L"}'),
(101, 34, 9, 25042.05, 2620.12, '{"bundle_offer": true, "color": "Blue"}'),
(101, 136, 2, 34236.32, 4161.71, '{"warranty": "2 years", "size": "S", "installation": "Professional"}'),
(102, 19, 1, 8132.1, 0.0, '{"color": "Green"}'),
(102, 60, 3, 137117.16, 55582.06, '{"warranty": "1 year", "size": "S"}'),
(102, 79, 3, 2849.48, 0.0, '{"size": "L"}'),
(103, 103, 3, 6060.14, 771.52, '{"bundle_offer": true, "size": "M", "color": "White", "engraving": "Message"}'),
(103, 24, 10, 20451.85, 0.0, '{"color": "Blue"}'),
(103, 78, 3, 2525.14, 197.32, '{"color": "White"}'),
(104, 184, 2, 8172.27, 0.0, '{"size": "L", "engraving": "Message"}'),
(104, 168, 3, 4865.69, 553.14, '{"bundle_offer": true, "color": "Black"}'),
(104, 132, 10, 4770.83, 0.0, '{"color": "Green"}'),
(105, 4, 2, 11625.03, 0.0, '{}'),
(105, 90, 7, 7907.12, 484.3, '{"warranty": "2 years", "bundle_offer": true}'),
(106, 130, 2, 18944.52, 0.0, '{"storage_upgrade": "1TB SSD"}'),
(106, 178, 3, 4875.61, 0.0, '{"size": "M"}'),
(106, 50, 1, 1187.01, 0.0, '{"color": "White"}'),
(107, 86, 2, 6921.65, 0.0, '{"size": "L"}'),
(107, 186, 2, 18720.66, 0.0, '{"warranty": "6 months", "bundle_offer": true, "size": "L", "installation": "Basic"}'),
(107, 31, 3, 15048.6, 0.0, '{"bundle_offer": true}'),
(107, 38, 2, 17540.53, 4640.04, '{"warranty": "1 year", "size": "L", "storage_upgrade": "2TB HDD"}'),
(108, 59, 1, 114478.08, 0.0, '{}'),
(108, 51, 1, 72665.47, 0.0, '{}'),
(108, 82, 3, 19658.21, 0.0, '{"color": "Blue"}'),
(109, 142, 4, 34596.05, 2180.07, '{"warranty": "6 months", "size": "M"}'),
(109, 16, 3, 4164.77, 0.0, '{"bundle_offer": true}'),
(109, 154, 3, 53574.14, 0.0, '{"storage_upgrade": "2TB HDD"}'),
(109, 95, 3, 7621.87, 0.0, '{"color": "Blue"}'),
(109, 33, 1, 9573.54, 0.0, '{"bundle_offer": true}'),
(110, 154, 2, 22332.5, 3275.27, '{"warranty": "2 years", "bundle_offer": true, "size": "L"}'),
(110, 35, 5, 8339.93, 1025.33, '{"warranty": "1 year", "bundle_offer": true}'),
(111, 112, 9, 13016.04, 0.0, '{}'),
(112, 107, 2, 125464.36, 0.0, '{"bundle_offer": true}'),
(112, 63, 5, 24582.66, 1611.48, '{"size": "M", "color": "Red"}'),
(112, 94, 6, 27855.64, 0.0, '{}'),
(113, 197, 2, 16817.45, 0.0, '{"bundle_offer": true, "size": "M", "RAM_upgrade": "16GB"}'),
(113, 120, 2, 10757.13, 0.0, '{"warranty": "2 years", "bundle_offer": true, "color": "Green"}'),
(113, 151, 5, 3099.37, 0.0, '{"warranty": "1 year", "size": "XL", "color": "Green", "gift_wrap": true}'),
(114, 190, 1, 6113.3, 628.58, '{}'),
(115, 115, 7, 1083.78, 94.98, '{"warranty": "1 year", "color": "Green"}'),
(115, 43, 6, 8099.08, 0.0, '{"warranty": "6 months", "size": "S"}'),
(116, 75, 3, 13257.68, 796.35, '{"warranty": "6 months"}'),
(116, 191, 1, 9606.57, 0.0, '{"size": "S"}'),
(116, 104, 3, 7008.41, 0.0, '{"warranty": "6 months", "bundle_offer": true, "size": "M", "color": "Green"}'),
(116, 124, 1, 7640.74, 0.0, '{}'),
(116, 122, 2, 19595.81, 0.0, '{}'),
(117, 46, 2, 7376.81, 0.0, '{"warranty": "2 years"}'),
(117, 137, 2, 5661.64, 657.52, '{"installation": "Premium"}'),
(118, 44, 1, 22922.2, 0.0, '{"bundle_offer": true, "size": "S", "color": "Black", "installation": "Professional"}'),
(119, 112, 4, 94069.95, 0.0, '{"bundle_offer": true, "size": "L"}'),
(120, 41, 8, 13141.59, 0.0, '{"warranty": "6 months"}'),
(120, 146, 2, 19345.97, 1240.38, '{"warranty": "1 year", "bundle_offer": true, "storage_upgrade": "512GB SSD"}'),
(121, 3, 2, 6506.72, 0.0, '{"bundle_offer": true}'),
(121, 120, 2, 9829.68, 767.81, '{}'),
(121, 142, 1, 18497.13, 2668.4, '{}'),
(121, 199, 3, 7279.03, 0.0, '{"warranty": "2 years", "color": "White", "gift_wrap": true}'),
(121, 63, 2, 2573.99, 0.0, '{"warranty": "6 months", "storage_upgrade": "2TB HDD"}'),
(122, 137, 7, 12322.61, 0.0, '{"warranty": "2 years", "bundle_offer": true, "size": "XL"}'),
(122, 80, 1, 45901.83, 0.0, '{"warranty": "6 months", "color": "White"}'),
(122, 57, 3, 54741.45, 4792.47, '{"warranty": "6 months", "size": "L", "color": "White"}'),
(123, 19, 3, 7057.32, 0.0, '{"warranty": "1 year", "size": "XL"}'),
(124, 21, 2, 5660.42, 0.0, '{"warranty": "1 year", "size": "L"}'),
(124, 35, 3, 28581.72, 8707.76, '{"warranty": "2 years", "size": "L", "RAM_upgrade": "16GB"}'),
(124, 99, 3, 2296.67, 0.0, '{"warranty": "1 year", "bundle_offer": true, "size": "XL"}'),
(124, 159, 3, 20003.9, 0.0, '{"bundle_offer": true}'),
(125, 69, 1, 55182.2, 0.0, '{"bundle_offer": true, "size": "M"}'),
(125, 136, 1, 22485.74, 0.0, '{"color": "Green"}'),
(126, 90, 3, 5315.07, 0.0, '{}'),
(127, 59, 1, 40657.47, 0.0, '{"warranty": "2 years", "bundle_offer": true}'),
(127, 84, 3, 7140.15, 1424.66, '{"warranty": "1 year"}'),
(127, 29, 1, 18754.28, 3554.24, '{"warranty": "1 year", "bundle_offer": true}'),
(127, 121, 3, 3205.5, 321.91, '{}'),
(128, 99, 1, 119054.1, 9075.7, '{"size": "S", "color": "Black"}'),
(128, 19, 5, 87301.84, 0.0, '{"bundle_offer": true, "color": "Black"}'),
(129, 118, 3, 4851.45, 0.0, '{"warranty": "6 months"}'),
(129, 82, 7, 8330.46, 0.0, '{"warranty": "1 year", "size": "M"}'),
(129, 116, 3, 13224.13, 0.0, '{"warranty": "2 years", "color": "Blue"}'),
(129, 65, 2, 6381.21, 2883.24, '{"warranty": "1 year", "size": "L", "color": "Red"}'),
(130, 162, 2, 9988.73, 0.0, '{"size": "S"}'),
(131, 21, 4, 10622.88, 0.0, '{"warranty": "6 months"}'),
(131, 105, 3, 17783.47, 3272.62, '{}'),
(131, 189, 3, 86614.48, 11555.5, '{"warranty": "1 year", "color": "Green"}'),
(131, 94, 2, 134479.43, 0.0, '{"warranty": "1 year", "bundle_offer": true, "color": "Black"}'),
(131, 91, 3, 3517.75, 0.0, '{"engraving": "Message"}'),
(132, 135, 2, 18778.36, 2447.59, '{"bundle_offer": true}'),
(132, 113, 3, 16010.75, 2131.01, '{"warranty": "6 months"}'),
(132, 188, 3, 25308.61, 2307.95, '{}'),
(133, 67, 4, 3377.44, 0.0, '{"size": "S"}'),
(133, 113, 1, 19690.94, 3639.61, '{"warranty": "1 year"}'),
(133, 100, 3, 15678.79, 0.0, '{"warranty": "1 year", "bundle_offer": true}'),
(133, 146, 1, 5534.45, 0.0, '{"size": "S", "engraving": "Date"}'),
(134, 56, 3, 1600.0, 0.0, '{}'),
(134, 11, 1, 6441.64, 0.0, '{}'),
(134, 54, 1, 14354.73, 0.0, '{"size": "XL"}'),
(135, 147, 3, 36904.13, 3285.64, '{"warranty": "1 year", "bundle_offer": true}'),
(136, 82, 3, 49941.55, 0.0, '{}'),
(137, 111, 3, 23977.88, 0.0, '{"warranty": "2 years", "bundle_offer": true, "size": "L", "color": "Blue"}'),
(138, 154, 1, 47469.57, 0.0, '{"warranty": "6 months"}'),
(138, 87, 10, 8455.61, 766.22, '{"bundle_offer": true}'),
(138, 38, 3, 122110.91, 50664.21, '{}'),
(139, 149, 3, 1573.38, 0.0, '{"size": "M", "installation": "Premium"}'),
(139, 87, 6, 6128.52, 0.0, '{"bundle_offer": true}'),
(140, 70, 3, 9625.21, 0.0, '{}'),
(141, 145, 3, 2517.25, 212.61, '{"bundle_offer": true}'),
(142, 42, 1, 22053.82, 0.0, '{"warranty": "2 years"}'),
(143, 143, 3, 19653.59, 0.0, '{"warranty": "6 months", "color": "Green"}'),
(143, 111, 2, 41593.43, 5703.96, '{"warranty": "1 year", "color": "Green", "gift_wrap": true}'),
(144, 68, 10, 72624.42, 7074.75, '{"warranty": "2 years", "size": "XL"}'),
(144, 147, 2, 15390.2, 0.0, '{"warranty": "1 year", "size": "S"}'),
(144, 160, 2, 113700.68, 0.0, '{"warranty": "2 years", "bundle_offer": true, "size": "S"}'),
(144, 106, 2, 50306.72, 0.0, '{"warranty": "6 months", "bundle_offer": true, "size": "M"}'),
(144, 42, 1, 89232.89, 0.0, '{"warranty": "1 year", "size": "S", "color": "Black"}'),
(145, 164, 2, 57250.85, 0.0, '{"warranty": "1 year", "bundle_offer": true, "size": "S"}'),
(146, 146, 10, 3253.66, 0.0, '{"color": "White"}'),
(146, 175, 10, 4884.41, 0.0, '{"bundle_offer": true}'),
(146, 189, 7, 7256.57, 488.33, '{"warranty": "1 year"}'),
(146, 27, 2, 104229.23, 0.0, '{}'),
(147, 150, 3, 19813.63, 2711.43, '{"bundle_offer": true, "color": "Red"}'),
(148, 59, 3, 17279.35, 2200.37, '{}'),
(148, 132, 1, 26504.06, 0.0, '{"color": "Black"}'),
(148, 72, 3, 18534.2, 0.0, '{"warranty": "6 months"}'),
(148, 106, 1, 15302.11, 0.0, '{"size": "M", "gift_wrap": true}'),
(148, 116, 2, 28429.5, 0.0, '{"bundle_offer": true, "size": "XL", "color": "White"}'),
(149, 187, 2, 1506.98, 0.0, '{"warranty": "1 year"}'),
(150, 113, 10, 107481.28, 15929.96, '{"warranty": "6 months", "engraving": "Initials"}'),
(150, 199, 3, 45526.91, 8787.74, '{}'),
(150, 38, 2, 6412.78, 0.0, '{"warranty": "1 year", "color": "Black"}'),
(150, 51, 8, 13705.51, 2472.29, '{"bundle_offer": true}'),
(151, 90, 3, 4178.35, 0.0, '{"size": "XL", "gift_wrap": true}'),
(151, 132, 8, 6198.62, 0.0, '{}'),
(151, 7, 3, 4700.79, 0.0, '{"warranty": "2 years"}'),
(152, 185, 3, 136045.91, 0.0, '{"warranty": "6 months", "bundle_offer": true}'),
(153, 91, 3, 10911.53, 0.0, '{}'),
(154, 138, 2, 13329.37, 0.0, '{"color": "White"}'),
(154, 114, 1, 64811.62, 4647.57, '{"size": "M"}'),
(154, 8, 2, 6144.69, 492.69, '{}'),
(154, 191, 2, 29799.03, 5127.98, '{"warranty": "6 months", "size": "S"}'),
(154, 79, 9, 11080.41, 722.57, '{"color": "Red"}'),
(155, 153, 1, 6341.27, 0.0, '{}'),
(155, 132, 2, 129287.42, 0.0, '{}'),
(155, 125, 1, 43891.3, 2539.83, '{"warranty": "1 year", "RAM_upgrade": "64GB"}'),
(155, 120, 2, 11105.68, 763.96, '{"bundle_offer": true, "color": "Green"}'),
(155, 94, 1, 45774.5, 0.0, '{"bundle_offer": true}'),
(156, 61, 1, 23404.2, 0.0, '{"size": "XL"}'),
(156, 30, 8, 149496.02, 29307.37, '{"warranty": "1 year", "bundle_offer": true}'),
(157, 149, 1, 13353.48, 0.0, '{"bundle_offer": true}'),
(157, 21, 2, 4534.98, 0.0, '{"warranty": "6 months", "bundle_offer": true}'),
(158, 135, 1, 44073.92, 0.0, '{"bundle_offer": true}'),
(158, 89, 8, 144158.36, 0.0, '{"warranty": "1 year"}'),
(158, 162, 1, 142757.42, 0.0, '{"warranty": "6 months", "size": "M", "RAM_upgrade": "16GB"}'),
(158, 198, 3, 8917.61, 0.0, '{"color": "Red"}'),
(158, 142, 1, 23156.67, 0.0, '{"warranty": "6 months"}'),
(159, 87, 1, 15288.68, 0.0, '{"bundle_offer": true, "color": "Blue"}'),
(159, 39, 1, 2252.93, 0.0, '{"warranty": "1 year", "size": "XL"}'),
(160, 128, 1, 17038.02, 0.0, '{"warranty": "2 years", "size": "M"}'),
(160, 40, 1, 17257.84, 0.0, '{"color": "White"}'),
(160, 34, 1, 3362.24, 602.2, '{"warranty": "2 years", "size": "XL"}'),
(160, 93, 3, 53609.02, 0.0, '{"size": "S", "color": "Blue"}'),
(161, 136, 3, 73446.93, 0.0, '{"warranty": "1 year"}'),
(161, 50, 10, 24887.52, 0.0, '{"warranty": "1 year", "bundle_offer": true, "size": "L"}'),
(161, 28, 6, 8922.8, 0.0, '{"warranty": "1 year", "color": "Black", "installation": "Premium"}'),
(162, 15, 1, 9644.02, 0.0, '{"bundle_offer": true}'),
(162, 169, 3, 51234.42, 7517.79, '{"bundle_offer": true, "color": "Blue"}'),
(162, 107, 3, 4654.45, 0.0, '{}'),
(163, 198, 1, 16109.65, 0.0, '{"bundle_offer": true}'),
(163, 46, 1, 97033.54, 0.0, '{"warranty": "6 months", "color": "Black"}'),
(163, 160, 3, 121318.85, 0.0, '{"bundle_offer": true, "size": "L", "color": "Red"}'),
(163, 108, 3, 5087.45, 0.0, '{"warranty": "6 months", "color": "Green"}'),
(163, 155, 6, 12013.95, 0.0, '{}'),
(164, 166, 1, 65300.75, 9947.75, '{"bundle_offer": true}'),
(164, 66, 3, 17268.65, 2966.99, '{"warranty": "1 year", "RAM_upgrade": "16GB"}'),
(164, 56, 2, 5076.98, 803.09, '{}'),
(165, 53, 1, 23241.21, 0.0, '{}'),
(165, 25, 3, 97655.02, 15025.8, '{"warranty": "1 year", "size": "XL"}'),
(165, 17, 1, 8530.22, 1155.31, '{"size": "L", "RAM_upgrade": "64GB"}'),
(165, 80, 1, 143520.82, 0.0, '{"bundle_offer": true, "color": "White"}'),
(166, 142, 6, 20335.23, 0.0, '{}'),
(166, 127, 1, 1297.87, 0.0, '{"size": "XL"}'),
(166, 34, 8, 49530.92, 0.0, '{"warranty": "2 years", "bundle_offer": true}'),
(166, 8, 2, 17269.88, 0.0, '{"size": "S", "storage_upgrade": "2TB HDD"}'),
(167, 47, 8, 2290.95, 729.82, '{"size": "L", "storage_upgrade": "512GB SSD"}'),
(167, 166, 3, 11234.77, 0.0, '{}'),
(167, 23, 10, 4190.49, 0.0, '{}'),
(168, 184, 3, 4600.21, 0.0, '{"color": "Black"}'),
(168, 181, 2, 15150.39, 0.0, '{}'),
(169, 70, 2, 93902.24, 7474.52, '{"bundle_offer": true, "size": "S", "gift_wrap": true}'),
(169, 197, 9, 15719.37, 0.0, '{"size": "L", "gift_wrap": true}'),
(169, 200, 3, 18243.82, 0.0, '{"color": "Red"}'),
(170, 21, 1, 13015.36, 0.0, '{"color": "Red"}'),
(170, 180, 1, 48478.85, 0.0, '{"bundle_offer": true, "engraving": "Initials"}'),
(171, 189, 3, 12158.11, 0.0, '{"warranty": "6 months", "size": "L"}'),
(171, 183, 2, 22910.13, 0.0, '{"warranty": "1 year"}'),
(171, 82, 4, 23662.9, 0.0, '{}'),
(172, 59, 2, 35074.98, 0.0, '{}'),
(172, 82, 8, 5500.78, 1047.59, '{"warranty": "1 year"}'),
(172, 94, 1, 2297.12, 407.32, '{"bundle_offer": true, "color": "Black", "storage_upgrade": "512GB SSD"}'),
(173, 46, 2, 22078.3, 0.0, '{"warranty": "6 months"}'),
(174, 80, 3, 21294.91, 0.0, '{"size": "M"}'),
(174, 189, 2, 29611.15, 5715.72, '{"bundle_offer": true}'),
(174, 170, 4, 42634.52, 2387.09, '{"warranty": "6 months", "installation": "Premium"}'),
(174, 192, 2, 29335.83, 0.0, '{}'),
(174, 76, 8, 3273.38, 0.0, '{"size": "M"}'),
(175, 31, 5, 9238.75, 0.0, '{}'),
(175, 70, 2, 24997.34, 0.0, '{"warranty": "6 months"}'),
(175, 75, 1, 4722.42, 460.45, '{"size": "S", "installation": "Basic"}'),
(175, 111, 1, 4380.31, 0.0, '{"bundle_offer": true, "size": "M"}'),
(175, 4, 1, 16437.58, 2411.79, '{}'),
(176, 122, 3, 21605.33, 0.0, '{"bundle_offer": true, "size": "L"}'),
(176, 151, 4, 3282.73, 385.53, '{"bundle_offer": true}'),
(177, 38, 2, 19558.1, 0.0, '{"warranty": "2 years", "color": "Red"}'),
(177, 146, 1, 27483.54, 4619.46, '{"warranty": "6 months"}'),
(177, 19, 3, 27853.93, 0.0, '{"warranty": "1 year"}'),
(177, 155, 3, 36245.21, 0.0, '{"size": "XL"}'),
(177, 115, 2, 88808.31, 0.0, '{"color": "Blue"}'),
(178, 92, 3, 39060.25, 4388.85, '{"warranty": "6 months", "bundle_offer": true, "size": "L", "color": "Red"}'),
(179, 142, 3, 4059.44, 0.0, '{"warranty": "2 years", "size": "XL"}'),
(179, 66, 2, 142282.75, 0.0, '{"color": "Blue"}'),
(179, 56, 1, 26109.66, 0.0, '{}'),
(179, 160, 3, 9389.13, 0.0, '{"bundle_offer": true}'),
(179, 41, 2, 5019.67, 0.0, '{"bundle_offer": true, "size": "M"}'),
(180, 163, 1, 16767.32, 3087.99, '{"warranty": "2 years"}'),
(180, 172, 2, 15381.12, 0.0, '{}'),
(180, 185, 1, 25405.1, 0.0, '{"warranty": "1 year", "installation": "Professional"}'),
(180, 122, 2, 97371.51, 0.0, '{"color": "Red"}'),
(180, 100, 9, 8629.53, 1419.35, '{"bundle_offer": true}'),
(181, 18, 1, 19412.39, 2306.8, '{"bundle_offer": true}'),
(181, 42, 2, 5178.29, 782.55, '{"bundle_offer": true, "color": "Red"}'),
(182, 5, 10, 10712.9, 1589.36, '{"warranty": "2 years", "size": "M"}'),
(183, 169, 3, 75976.02, 0.0, '{"bundle_offer": true, "size": "M"}'),
(183, 160, 3, 11221.21, 0.0, '{"warranty": "1 year", "bundle_offer": true, "RAM_upgrade": "16GB"}'),
(183, 197, 3, 12249.94, 0.0, '{}'),
(183, 178, 2, 1833.77, 0.0, '{"bundle_offer": true}'),
(183, 181, 2, 13273.42, 0.0, '{"color": "Black"}'),
(184, 109, 2, 6400.6, 0.0, '{"warranty": "2 years", "color": "Black"}'),
(184, 165, 3, 121328.68, 0.0, '{"bundle_offer": true}'),
(185, 120, 2, 12092.06, 0.0, '{"warranty": "6 months"}'),
(185, 11, 2, 9106.86, 0.0, '{}'),
(185, 197, 1, 11263.08, 606.96, '{"bundle_offer": true, "size": "M", "engraving": "Message"}'),
(186, 7, 3, 1351.57, 216.08, '{"RAM_upgrade": "64GB"}'),
(186, 101, 1, 8074.08, 946.92, '{"color": "White"}'),
(186, 194, 1, 17005.5, 1866.73, '{"warranty": "1 year", "bundle_offer": true, "size": "S", "color": "Black"}'),
(187, 24, 2, 99312.15, 0.0, '{}'),
(187, 194, 2, 13419.93, 0.0, '{"size": "M"}'),
(187, 138, 2, 7028.7, 0.0, '{"bundle_offer": true, "color": "Green"}'),
(187, 199, 2, 87523.43, 0.0, '{}'),
(187, 197, 1, 90633.78, 0.0, '{"warranty": "6 months"}'),
(188, 142, 8, 17645.88, 955.01, '{"size": "XL"}'),
(188, 48, 3, 1102.02, 0.0, '{"warranty": "1 year", "size": "XL", "color": "White"}'),
(188, 67, 3, 10323.06, 1559.51, '{"bundle_offer": true, "color": "Blue"}'),
(189, 20, 1, 97567.32, 0.0, '{"size": "M"}'),
(189, 28, 1, 19665.55, 0.0, '{"warranty": "6 months", "size": "S", "color": "Green"}'),
(189, 21, 1, 10127.67, 0.0, '{}'),
(189, 102, 9, 20406.55, 0.0, '{}'),
(190, 198, 3, 8468.38, 0.0, '{"bundle_offer": true, "size": "XL", "color": "Red"}'),
(190, 39, 2, 28335.27, 0.0, '{"warranty": "6 months", "size": "S"}'),
(191, 5, 8, 32076.35, 5218.24, '{"color": "Black", "engraving": "Date"}'),
(191, 87, 3, 22299.69, 1701.93, '{"warranty": "1 year"}'),
(192, 80, 9, 8424.29, 1495.68, '{"size": "XL"}'),
(193, 53, 1, 26002.55, 0.0, '{"warranty": "1 year", "size": "M"}'),
(193, 17, 1, 13542.57, 1338.98, '{"warranty": "1 year"}'),
(193, 46, 3, 12484.88, 0.0, '{}'),
(193, 156, 2, 18310.87, 0.0, '{"bundle_offer": true}'),
(194, 29, 8, 105104.98, 0.0, '{"color": "Red"}'),
(194, 141, 2, 7448.75, 0.0, '{"warranty": "1 year", "bundle_offer": true, "color": "Black"}'),
(194, 157, 3, 26072.73, 8276.31, '{"size": "L"}'),
(194, 155, 1, 7087.62, 0.0, '{"warranty": "1 year", "color": "Blue"}'),
(195, 179, 6, 17390.56, 0.0, '{"warranty": "6 months", "color": "Black", "gift_wrap": true}'),
(195, 198, 1, 2952.28, 216.05, '{"size": "M", "installation": "Professional"}'),
(195, 131, 3, 18869.38, 0.0, '{"warranty": "2 years", "size": "S"}'),
(195, 128, 1, 43043.74, 0.0, '{}'),
(196, 75, 3, 44153.15, 8330.6, '{"warranty": "1 year"}'),
(196, 96, 3, 8391.05, 0.0, '{"size": "S"}'),
(196, 1, 3, 27767.37, 2481.91, '{"warranty": "1 year", "bundle_offer": true}'),
(196, 103, 1, 6376.89, 0.0, '{}'),
(197, 3, 3, 6373.38, 0.0, '{"size": "M"}'),
(197, 148, 7, 29361.39, 2114.12, '{"color": "White", "installation": "Basic"}'),
(198, 26, 2, 28917.85, 0.0, '{"warranty": "6 months", "size": "XL"}'),
(198, 191, 2, 34550.45, 0.0, '{"warranty": "1 year", "engraving": "Date"}'),
(198, 154, 1, 53349.66, 0.0, '{"warranty": "1 year", "size": "XL"}'),
(198, 177, 7, 15481.06, 0.0, '{"bundle_offer": true, "size": "L"}'),
(199, 144, 6, 1979.4, 0.0, '{"warranty": "2 years", "color": "Black", "gift_wrap": true}'),
(199, 118, 1, 19928.22, 0.0, '{"warranty": "2 years", "bundle_offer": true}'),
(199, 16, 8, 5343.61, 0.0, '{}'),
(199, 88, 6, 14422.25, 0.0, '{"warranty": "1 year"}'),
(199, 140, 2, 31576.69, 12907.93, '{"warranty": "2 years", "bundle_offer": true}'),
(200, 13, 3, 46849.1, 0.0, '{"installation": "Premium"}'),
(200, 170, 3, 1739.21, 0.0, '{"bundle_offer": true}'),
(200, 26, 2, 4777.2, 0.0, '{"warranty": "1 year"}'),
(200, 60, 1, 10982.36, 0.0, '{}');


INSERT INTO departments (name, location, metadata)
VALUES
('Customer Service', 'Abuja Helpdesk', '{"budget": "\u20a619M", "channels": ["Phone", "Email", "Chat", "Social Media"], "sla": "24-hour response time"}'),
('Operations', 'Port Harcourt Warehouse', '{"budget": "\u20a6104M", "facilities": ["Main Warehouse", "Quality Assurance", "Regional Distribution Centers"], "coverage": "National"}'),
('Marketing', 'Lagos Creative Center', '{"budget": "\u20a663M", "channels": ["Social Media", "Content Marketing", "Search Ads", "Influencers"], "target_demographic": "Business Owners"}'),
('Operations 2', 'Lagos Logistics Hub', '{"budget": "\u20a659M", "facilities": ["Main Warehouse", "Regional Distribution Centers", "Fleet Management", "Inventory Control"], "coverage": "National"}'),
('Marketing 2', 'Abuja Strategy Office', '{"budget": "\u20a651M", "channels": ["Events", "Email", "Content Marketing"], "target_demographic": "Business Owners"}'),
('Customer Service 2', 'Port Harcourt Support Office', '{"budget": "\u20a617M", "channels": ["Phone", "Email", "Chat", "Social Media"], "sla": "24-hour response time"}'),
('Finance', 'Abuja Regional Office', '{"budget": "\u20a6294M", "responsibilities": ["Accounts Payable", "Accounts Receivable", "Payroll", "Financial Reporting", "Tax Compliance", "Auditing"], "reporting_frequency": "Monthly"}'),
('Customer Service 3', 'Abuja Helpdesk', '{"budget": "\u20a633M", "channels": ["Phone", "Email", "Chat", "Social Media"], "sla": "24-hour response time"}'),
('Operations 3', 'Port Harcourt Warehouse', '{"budget": "\u20a669M", "facilities": ["Inventory Control", "Main Warehouse", "Quality Assurance", "Fleet Management"], "coverage": "National"}'),
('Operations 4', 'Port Harcourt Warehouse', '{"budget": "\u20a6108M", "facilities": ["Main Warehouse", "Quality Assurance"], "coverage": "National"}'),
('Marketing 3', 'Lagos Creative Center', '{"budget": "\u20a658M", "channels": ["Radio", "Search Ads", "Events", "Influencers"], "target_demographic": "Business Owners"}'),
('Human Resources', 'Lagos HQ', '{"budget": "\u20a618M", "functions": ["Recruitment", "Training & Development", "Compensation & Benefits", "Employee Relations", "Performance Management"], "employee_count": 292}'),
('Sales', 'Kano Regional Office', '{"budget": "\u20a6138M", "target_market": "Nigeria", "sales_quota": "\u20a627M/month"}');


INSERT INTO employees (name, department_id, manager_id, role, hire_date, salary, contact_info, skills)
VALUES
('Deborah Ogunleye', 1, NULL, 'Head of Sales', '2019-05-07', 5157.77, '{"email": "deborah.ogunleye418@company.com", "phone": "+2348092369125"}', '{"sales_skills": ["Sales Forecasting", "Key Account Management"], "soft_skills": ["Decision Making", "Presentation", "Leadership"]}'),
('Funke Adeleke', 1, NULL, 'Sales Manager', '2015-06-21', 7526.48, '{"email": "funke.adeleke636@company.com", "phone": "+2348077430538"}', '{"sales_skills": ["Strategic Planning", "Key Account Management", "CRM Systems"], "soft_skills": ["Presentation"]}'),
('Chioma Onyema', 1, NULL, 'Regional Sales Lead', '2016-05-24', 3846.4, '{"email": "chioma.onyema343@company.com", "phone": "+2348036589329"}', '{"sales_skills": ["Sales Forecasting", "Strategic Planning", "Key Account Management"], "soft_skills": ["Negotiation", "Decision Making", "Presentation"]}'),
('Chukwu Onyeama', 1, 3, 'Sales Representative', '2023-12-30', 2720.6, '{"email": "chukwu.onyeama879@company.com", "phone": "+2348036414394"}', '{"sales_skills": ["Prospecting", "Product Knowledge"], "soft_skills": ["Communication"]}'),
('Amara Eze', 1, 1, 'Business Development', '2021-11-01', 2033.18, '{"email": "amara.eze169@company.com", "phone": "+2348072248937"}', '{"sales_skills": ["Customer Engagement"], "soft_skills": ["Active Listening"]}'),
('Kunle Bakare', 1, 1, 'Sales Representative', '2018-11-19', 2755.7, '{"email": "kunle.bakare339@company.com", "phone": "+2348074327962"}', '{"sales_skills": ["Prospecting", "Customer Engagement"], "soft_skills": ["Active Listening", "Communication", "Resilience"]}'),
('Chiamaka Oladipo', 1, 2, 'Sales Representative', '2019-06-28', 2695.48, '{"email": "chiamaka.oladipo147@company.com", "phone": "+2348097718733"}', '{"sales_skills": ["Prospecting", "Product Knowledge", "Sales Presentations"], "soft_skills": ["Active Listening", "Resilience"]}'),
('Chioma Okafor', 1, 3, 'Account Executive', '2022-03-30', 4919.44, '{"email": "chioma.okafor296@company.com", "phone": "+2348031375910"}', '{"sales_skills": ["Product Knowledge"], "soft_skills": ["Active Listening", "Persuasion"]}'),
('Nneka Uche', 1, 2, 'Sales Representative', '2018-10-03', 4460.45, '{"email": "nneka.uche525@company.com", "phone": "+2348099341515"}', '{"sales_skills": ["Customer Engagement", "Product Knowledge"], "soft_skills": ["Active Listening", "Persuasion"]}'),
('Wale Okoro', 1, 3, 'Sales Representative', '2021-07-05', 4628.02, '{"email": "wale.okoro735@company.com", "phone": "+2348037545362"}', '{"sales_skills": ["Prospecting", "Customer Engagement", "Sales Presentations"], "soft_skills": ["Active Listening"]}'),
('Chinedu Umar', 1, 3, 'Sales Representative', '2024-02-10', 3034.27, '{"email": "chinedu.umar45@company.com", "phone": "+2348042751563"}', '{"sales_skills": ["Product Knowledge", "Customer Engagement"], "soft_skills": ["Communication"]}'),
('Chioma Bello', 1, 2, 'Business Development', '2020-12-11', 3997.63, '{"email": "chioma.bello631@company.com", "phone": "+2348027065550"}', '{"sales_skills": ["Customer Engagement", "Sales Presentations", "Prospecting"], "soft_skills": ["Communication", "Active Listening", "Persuasion"]}'),
('Chinedu Balogun', 1, 3, 'Sales Associate', '2022-12-14', 3121.73, '{"email": "chinedu.balogun44@company.com", "phone": "+2348008115172"}', '{"sales_skills": ["Prospecting", "Sales Presentations", "Customer Engagement"], "soft_skills": ["Communication", "Resilience"]}'),
('Funke Onyema', 1, 1, 'Sales Associate', '2025-03-03', 3617.45, '{"email": "funke.onyema480@company.com", "phone": "+2348035602041"}', '{"sales_skills": ["Sales Presentations", "Product Knowledge", "Customer Engagement"], "soft_skills": ["Persuasion", "Active Listening", "Resilience"]}'),
('Musa Okonkwo', 1, 3, 'Business Development', '2022-07-26', 2336.04, '{"email": "musa.okonkwo475@company.com", "phone": "+2348001004545"}', '{"sales_skills": ["Customer Engagement", "Sales Presentations", "Product Knowledge"], "soft_skills": ["Resilience", "Persuasion"]}'),
('Wale Ojo', 1, 3, 'Sales Associate', '2019-05-01', 2762.47, '{"email": "wale.ojo807@company.com", "phone": "+2348061370620"}', '{"sales_skills": ["Product Knowledge", "Customer Engagement"], "soft_skills": ["Active Listening", "Communication", "Persuasion"]}'),
('Nneka Ogbonna', 1, 1, 'Sales Representative', '2020-05-17', 3419.67, '{"email": "nneka.ogbonna943@company.com", "phone": "+2348000841172"}', '{"sales_skills": ["Customer Engagement", "Sales Presentations", "Product Knowledge"], "soft_skills": ["Active Listening", "Communication"]}'),
('Chinedu Okafor', 1, 3, 'Business Development', '2019-11-08', 4850.07, '{"email": "chinedu.okafor36@company.com", "phone": "+2348004634217"}', '{"sales_skills": ["Customer Engagement"], "soft_skills": ["Active Listening", "Resilience", "Communication"]}'),
('Funke Akinwande', 1, 3, 'Account Executive', '2023-06-28', 2658.89, '{"email": "funke.akinwande76@company.com", "phone": "+2348059747011"}', '{"sales_skills": ["Product Knowledge", "Customer Engagement"], "soft_skills": ["Persuasion", "Communication"]}'),
('Chiamaka Eze', 1, 1, 'Account Executive', '2019-07-30', 2788.98, '{"email": "chiamaka.eze129@company.com", "phone": "+2348072779597"}', '{"sales_skills": ["Customer Engagement", "Sales Presentations"], "soft_skills": ["Active Listening", "Resilience"]}'),
('Aisha Adeyemi', 1, 3, 'Sales Representative', '2021-09-22', 4966.87, '{"email": "aisha.adeyemi421@company.com", "phone": "+2348053256789"}', '{"sales_skills": ["Sales Presentations", "Prospecting", "Customer Engagement"], "soft_skills": ["Resilience"]}'),
('Amina Umar', 1, 3, 'Sales Associate', '2019-08-09', 2436.99, '{"email": "amina.umar797@company.com", "phone": "+2348087843611"}', '{"sales_skills": ["Customer Engagement", "Sales Presentations"], "soft_skills": ["Resilience"]}'),
('Abdul Uche', 1, 2, 'Sales Representative', '2023-06-24', 3609.32, '{"email": "abdul.uche849@company.com", "phone": "+2348013458916"}', '{"sales_skills": ["Sales Presentations", "Product Knowledge", "Prospecting"], "soft_skills": ["Active Listening", "Resilience"]}'),
('Femi Adewale', 1, 1, 'Sales Associate', '2018-04-11', 3267.32, '{"email": "femi.adewale937@company.com", "phone": "+2348017016215"}', '{"sales_skills": ["Customer Engagement", "Prospecting", "Product Knowledge"], "soft_skills": ["Active Listening", "Persuasion", "Resilience"]}'),
('Sani Ojo', 1, 1, 'Business Development', '2023-10-14', 4328.0, '{"email": "sani.ojo200@company.com", "phone": "+2348075250458"}', '{"sales_skills": ["Sales Presentations", "Customer Engagement", "Product Knowledge"], "soft_skills": ["Resilience", "Communication"]}'),
('Yusuf Okonkwo', 1, 1, 'Account Executive', '2020-09-29', 2008.83, '{"email": "yusuf.okonkwo335@company.com", "phone": "+2348023438412"}', '{"sales_skills": ["Product Knowledge"], "soft_skills": ["Resilience", "Persuasion", "Active Listening"]}'),
('Kunle Mohammed', 1, 2, 'Account Executive', '2020-12-12', 3723.24, '{"email": "kunle.mohammed822@company.com", "phone": "+2348010097875"}', '{"sales_skills": ["Prospecting", "Product Knowledge", "Sales Presentations"], "soft_skills": ["Communication"]}'),
('Musa Uche', 1, 2, 'Sales Associate', '2023-03-25', 3242.79, '{"email": "musa.uche760@company.com", "phone": "+2348045741992"}', '{"sales_skills": ["Product Knowledge"], "soft_skills": ["Resilience", "Persuasion"]}'),
('Amina Ogbonna', 2, NULL, 'Tech Lead', '2018-09-20', 6486.91, '{"email": "amina.ogbonna122@company.com", "phone": "+2348085776411"}', '{"technical_skills": ["Security", "DevOps"], "management_skills": ["Budgeting"]}'),
('Obinna Adeleke', 2, NULL, 'Tech Lead', '2016-11-28', 7075.19, '{"email": "obinna.adeleke726@company.com", "phone": "+2348059725459"}', '{"technical_skills": ["Security", "Cloud Infrastructure"], "management_skills": ["Project Management"]}'),
('Chiamaka Oladipo', 2, NULL, 'CTO', '2017-07-14', 7792.74, '{"email": "chiamaka.oladipo88@company.com", "phone": "+2348018778100"}', '{"technical_skills": ["Cloud Infrastructure", "System Architecture", "DevOps"], "management_skills": ["Team Leadership"]}'),
('Zainab Okoh', 2, 29, 'System Admin', '2021-01-26', 4138.34, '{"email": "zainab.okoh129@company.com", "phone": "+2348005288279"}', '{"technical_skills": ["Programming"], "certifications": ["AWS Certified", "Microsoft Certified", "Cisco Certified"]}'),
('Kunle Ibrahim', 2, 31, 'System Admin', '2025-03-06', 2562.54, '{"email": "kunle.ibrahim142@company.com", "phone": "+2348096936577"}', '{"technical_skills": ["Troubleshooting", "Database Management", "Programming"], "certifications": ["AWS Certified", "CompTIA", "Cisco Certified"]}'),
('Chiamaka Ogbonna', 2, 30, 'System Admin', '2024-10-27', 3261.91, '{"email": "chiamaka.ogbonna915@company.com", "phone": "+2348097269641"}', '{"technical_skills": ["Programming"], "certifications": ["Microsoft Certified"]}'),
('Chioma Uche', 2, 30, 'Software Engineer', '2021-12-13', 4477.04, '{"email": "chioma.uche439@company.com", "phone": "+2348034511573"}', '{"technical_skills": ["Database Management", "Networking", "Programming"], "certifications": ["Cisco Certified", "CompTIA"]}'),
('Amara Onyia', 2, 29, 'Software Engineer', '2020-09-03', 2495.15, '{"email": "amara.onyia559@company.com", "phone": "+2348026859961"}', '{"technical_skills": ["Programming", "Networking", "Troubleshooting"], "certifications": ["Cisco Certified"]}'),
('Yewande Onyeka', 2, 31, 'Network Engineer', '2022-03-03', 2247.47, '{"email": "yewande.onyeka78@company.com", "phone": "+2348052818888"}', '{"technical_skills": ["Database Management"], "certifications": ["Microsoft Certified", "CompTIA"]}'),
('Funke Onyia', 2, 31, 'IT Support', '2021-09-07', 3557.91, '{"email": "funke.onyia435@company.com", "phone": "+2348034742404"}', '{"technical_skills": ["Database Management", "Programming"], "certifications": ["Cisco Certified", "CompTIA", "AWS Certified"]}'),
('Chinedu Onyeama', 2, 29, 'Data Analyst', '2018-02-01', 4410.49, '{"email": "chinedu.onyeama602@company.com", "phone": "+2348041437347"}', '{"technical_skills": ["Programming", "Database Management"], "certifications": ["Microsoft Certified", "CompTIA", "Cisco Certified"]}'),
('Femi Eze', 2, 31, 'Software Engineer', '2018-10-18', 2871.25, '{"email": "femi.eze786@company.com", "phone": "+2348068821252"}', '{"technical_skills": ["Database Management", "Programming", "Networking"], "certifications": ["Cisco Certified", "Microsoft Certified"]}'),
('Ifeoma Uche', 2, 30, 'Data Analyst', '2018-04-26', 3441.41, '{"email": "ifeoma.uche951@company.com", "phone": "+2348052177116"}', '{"technical_skills": ["Programming"], "certifications": ["Microsoft Certified", "Cisco Certified"]}'),
('Wale Adeleke', 2, 31, 'Network Engineer', '2021-01-07', 3779.84, '{"email": "wale.adeleke757@company.com", "phone": "+2348097383512"}', '{"technical_skills": ["Troubleshooting", "Networking"], "certifications": ["CompTIA", "AWS Certified", "Cisco Certified"]}'),
('Ifeoma Onyema', 2, 30, 'Software Engineer', '2018-03-13', 3820.02, '{"email": "ifeoma.onyema971@company.com", "phone": "+2348034920902"}', '{"technical_skills": ["Programming", "Database Management"], "certifications": ["AWS Certified"]}'),
('Chinedu Balogun', 2, 29, 'Network Engineer', '2023-02-04', 4154.61, '{"email": "chinedu.balogun918@company.com", "phone": "+2348062786751"}', '{"technical_skills": ["Database Management"], "certifications": ["CompTIA", "Cisco Certified", "Microsoft Certified"]}'),
('Wale Uche', 2, 30, 'IT Support', '2018-03-30', 4559.37, '{"email": "wale.uche74@company.com", "phone": "+2348008749003"}', '{"technical_skills": ["Troubleshooting", "Database Management"], "certifications": ["CompTIA"]}'),
('Yusuf Adeyemi', 2, 29, 'Software Engineer', '2018-12-30', 3374.51, '{"email": "yusuf.adeyemi600@company.com", "phone": "+2348012252418"}', '{"technical_skills": ["Programming", "Database Management"], "certifications": ["AWS Certified", "Microsoft Certified", "CompTIA"]}'),
('Sani Adeleke', 2, 29, 'Software Engineer', '2018-08-04', 4162.38, '{"email": "sani.adeleke694@company.com", "phone": "+2348042294825"}', '{"technical_skills": ["Programming", "Networking", "Database Management"], "certifications": ["AWS Certified"]}'),
('Yewande Okafor', 2, 30, 'Data Analyst', '2021-08-14', 4844.48, '{"email": "yewande.okafor58@company.com", "phone": "+2348069979426"}', '{"technical_skills": ["Programming", "Troubleshooting", "Networking"], "certifications": ["Cisco Certified", "Microsoft Certified"]}'),
('Sani Balogun', 2, 29, 'Software Engineer', '2024-12-23', 4932.16, '{"email": "sani.balogun126@company.com", "phone": "+2348079007048"}', '{"technical_skills": ["Programming"], "certifications": ["Cisco Certified"]}'),
('Yewande Adewale', 2, 30, 'Data Analyst', '2023-02-19', 4534.28, '{"email": "yewande.adewale313@company.com", "phone": "+2348028279949"}', '{"technical_skills": ["Networking"], "certifications": ["Microsoft Certified"]}'),
('Nneka Akinwande', 3, NULL, 'Digital Marketing Lead', '2018-07-24', 9944.07, '{"email": "nneka.akinwande762@company.com", "phone": "+2348071027690"}', '{"marketing_skills": ["Market Research", "Digital Marketing"], "analytical_skills": ["ROI Analysis"]}'),
('Ebere Adeyemi', 3, NULL, 'Digital Marketing Lead', '2016-06-04', 9730.84, '{"email": "ebere.adeyemi994@company.com", "phone": "+2348040590604"}', '{"marketing_skills": ["Brand Strategy", "Campaign Management", "Market Research"], "analytical_skills": ["Customer Segmentation", "Budget Management", "ROI Analysis"]}'),
('Femi Ogbonna', 3, NULL, 'Marketing Director', '2019-05-10', 9938.61, '{"email": "femi.ogbonna521@company.com", "phone": "+2348080742798"}', '{"marketing_skills": ["Brand Strategy", "Campaign Management"], "analytical_skills": ["ROI Analysis", "Customer Segmentation"]}'),
('Okonkwo Adeyemi', 3, 53, 'SEO Analyst', '2024-12-29', 3976.36, '{"email": "okonkwo.adeyemi336@company.com", "phone": "+2348059529786"}', '{"marketing_skills": ["Content Creation", "Email Marketing", "Social Media"], "creative_skills": ["Copywriting", "Graphic Design", "Video Production"]}'),
('Obinna Eze', 3, 53, 'Marketing Specialist', '2025-02-27', 2304.76, '{"email": "obinna.eze914@company.com", "phone": "+2348086087743"}', '{"marketing_skills": ["Email Marketing", "SEO/SEM", "Social Media"], "creative_skills": ["UX/UI", "Graphic Design"]}'),
('Amara Balogun', 3, 53, 'Content Creator', '2021-09-17', 1935.08, '{"email": "amara.balogun103@company.com", "phone": "+2348028245892"}', '{"marketing_skills": ["SEO/SEM"], "creative_skills": ["Copywriting", "Video Production"]}'),
('Ngozi Onyia', 3, 53, 'Social Media Manager', '2024-08-24', 2404.03, '{"email": "ngozi.onyia82@company.com", "phone": "+2348093483172"}', '{"marketing_skills": ["Email Marketing"], "creative_skills": ["Copywriting", "Graphic Design"]}'),
('Nneka Aliyu', 3, 53, 'Social Media Manager', '2019-12-26', 3262.26, '{"email": "nneka.aliyu919@company.com", "phone": "+2348079397912"}', '{"marketing_skills": ["Content Creation"], "creative_skills": ["Graphic Design", "Copywriting"]}'),
('Chioma Okafor', 3, 51, 'Marketing Specialist', '2022-04-08', 2503.34, '{"email": "chioma.okafor669@company.com", "phone": "+2348068759203"}', '{"marketing_skills": ["Social Media", "SEO/SEM", "Content Creation"], "creative_skills": ["Video Production", "UX/UI"]}'),
('Sani Ibrahim', 3, 53, 'Content Creator', '2020-01-20', 1754.93, '{"email": "sani.ibrahim821@company.com", "phone": "+2348026240664"}', '{"marketing_skills": ["Email Marketing", "Social Media"], "creative_skills": ["Graphic Design", "UX/UI", "Video Production"]}'),
('Jide Alade', 3, 53, 'Marketing Specialist', '2021-02-12', 1787.02, '{"email": "jide.alade164@company.com", "phone": "+2348052382627"}', '{"marketing_skills": ["Social Media", "Content Creation"], "creative_skills": ["Video Production"]}'),
('Jide Adeleke', 3, 51, 'SEO Analyst', '2021-02-16', 2127.89, '{"email": "jide.adeleke210@company.com", "phone": "+2348068978442"}', '{"marketing_skills": ["Email Marketing"], "creative_skills": ["Copywriting", "UX/UI"]}'),
('Tunde Okoro', 3, 51, 'SEO Analyst', '2024-03-04', 2451.66, '{"email": "tunde.okoro774@company.com", "phone": "+2348046327768"}', '{"marketing_skills": ["Email Marketing"], "creative_skills": ["UX/UI", "Video Production", "Graphic Design"]}'),
('Wale Umar', 3, 51, 'Social Media Manager', '2021-05-03', 4368.54, '{"email": "wale.umar12@company.com", "phone": "+2348015862928"}', '{"marketing_skills": ["SEO/SEM", "Content Creation", "Social Media"], "creative_skills": ["Copywriting", "UX/UI"]}'),
('Adanna Bakare', 3, 51, 'Content Creator', '2020-03-24', 2470.18, '{"email": "adanna.bakare783@company.com", "phone": "+2348003070888"}', '{"marketing_skills": ["Email Marketing"], "creative_skills": ["Graphic Design"]}'),
('Kunle Okafor', 3, 51, 'Content Creator', '2024-05-30', 2324.74, '{"email": "kunle.okafor37@company.com", "phone": "+2348033415859"}', '{"marketing_skills": ["Social Media"], "creative_skills": ["UX/UI"]}'),
('Fatima Akinwande', 3, 52, 'Social Media Manager', '2024-02-14', 4085.0, '{"email": "fatima.akinwande680@company.com", "phone": "+2348019113672"}', '{"marketing_skills": ["Social Media", "SEO/SEM", "Content Creation"], "creative_skills": ["Video Production", "Copywriting", "Graphic Design"]}'),
('Zainab Chukwu', 3, 53, 'Marketing Specialist', '2018-06-03', 3601.6, '{"email": "zainab.chukwu421@company.com", "phone": "+2348055803683"}', '{"marketing_skills": ["Email Marketing", "Content Creation"], "creative_skills": ["Graphic Design", "Copywriting", "UX/UI"]}'),
('Emeka Onyema', 3, 53, 'Content Creator', '2022-02-19', 1556.8, '{"email": "emeka.onyema87@company.com", "phone": "+2348012056925"}', '{"marketing_skills": ["Content Creation", "Email Marketing", "SEO/SEM"], "creative_skills": ["Video Production", "Copywriting"]}'),
('Chinedu Ogunleye', 3, 52, 'Content Creator', '2019-04-15', 3923.45, '{"email": "chinedu.ogunleye775@company.com", "phone": "+2348098638289"}', '{"marketing_skills": ["Social Media", "Email Marketing"], "creative_skills": ["Graphic Design", "UX/UI", "Copywriting"]}'),
('Yewande Akintola', 3, 53, 'Marketing Specialist', '2020-01-10', 3464.76, '{"email": "yewande.akintola354@company.com", "phone": "+2348058903508"}', '{"marketing_skills": ["Content Creation", "SEO/SEM"], "creative_skills": ["Copywriting", "UX/UI", "Video Production"]}'),
('Musa Mohammed', 3, 52, 'SEO Analyst', '2024-11-28', 4646.79, '{"email": "musa.mohammed54@company.com", "phone": "+2348097632937"}', '{"marketing_skills": ["Content Creation", "SEO/SEM"], "creative_skills": ["Copywriting"]}'),
('Femi Adeyemi', 4, NULL, 'Accounting Lead', '2018-01-06', 5307.34, '{"email": "femi.adeyemi669@company.com", "phone": "+2348046486889"}', '{"finance_skills": ["Compliance", "Investment Analysis"], "certifications": ["CFA", "ACCA", "FRM"]}'),
('Sani Akintola', 4, NULL, 'Financial Controller', '2020-06-29', 6748.78, '{"email": "sani.akintola677@company.com", "phone": "+2348051545488"}', '{"finance_skills": ["Risk Management"], "certifications": ["CPA"]}'),
('Tunde Mohammed', 4, NULL, 'Financial Controller', '2016-09-19', 4909.86, '{"email": "tunde.mohammed963@company.com", "phone": "+2348093876805"}', '{"finance_skills": ["Financial Planning"], "certifications": ["ACCA"]}'),
('Musa Oladipo', 4, 73, 'Auditor', '2018-11-16', 1600.66, '{"email": "musa.oladipo894@company.com", "phone": "+2348038153301"}', '{"finance_skills": ["Bookkeeping"], "software_skills": ["Oracle Financials", "Excel", "SAP"]}'),
('Amara Onyeama', 4, 75, 'Auditor', '2020-10-12', 3069.22, '{"email": "amara.onyeama323@company.com", "phone": "+2348020779363"}', '{"finance_skills": ["Payroll Processing", "Bookkeeping"], "software_skills": ["SAP", "Excel", "QuickBooks"]}'),
('Sani Okoro', 4, 74, 'Auditor', '2025-03-19', 4018.3, '{"email": "sani.okoro426@company.com", "phone": "+2348024815817"}', '{"finance_skills": ["Payroll Processing"], "software_skills": ["Excel"]}'),
('Oluwaseun Alade', 4, 74, 'Payroll Specialist', '2023-06-27', 3231.77, '{"email": "oluwaseun.alade53@company.com", "phone": "+2348064170358"}', '{"finance_skills": ["Tax Preparation"], "software_skills": ["Excel", "Oracle Financials"]}'),
('Kunle Bakare', 4, 75, 'Financial Analyst', '2018-12-16', 2880.09, '{"email": "kunle.bakare2@company.com", "phone": "+2348099024281"}', '{"finance_skills": ["Bookkeeping", "Payroll Processing"], "software_skills": ["QuickBooks", "SAP", "Oracle Financials"]}'),
('Wale Ogunleye', 4, 73, 'Auditor', '2021-03-19', 4725.9, '{"email": "wale.ogunleye37@company.com", "phone": "+2348027522214"}', '{"finance_skills": ["Tax Preparation", "Bookkeeping"], "software_skills": ["Oracle Financials"]}'),
('Ebere Onyeka', 4, 73, 'Financial Analyst', '2019-10-20', 1876.85, '{"email": "ebere.onyeka761@company.com", "phone": "+2348000261203"}', '{"finance_skills": ["Payroll Processing"], "software_skills": ["QuickBooks", "Excel"]}'),
('Fatima Balogun', 4, 73, 'Payroll Specialist', '2021-01-24', 4231.01, '{"email": "fatima.balogun872@company.com", "phone": "+2348089636896"}', '{"finance_skills": ["Bookkeeping", "Payroll Processing"], "software_skills": ["SAP", "QuickBooks"]}'),
('Zainab Mohammed', 4, 74, 'Auditor', '2021-04-22', 3416.71, '{"email": "zainab.mohammed95@company.com", "phone": "+2348075376209"}', '{"finance_skills": ["Payroll Processing", "Financial Reporting", "Tax Preparation"], "software_skills": ["Excel", "QuickBooks"]}'),
('Oluwaseun Akinwande', 4, 74, 'Accountant', '2021-05-25', 4974.02, '{"email": "oluwaseun.akinwande220@company.com", "phone": "+2348060083045"}', '{"finance_skills": ["Bookkeeping"], "software_skills": ["SAP", "Oracle Financials", "Excel"]}'),
('Jide Onyema', 4, 75, 'Accountant', '2021-07-06', 2640.53, '{"email": "jide.onyema238@company.com", "phone": "+2348068092852"}', '{"finance_skills": ["Bookkeeping", "Tax Preparation"], "software_skills": ["Oracle Financials", "Excel"]}'),
('Fatima Mohammed', 4, 75, 'Payroll Specialist', '2024-09-18', 2407.93, '{"email": "fatima.mohammed698@company.com", "phone": "+2348000936664"}', '{"finance_skills": ["Bookkeeping", "Tax Preparation", "Financial Reporting"], "software_skills": ["Oracle Financials", "SAP", "Excel"]}'),
('Ebere Ogbonna', 4, 75, 'Financial Analyst', '2024-04-10', 4702.34, '{"email": "ebere.ogbonna424@company.com", "phone": "+2348092859418"}', '{"finance_skills": ["Payroll Processing"], "software_skills": ["QuickBooks", "Excel"]}'),
('Sani Okafor', 4, 73, 'Payroll Specialist', '2020-05-20', 3034.52, '{"email": "sani.okafor413@company.com", "phone": "+2348070795050"}', '{"finance_skills": ["Payroll Processing", "Tax Preparation"], "software_skills": ["Oracle Financials"]}'),
('Femi Ogunleye', 5, NULL, 'Operations Manager', '2019-06-15', 7240.61, '{"email": "femi.ogunleye65@company.com", "phone": "+2348024604189"}', '{"operations_skills": ["Process Optimization", "Supply Chain Management"], "management_skills": ["Vendor Negotiation"]}'),
('Wale Sule', 5, NULL, 'Logistics Director', '2019-04-19', 3665.44, '{"email": "wale.sule671@company.com", "phone": "+2348014789087"}', '{"operations_skills": ["Logistics", "Process Optimization", "Quality Control"], "management_skills": ["Team Leadership"]}'),
('Yusuf Onyeama', 5, NULL, 'Operations Manager', '2020-08-27', 9755.02, '{"email": "yusuf.onyeama842@company.com", "phone": "+2348072511699"}', '{"operations_skills": ["Supply Chain Management"], "management_skills": ["Vendor Negotiation", "Team Leadership"]}'),
('Tunde Onyeama', 5, 92, 'Facilities Manager', '2023-02-23', 3935.12, '{"email": "tunde.onyeama816@company.com", "phone": "+2348096347340"}', '{"operations_skills": ["Facility Management"], "technical_skills": ["Six Sigma"]}'),
('Tunde Onyeka', 5, 92, 'Facilities Manager', '2024-11-10', 3506.95, '{"email": "tunde.onyeka827@company.com", "phone": "+2348047649954"}', '{"operations_skills": ["Documentation", "Facility Management", "Order Fulfillment"], "technical_skills": ["Six Sigma", "Safety Compliance"]}'),
('Chiamaka Adeleke', 5, 90, 'Operations Coordinator', '2021-01-31', 3914.64, '{"email": "chiamaka.adeleke123@company.com", "phone": "+2348017602797"}', '{"operations_skills": ["Facility Management", "Order Fulfillment"], "technical_skills": ["Six Sigma", "Warehouse Management", "ERP Systems"]}'),
('Nneka Okoh', 5, 91, 'Operations Coordinator', '2018-02-21', 4715.1, '{"email": "nneka.okoh180@company.com", "phone": "+2348069919353"}', '{"operations_skills": ["Order Fulfillment", "Inventory Management", "Documentation"], "technical_skills": ["Six Sigma"]}'),
('Wale Okoro', 5, 91, 'Facilities Manager', '2023-09-10', 2097.02, '{"email": "wale.okoro778@company.com", "phone": "+2348005414687"}', '{"operations_skills": ["Order Fulfillment"], "technical_skills": ["Safety Compliance", "ERP Systems", "Six Sigma"]}'),
('Wale Adeleke', 5, 92, 'Inventory Specialist', '2021-01-01', 3363.35, '{"email": "wale.adeleke552@company.com", "phone": "+2348046199199"}', '{"operations_skills": ["Inventory Management", "Order Fulfillment"], "technical_skills": ["Warehouse Management", "Six Sigma"]}'),
('Abdul Ibrahim', 5, 91, 'Facilities Manager', '2022-03-10', 3614.71, '{"email": "abdul.ibrahim696@company.com", "phone": "+2348010883187"}', '{"operations_skills": ["Documentation"], "technical_skills": ["ERP Systems", "Six Sigma", "Warehouse Management"]}'),
('Kunle Uche', 5, 91, 'Quality Assurance', '2022-02-12', 3886.81, '{"email": "kunle.uche590@company.com", "phone": "+2348001744378"}', '{"operations_skills": ["Documentation", "Facility Management"], "technical_skills": ["Safety Compliance"]}'),
('Jide Adeleke', 5, 91, 'Inventory Specialist', '2025-04-30', 2542.35, '{"email": "jide.adeleke739@company.com", "phone": "+2348073349842"}', '{"operations_skills": ["Order Fulfillment", "Facility Management"], "technical_skills": ["Safety Compliance", "ERP Systems", "Warehouse Management"]}'),
('Okonkwo Onyia', 5, 91, 'Inventory Specialist', '2018-04-17', 1706.43, '{"email": "okonkwo.onyia383@company.com", "phone": "+2348056070257"}', '{"operations_skills": ["Facility Management"], "technical_skills": ["Six Sigma", "Safety Compliance"]}'),
('Chioma Okoro', 5, 91, 'Quality Assurance', '2021-08-19', 4022.03, '{"email": "chioma.okoro371@company.com", "phone": "+2348063285029"}', '{"operations_skills": ["Facility Management"], "technical_skills": ["Warehouse Management", "Six Sigma"]}'),
('Aisha Oladipo', 5, 92, 'Inventory Specialist', '2022-12-03', 2857.63, '{"email": "aisha.oladipo736@company.com", "phone": "+2348001734119"}', '{"operations_skills": ["Documentation"], "technical_skills": ["Six Sigma"]}'),
('Yewande Okafor', 5, 90, 'Facilities Manager', '2021-10-30', 3429.0, '{"email": "yewande.okafor64@company.com", "phone": "+2348020738875"}', '{"operations_skills": ["Facility Management", "Inventory Management"], "technical_skills": ["Six Sigma"]}'),
('Ngozi Aliyu', 5, 92, 'Operations Coordinator', '2020-10-11', 2799.05, '{"email": "ngozi.aliyu568@company.com", "phone": "+2348082068925"}', '{"operations_skills": ["Facility Management", "Inventory Management"], "technical_skills": ["Safety Compliance", "ERP Systems"]}'),
('Fatima Aliyu', 6, NULL, 'Talent Acquisition Lead', '2018-10-22', 5914.9, '{"email": "fatima.aliyu927@company.com", "phone": "+2348052935091"}', '{"hr_skills": ["Employee Relations"], "certifications": ["SHRM-CP", "SPHR", "HRCI"]}'),
('Chukwu Nwosu', 6, NULL, 'HR Manager', '2019-12-19', 6015.05, '{"email": "chukwu.nwosu411@company.com", "phone": "+2348020906159"}', '{"hr_skills": ["Performance Management", "Talent Acquisition", "Compensation & Benefits"], "certifications": ["HRCI", "PHR", "SPHR"]}'),
('Okonkwo Oladipo', 6, NULL, 'HR Manager', '2015-09-30', 4071.41, '{"email": "okonkwo.oladipo95@company.com", "phone": "+2348023843327"}', '{"hr_skills": ["Compensation & Benefits"], "certifications": ["SHRM-CP"]}'),
('Sani Okoh', 6, 108, 'Recruiter', '2018-01-07', 3333.96, '{"email": "sani.okoh853@company.com", "phone": "+2348023440072"}', '{"hr_skills": ["Recruitment", "Onboarding", "HR Administration"], "soft_skills": ["Communication", "Conflict Resolution"]}'),
('Sani Nwosu', 6, 107, 'HR Associate', '2022-04-08', 2822.68, '{"email": "sani.nwosu456@company.com", "phone": "+2348082969442"}', '{"hr_skills": ["HR Administration", "Recruitment", "Training Coordination"], "soft_skills": ["Empathy"]}'),
('Ifeoma Okonkwo', 6, 107, 'Training Coordinator', '2018-06-05', 3642.47, '{"email": "ifeoma.okonkwo461@company.com", "phone": "+2348045599358"}', '{"hr_skills": ["Training Coordination", "HR Administration"], "soft_skills": ["Discretion", "Empathy"]}'),
('Musa Okoh', 6, 107, 'HR Associate', '2022-08-12', 2562.66, '{"email": "musa.okoh490@company.com", "phone": "+2348052449833"}', '{"hr_skills": ["Recruitment", "Onboarding"], "soft_skills": ["Empathy", "Conflict Resolution"]}'),
('Amina Ogunleye', 6, 108, 'Training Coordinator', '2025-04-06', 1881.95, '{"email": "amina.ogunleye362@company.com", "phone": "+2348097754435"}', '{"hr_skills": ["Training Coordination"], "soft_skills": ["Empathy", "Communication", "Discretion"]}'),
('Zainab Adeyemi', 6, 107, 'Training Coordinator', '2018-03-07', 3736.3, '{"email": "zainab.adeyemi293@company.com", "phone": "+2348036245055"}', '{"hr_skills": ["HR Administration", "Training Coordination"], "soft_skills": ["Communication", "Discretion"]}'),
('Chiamaka Sule', 6, 107, 'Training Coordinator', '2021-05-20', 1920.68, '{"email": "chiamaka.sule981@company.com", "phone": "+2348037220494"}', '{"hr_skills": ["HR Administration", "Training Coordination", "Recruitment"], "soft_skills": ["Communication"]}'),
('Oluwaseun Onyema', 6, 108, 'HR Associate', '2020-06-28', 1973.57, '{"email": "oluwaseun.onyema662@company.com", "phone": "+2348086475241"}', '{"hr_skills": ["Onboarding", "HR Administration", "Training Coordination"], "soft_skills": ["Discretion", "Empathy", "Conflict Resolution"]}'),
('Obinna Aliyu', 6, 107, 'HR Associate', '2022-03-05', 4573.81, '{"email": "obinna.aliyu612@company.com", "phone": "+2348017502837"}', '{"hr_skills": ["Onboarding", "HR Administration"], "soft_skills": ["Communication"]}'),
('Oluwaseun Akinwande', 6, 109, 'Training Coordinator', '2021-07-13', 4825.88, '{"email": "oluwaseun.akinwande849@company.com", "phone": "+2348077772756"}', '{"hr_skills": ["Training Coordination", "Onboarding"], "soft_skills": ["Communication"]}'),
('Jide Sule', 6, 109, 'Compensation Analyst', '2024-07-23', 4565.63, '{"email": "jide.sule188@company.com", "phone": "+2348018291247"}', '{"hr_skills": ["Onboarding", "Recruitment", "Training Coordination"], "soft_skills": ["Discretion", "Conflict Resolution"]}'),
('Ngozi Onyeka', 6, 108, 'Training Coordinator', '2024-07-09', 1539.09, '{"email": "ngozi.onyeka232@company.com", "phone": "+2348067312286"}', '{"hr_skills": ["Training Coordination", "HR Administration", "Recruitment"], "soft_skills": ["Communication"]}'),
('Abdul Eze', 6, 109, 'Compensation Analyst', '2020-10-12', 2273.71, '{"email": "abdul.eze645@company.com", "phone": "+2348011047504"}', '{"hr_skills": ["Training Coordination"], "soft_skills": ["Conflict Resolution", "Communication", "Empathy"]}'),
('Aisha Balogun', 6, 108, 'Recruiter', '2021-03-03', 2635.35, '{"email": "aisha.balogun603@company.com", "phone": "+2348054432999"}', '{"hr_skills": ["HR Administration", "Training Coordination"], "soft_skills": ["Discretion"]}'),
('Musa Oladipo', 7, NULL, 'Customer Service Manager', '2019-05-31', 9481.77, '{"email": "musa.oladipo482@company.com", "phone": "+2348060978588"}', '{"service_skills": ["Quality Assurance"], "management_skills": ["Team Leadership"]}'),
('Funke Mohammed', 7, NULL, 'Customer Service Manager', '2020-10-18', 7826.8, '{"email": "funke.mohammed949@company.com", "phone": "+2348076372606"}', '{"service_skills": ["Service Strategy", "Complaint Resolution", "Customer Experience"], "management_skills": ["Process Improvement", "Team Leadership"]}'),
('Funke Bakare', 7, 124, 'Helpdesk Technician', '2018-10-19', 4491.46, '{"email": "funke.bakare11@company.com", "phone": "+2348033829957"}', '{"service_skills": ["Phone Etiquette", "Ticket Management"], "soft_skills": ["Communication", "Patience", "Problem Solving"]}'),
('Chukwu Nwosu', 7, 124, 'Client Success Agent', '2022-02-02', 2892.12, '{"email": "chukwu.nwosu218@company.com", "phone": "+2348070697225"}', '{"service_skills": ["Product Knowledge"], "soft_skills": ["Empathy"]}'),
('Sani Chukwu', 7, 125, 'Helpdesk Technician', '2022-01-16', 2519.45, '{"email": "sani.chukwu428@company.com", "phone": "+2348080245760"}', '{"service_skills": ["Product Knowledge"], "soft_skills": ["Patience", "Empathy", "Problem Solving"]}'),
('Aisha Ogunleye', 7, 124, 'Customer Support', '2023-04-30', 1946.9, '{"email": "aisha.ogunleye938@company.com", "phone": "+2348080983377"}', '{"service_skills": ["Product Knowledge", "Ticket Management"], "soft_skills": ["Patience"]}'),
('Zainab Ogbonna', 7, 124, 'Client Success Agent', '2022-10-23', 3912.65, '{"email": "zainab.ogbonna770@company.com", "phone": "+2348060314209"}', '{"service_skills": ["Customer Retention"], "soft_skills": ["Communication", "Patience", "Empathy"]}'),
('Nneka Aliyu', 7, 125, 'Helpdesk Technician', '2021-05-25', 1575.58, '{"email": "nneka.aliyu414@company.com", "phone": "+2348074972843"}', '{"service_skills": ["Phone Etiquette", "Product Knowledge"], "soft_skills": ["Communication", "Patience"]}'),
('Emeka Okonkwo', 7, 124, 'Client Success Agent', '2021-08-20', 4192.66, '{"email": "emeka.okonkwo860@company.com", "phone": "+2348061909535"}', '{"service_skills": ["Customer Retention"], "soft_skills": ["Patience", "Communication", "Empathy"]}'),
('Okonkwo Balogun', 7, 124, 'Customer Support', '2021-12-13', 3133.68, '{"email": "okonkwo.balogun107@company.com", "phone": "+2348072751339"}', '{"service_skills": ["Phone Etiquette", "Customer Retention", "Product Knowledge"], "soft_skills": ["Communication"]}'),
('Tunde Onyeama', 7, 125, 'Helpdesk Technician', '2022-09-28', 4491.08, '{"email": "tunde.onyeama184@company.com", "phone": "+2348056576198"}', '{"service_skills": ["Phone Etiquette", "Ticket Management"], "soft_skills": ["Problem Solving", "Communication"]}'),
('Nneka Umar', 8, NULL, 'Sales Manager', '2019-01-26', 5240.27, '{"email": "nneka.umar984@company.com", "phone": "+2348024075278"}', '{"sales_skills": ["Sales Forecasting"], "soft_skills": ["Decision Making"]}'),
('Musa Adeleke', 8, NULL, 'Sales Manager', '2020-05-12', 8060.59, '{"email": "musa.adeleke306@company.com", "phone": "+2348072975775"}', '{"sales_skills": ["Sales Forecasting", "Strategic Planning"], "soft_skills": ["Presentation", "Decision Making", "Leadership"]}'),
('Funke Bello', 8, 136, 'Sales Associate', '2018-01-13', 1881.29, '{"email": "funke.bello435@company.com", "phone": "+2348080094501"}', '{"sales_skills": ["Prospecting", "Customer Engagement"], "soft_skills": ["Communication", "Active Listening", "Persuasion"]}'),
('Obinna Aliyu', 8, 136, 'Sales Associate', '2021-08-26', 2136.56, '{"email": "obinna.aliyu33@company.com", "phone": "+2348030233838"}', '{"sales_skills": ["Product Knowledge", "Customer Engagement", "Sales Presentations"], "soft_skills": ["Active Listening"]}'),
('Obinna Onyeka', 8, 136, 'Sales Associate', '2023-08-05', 2795.68, '{"email": "obinna.onyeka307@company.com", "phone": "+2348068926226"}', '{"sales_skills": ["Product Knowledge"], "soft_skills": ["Communication", "Active Listening", "Resilience"]}'),
('Nneka Okoh', 8, 136, 'Account Executive', '2022-05-21', 4994.82, '{"email": "nneka.okoh113@company.com", "phone": "+2348023743897"}', '{"sales_skills": ["Customer Engagement"], "soft_skills": ["Resilience", "Active Listening", "Communication"]}'),
('Wale Okoro', 8, 136, 'Sales Associate', '2022-08-28', 2790.83, '{"email": "wale.okoro641@company.com", "phone": "+2348027625074"}', '{"sales_skills": ["Sales Presentations"], "soft_skills": ["Resilience"]}'),
('Chiamaka Onyeama', 8, 135, 'Account Executive', '2025-04-14', 2097.86, '{"email": "chiamaka.onyeama418@company.com", "phone": "+2348029056832"}', '{"sales_skills": ["Prospecting"], "soft_skills": ["Persuasion", "Resilience", "Active Listening"]}'),
('Chiamaka Oladipo', 8, 135, 'Business Development', '2019-10-26', 4811.73, '{"email": "chiamaka.oladipo190@company.com", "phone": "+2348040823734"}', '{"sales_skills": ["Customer Engagement"], "soft_skills": ["Communication"]}'),
('Emeka Ibrahim', 8, 136, 'Business Development', '2024-06-18', 2601.45, '{"email": "emeka.ibrahim857@company.com", "phone": "+2348014209166"}', '{"sales_skills": ["Customer Engagement", "Sales Presentations"], "soft_skills": ["Communication"]}'),
('Yewande Ibrahim', 8, 136, 'Sales Representative', '2022-03-03', 3964.7, '{"email": "yewande.ibrahim37@company.com", "phone": "+2348029737358"}', '{"sales_skills": ["Sales Presentations", "Prospecting"], "soft_skills": ["Resilience"]}'),
('Chiamaka Mohammed', 9, NULL, 'Tech Lead', '2019-02-08', 6064.03, '{"email": "chiamaka.mohammed667@company.com", "phone": "+2348037644365"}', '{"technical_skills": ["Security", "DevOps", "System Architecture"], "management_skills": ["Budgeting", "Vendor Management"]}'),
('Aisha Onyia', 9, NULL, 'IT Manager', '2018-09-01', 6761.67, '{"email": "aisha.onyia143@company.com", "phone": "+2348063974463"}', '{"technical_skills": ["System Architecture", "Security"], "management_skills": ["Vendor Management", "Project Management"]}'),
('Adanna Adeleke', 9, 146, 'Data Analyst', '2025-05-02', 2024.76, '{"email": "adanna.adeleke983@company.com", "phone": "+2348082521499"}', '{"technical_skills": ["Networking", "Troubleshooting", "Programming"], "certifications": ["Cisco Certified", "AWS Certified", "CompTIA"]}'),
('Fatima Ogunleye', 9, 147, 'Software Engineer', '2021-03-23', 1558.61, '{"email": "fatima.ogunleye66@company.com", "phone": "+2348066117792"}', '{"technical_skills": ["Programming", "Networking", "Database Management"], "certifications": ["Cisco Certified", "CompTIA"]}'),
('Aisha Umar', 9, 146, 'IT Support', '2021-05-07', 3085.88, '{"email": "aisha.umar333@company.com", "phone": "+2348097250794"}', '{"technical_skills": ["Database Management", "Networking", "Programming"], "certifications": ["Microsoft Certified"]}'),
('Femi Onyeama', 9, 147, 'Network Engineer', '2018-05-02', 3196.19, '{"email": "femi.onyeama908@company.com", "phone": "+2348073062539"}', '{"technical_skills": ["Programming"], "certifications": ["Cisco Certified"]}'),
('Fatima Ibrahim', 9, 147, 'IT Support', '2022-12-07', 4794.81, '{"email": "fatima.ibrahim250@company.com", "phone": "+2348082028905"}', '{"technical_skills": ["Programming", "Database Management"], "certifications": ["Cisco Certified"]}'),
('Yewande Umar', 9, 146, 'System Admin', '2019-12-07', 2720.53, '{"email": "yewande.umar616@company.com", "phone": "+2348016215791"}', '{"technical_skills": ["Database Management", "Programming"], "certifications": ["CompTIA", "Cisco Certified"]}'),
('Ebere Akinwande', 9, 147, 'Network Engineer', '2023-12-01', 4783.08, '{"email": "ebere.akinwande302@company.com", "phone": "+2348085055631"}', '{"technical_skills": ["Database Management", "Networking"], "certifications": ["CompTIA", "AWS Certified", "Microsoft Certified"]}'),
('Emeka Umar', 9, 147, 'System Admin', '2021-01-04', 2152.35, '{"email": "emeka.umar700@company.com", "phone": "+2348050943332"}', '{"technical_skills": ["Troubleshooting"], "certifications": ["CompTIA", "Microsoft Certified"]}'),
('Nneka Nwosu', 9, 146, 'System Admin', '2022-10-29', 2872.5, '{"email": "nneka.nwosu452@company.com", "phone": "+2348038016242"}', '{"technical_skills": ["Troubleshooting", "Networking", "Database Management"], "certifications": ["Cisco Certified"]}'),
('Kunle Okonkwo', 10, NULL, 'Marketing Director', '2019-07-13', 8037.89, '{"email": "kunle.okonkwo132@company.com", "phone": "+2348014566148"}', '{"marketing_skills": ["Digital Marketing"], "analytical_skills": ["Customer Segmentation", "KPI Tracking"]}'),
('Abdul Bakare', 10, NULL, 'Marketing Director', '2020-03-26', 4411.43, '{"email": "abdul.bakare78@company.com", "phone": "+2348032483741"}', '{"marketing_skills": ["Campaign Management", "Brand Strategy"], "analytical_skills": ["Budget Management", "ROI Analysis"]}'),
('Chinedu Akinwande', 10, 157, 'Marketing Specialist', '2018-06-29', 3771.88, '{"email": "chinedu.akinwande994@company.com", "phone": "+2348068024078"}', '{"marketing_skills": ["Content Creation", "Email Marketing", "SEO/SEM"], "creative_skills": ["UX/UI", "Video Production"]}'),
('Nneka Alade', 10, 158, 'Marketing Specialist', '2019-01-30', 2393.26, '{"email": "nneka.alade564@company.com", "phone": "+2348060292879"}', '{"marketing_skills": ["Social Media", "SEO/SEM"], "creative_skills": ["Video Production"]}'),
('Okonkwo Adeleke', 10, 158, 'Social Media Manager', '2018-12-05', 2205.36, '{"email": "okonkwo.adeleke61@company.com", "phone": "+2348023283473"}', '{"marketing_skills": ["Email Marketing"], "creative_skills": ["UX/UI", "Graphic Design"]}'),
('Chioma Okoro', 10, 157, 'Social Media Manager', '2019-05-19', 1553.55, '{"email": "chioma.okoro104@company.com", "phone": "+2348045583439"}', '{"marketing_skills": ["Content Creation", "SEO/SEM"], "creative_skills": ["Graphic Design", "UX/UI"]}'),
('Zainab Onyeka', 10, 157, 'Social Media Manager', '2025-05-18', 4808.21, '{"email": "zainab.onyeka600@company.com", "phone": "+2348065853332"}', '{"marketing_skills": ["Email Marketing", "Content Creation"], "creative_skills": ["Copywriting", "Graphic Design"]}'),
('Ebere Umar', 10, 158, 'Marketing Specialist', '2024-02-28', 1872.69, '{"email": "ebere.umar603@company.com", "phone": "+2348068602400"}', '{"marketing_skills": ["Email Marketing", "Content Creation"], "creative_skills": ["Video Production"]}'),
('Nneka Sule', 10, 158, 'Marketing Specialist', '2023-11-24', 4183.47, '{"email": "nneka.sule549@company.com", "phone": "+2348067186329"}', '{"marketing_skills": ["Social Media"], "creative_skills": ["Video Production"]}'),
('Aisha Adeyemi', 10, 157, 'Social Media Manager', '2019-05-04', 1814.72, '{"email": "aisha.adeyemi334@company.com", "phone": "+2348086254378"}', '{"marketing_skills": ["Content Creation", "SEO/SEM"], "creative_skills": ["Video Production", "Copywriting", "UX/UI"]}'),
('Nneka Nwosu', 10, 157, 'Content Creator', '2022-03-09', 4894.56, '{"email": "nneka.nwosu186@company.com", "phone": "+2348000128217"}', '{"marketing_skills": ["Email Marketing", "SEO/SEM", "Social Media"], "creative_skills": ["Graphic Design", "Video Production"]}'),
('Yewande Adeyemi', 11, NULL, 'Finance Manager', '2018-10-20', 4698.38, '{"email": "yewande.adeyemi448@company.com", "phone": "+2348026279528"}', '{"finance_skills": ["Investment Analysis", "Financial Planning", "Compliance"], "certifications": ["CPA", "CFA", "FRM"]}'),
('Fatima Okonkwo', 11, 168, 'Payroll Specialist', '2024-12-06', 2034.34, '{"email": "fatima.okonkwo311@company.com", "phone": "+2348030091801"}', '{"finance_skills": ["Bookkeeping"], "software_skills": ["Excel"]}'),
('Okonkwo Okafor', 11, 168, 'Payroll Specialist', '2019-11-06', 4343.64, '{"email": "okonkwo.okafor604@company.com", "phone": "+2348098996131"}', '{"finance_skills": ["Payroll Processing"], "software_skills": ["Excel", "SAP", "Oracle Financials"]}'),
('Ngozi Onyeama', 11, 168, 'Payroll Specialist', '2020-07-09', 2309.22, '{"email": "ngozi.onyeama719@company.com", "phone": "+2348083403725"}', '{"finance_skills": ["Tax Preparation"], "software_skills": ["Oracle Financials", "Excel", "QuickBooks"]}'),
('Yewande Akintola', 11, 168, 'Auditor', '2019-10-03', 2879.5, '{"email": "yewande.akintola988@company.com", "phone": "+2348095125218"}', '{"finance_skills": ["Tax Preparation"], "software_skills": ["Oracle Financials", "SAP"]}'),
('Musa Nwosu', 12, NULL, 'Logistics Director', '2020-01-27', 7902.43, '{"email": "musa.nwosu136@company.com", "phone": "+2348021829185"}', '{"operations_skills": ["Quality Control"], "management_skills": ["Team Leadership", "Budget Management"]}'),
('Deborah Nwosu', 12, 173, 'Quality Assurance', '2025-03-06', 1573.28, '{"email": "deborah.nwosu312@company.com", "phone": "+2348010954277"}', '{"operations_skills": ["Inventory Management"], "technical_skills": ["Safety Compliance", "Warehouse Management", "Six Sigma"]}'),
('Fatima Okonkwo', 12, 173, 'Quality Assurance', '2022-05-29', 4669.33, '{"email": "fatima.okonkwo969@company.com", "phone": "+2348086624752"}', '{"operations_skills": ["Order Fulfillment", "Inventory Management", "Documentation"], "technical_skills": ["Six Sigma", "ERP Systems"]}'),
('Jide Onyeka', 12, 173, 'Quality Assurance', '2020-02-24', 4871.88, '{"email": "jide.onyeka269@company.com", "phone": "+2348078980198"}', '{"operations_skills": ["Facility Management", "Inventory Management", "Order Fulfillment"], "technical_skills": ["Safety Compliance"]}'),
('Yewande Okonkwo', 12, 173, 'Operations Coordinator', '2018-04-14', 2462.94, '{"email": "yewande.okonkwo668@company.com", "phone": "+2348035730360"}', '{"operations_skills": ["Documentation", "Facility Management"], "technical_skills": ["Six Sigma"]}'),
('Chioma Alade', 13, NULL, 'Talent Acquisition Lead', '2017-01-10', 5753.18, '{"email": "chioma.alade179@company.com", "phone": "+2348084450426"}', '{"hr_skills": ["Compensation & Benefits", "Performance Management"], "certifications": ["HRCI"]}'),
('Okonkwo Ogunleye', 13, 178, 'Training Coordinator', '2021-08-11', 3393.89, '{"email": "okonkwo.ogunleye749@company.com", "phone": "+2348037537638"}', '{"hr_skills": ["HR Administration", "Training Coordination"], "soft_skills": ["Communication", "Conflict Resolution", "Discretion"]}'),
('Abdul Ogunleye', 13, 178, 'HR Associate', '2024-03-21', 4748.98, '{"email": "abdul.ogunleye550@company.com", "phone": "+2348002625217"}', '{"hr_skills": ["HR Administration"], "soft_skills": ["Conflict Resolution", "Communication", "Discretion"]}'),
('Abdul Okafor', 13, 178, 'Recruiter', '2019-10-07', 3317.25, '{"email": "abdul.okafor425@company.com", "phone": "+2348080209910"}', '{"hr_skills": ["Onboarding", "Training Coordination"], "soft_skills": ["Discretion"]}'),
('Aisha Onyeama', 13, 178, 'Compensation Analyst', '2024-04-24', 4188.5, '{"email": "aisha.onyeama991@company.com", "phone": "+2348073579970"}', '{"hr_skills": ["Training Coordination", "HR Administration"], "soft_skills": ["Communication", "Discretion"]}'),
('Abdul Adeleke', 14, NULL, 'Customer Service Manager', '2017-12-22', 9539.58, '{"email": "abdul.adeleke930@company.com", "phone": "+2348059145302"}', '{"service_skills": ["Complaint Resolution"], "management_skills": ["Process Improvement", "Performance Metrics"]}'),
('Zainab Uche', 14, 183, 'Service Coordinator', '2024-03-14', 4397.85, '{"email": "zainab.uche671@company.com", "phone": "+2348028957506"}', '{"service_skills": ["Phone Etiquette", "Ticket Management", "Customer Retention"], "soft_skills": ["Empathy", "Patience", "Communication"]}'),
('Yusuf Ibrahim', 14, 183, 'Client Success Agent', '2023-08-13', 2982.86, '{"email": "yusuf.ibrahim381@company.com", "phone": "+2348068623585"}', '{"service_skills": ["Ticket Management", "Phone Etiquette", "Customer Retention"], "soft_skills": ["Patience", "Problem Solving"]}'),
('Ifeoma Balogun', 14, 183, 'Client Success Agent', '2023-08-19', 2701.32, '{"email": "ifeoma.balogun154@company.com", "phone": "+2348049909481"}', '{"service_skills": ["Product Knowledge", "Phone Etiquette", "Ticket Management"], "soft_skills": ["Patience", "Empathy", "Communication"]}'),
('Abdul Balogun', 14, 183, 'Customer Support', '2020-01-07', 3034.21, '{"email": "abdul.balogun439@company.com", "phone": "+2348042756458"}', '{"service_skills": ["Phone Etiquette", "Customer Retention", "Product Knowledge"], "soft_skills": ["Communication", "Patience"]}'),
('Chiamaka Aliyu', 15, NULL, 'Head of Sales', '2019-11-18', 8330.46, '{"email": "chiamaka.aliyu149@company.com", "phone": "+2348060811692"}', '{"sales_skills": ["CRM Systems", "Sales Forecasting", "Strategic Planning"], "soft_skills": ["Negotiation"]}'),
('Ebere Alade', 15, 188, 'Sales Associate', '2024-03-25', 1592.26, '{"email": "ebere.alade691@company.com", "phone": "+2348086600556"}', '{"sales_skills": ["Product Knowledge", "Sales Presentations"], "soft_skills": ["Persuasion", "Communication"]}'),
('Fatima Okonkwo', 15, 188, 'Business Development', '2018-05-17', 2935.41, '{"email": "fatima.okonkwo279@company.com", "phone": "+2348020967868"}', '{"sales_skills": ["Product Knowledge", "Prospecting"], "soft_skills": ["Active Listening", "Resilience"]}'),
('Deborah Uche', 15, 188, 'Account Executive', '2020-09-03', 3098.69, '{"email": "deborah.uche436@company.com", "phone": "+2348066060646"}', '{"sales_skills": ["Prospecting"], "soft_skills": ["Active Listening", "Resilience", "Persuasion"]}'),
('Kunle Bakare', 15, 188, 'Account Executive', '2019-04-18', 1887.55, '{"email": "kunle.bakare181@company.com", "phone": "+2348006701917"}', '{"sales_skills": ["Product Knowledge", "Customer Engagement"], "soft_skills": ["Communication", "Resilience", "Persuasion"]}');


SELECT 'Employee Count by Department' as Info;
SELECT 
    d.name as department_name,
    COUNT(e.employee_id) as employee_count,
    AVG(e.salary) as avg_salary
FROM departments d
LEFT JOIN employees e ON d.department_id = e.department_id
GROUP BY d.department_id, d.name
ORDER BY employee_count DESC;

-- =====================================================
-- SQL ASSIGNMENT: SUBQUERIES AND CTEs
-- =====================================================

-- Question 1: Find employees whose salary is above the average salary for their department
-- Reasoning: This uses a subquery to calculate the average salary per department,
-- then joins it with the employees table to compare individual salaries against their department average.

SELECT 
    e.name, 
    e.department_id, 
    e.role, 
    e.salary,
    ROUND(dept_avg.avg_salary, 2) as department_avg_salary,
    ROUND(((e.salary - dept_avg.avg_salary) / dept_avg.avg_salary) * 100, 2) as percentage_above_avg
FROM employees e
JOIN (
    SELECT 
        department_id,
        AVG(salary) as avg_salary
    FROM employees
    GROUP BY department_id
) dept_avg ON e.department_id = dept_avg.department_id
WHERE e.salary > dept_avg.avg_salary
ORDER BY e.department_id, e.salary DESC;

-- =====================================================

-- Question 2: Retrieve customer details for all customers who have placed orders over ₦1000
-- Reasoning: Uses a subquery with IN clause to find customers who have at least one order above ₦1000,
-- then retrieves their complete details including contact info and preferences.
SELECT 
    c.customer_id,
    c.name,
    c.email,
    c.phone,
    JSON_UNQUOTE(JSON_EXTRACT(c.address, '$.city')) as city,
    JSON_UNQUOTE(JSON_EXTRACT(c.address, '$.zip')) as zip_code,
    JSON_UNQUOTE(JSON_EXTRACT(c.preferences, '$.marketing_opt_in')) as marketing_opt_in,
    JSON_EXTRACT(c.preferences, '$.categories') as preferred_categories,
    COUNT(o.order_id) as total_orders,
    SUM(o.total_amount) as total_spent,
    MAX(o.total_amount) as highest_order_amount
FROM customers c
JOIN orders o ON c.customer_id = o.customer_id
WHERE c.customer_id IN (
    SELECT DISTINCT customer_id
    FROM orders
    WHERE total_amount > 1000
)
GROUP BY c.customer_id, c.name, c.email, c.phone, c.address, c.preferences
ORDER BY total_spent DESC;

-- =====================================================

-- Question 3 & 4: Find orders where total amount > customer's average AND 
-- customer's total spending > global average
-- Reasoning: Uses CTEs to calculate customer statistics and global averages,
-- then filters orders based on both conditions. This identifies high-value orders
-- from high-spending customers.

WITH customer_stats AS (
    -- Calculate each customer's average order amount and total spending
    SELECT 
        customer_id,
        AVG(total_amount) as avg_order_amount,
        SUM(total_amount) as total_spending,
        COUNT(*) as total_orders,
        MIN(total_amount) as min_order,
        MAX(total_amount) as max_order
    FROM orders
    GROUP BY customer_id
),
global_averages AS (
    -- Calculate global average customer spending
    SELECT 
        AVG(total_spending) as global_avg_spending,
        AVG(avg_order_amount) as global_avg_order_amount,
        AVG(total_orders) as global_avg_order_count
    FROM customer_stats
)
SELECT 
    o.order_id,
    c.name as customer_name,
    c.email,
    JSON_UNQUOTE(JSON_EXTRACT(c.address, '$.city')) as customer_city,
    o.customer_id,
    o.order_date,
    o.total_amount,
    o.status,
    JSON_UNQUOTE(JSON_EXTRACT(o.metadata, '$.source')) as order_source,
    JSON_UNQUOTE(JSON_EXTRACT(o.metadata, '$.coupon')) as coupon_used,
    ROUND(cs.avg_order_amount, 2) as customer_avg_order,
    ROUND(cs.total_spending, 2) as customer_total_spending,
    ROUND(ga.global_avg_spending, 2) as global_avg_spending,
    cs.total_orders as customer_order_count,
    ROUND((o.total_amount / cs.avg_order_amount - 1) * 100, 2) as pct_above_personal_avg,
    ROUND((cs.total_spending / ga.global_avg_spending - 1) * 100, 2) as pct_above_global_avg
FROM orders o
JOIN customers c ON o.customer_id = c.customer_id
JOIN customer_stats cs ON o.customer_id = cs.customer_id
CROSS JOIN global_averages ga
WHERE o.total_amount > cs.avg_order_amount
    AND cs.total_spending > ga.global_avg_spending
    AND o.status IN ('Delivered', 'Shipped', 'Processing')  -- Exclude cancelled/pending orders
ORDER BY o.total_amount DESC, cs.total_spending DESC;