-- DevOpsPath SQL Course: E-Commerce Sample Data -- Usage: sqlite3 ecommerce.db < seed_data.sql -- Run after schema.sql -- ============================================================ -- CATEGORIES (15 total — some with parent_id for hierarchy) -- ============================================================ INSERT INTO categories (id, name, parent_id, description, created_at) VALUES (1, 'Electronics', NULL, 'Electronic devices and accessories', '2023-01-01 00:00:00'), (2, 'Clothing', NULL, 'Apparel for men, women, and children', '2023-01-01 00:00:00'), (3, 'Books', NULL, 'Physical and digital books', '2023-01-01 00:00:00'), (4, 'Home & Garden', NULL, 'Home decor, furniture, and garden supplies', '2023-01-01 00:00:00'), (5, 'Sports & Outdoors', NULL, 'Sports equipment and outdoor gear', '2023-01-01 00:00:00'), (6, 'Toys & Games', NULL, 'Toys, board games, and puzzles', '2023-01-01 00:00:00'), (7, 'Health & Beauty', NULL, 'Health, wellness, and beauty products', '2023-01-01 00:00:00'), (8, 'Smartphones', 1, 'Mobile phones and accessories', '2023-01-01 00:00:00'), (9, 'Laptops', 1, 'Laptop computers and accessories', '2023-01-01 00:00:00'), (10, 'Audio', 1, 'Headphones, speakers, and audio equipment', '2023-01-01 00:00:00'), (11, 'Men''s Clothing', 2, 'Clothing for men', '2023-01-01 00:00:00'), (12, 'Women''s Clothing', 2, 'Clothing for women', '2023-01-01 00:00:00'), (13, 'Fiction', 3, 'Fiction and literature', '2023-01-01 00:00:00'), (14, 'Non-Fiction', 3, 'Non-fiction and reference books', '2023-01-01 00:00:00'), (15, 'Kitchen', 4, 'Kitchen appliances and utensils', '2023-01-01 00:00:00'); -- ============================================================ -- CUSTOMERS (55 total) -- ============================================================ INSERT INTO customers (id, first_name, last_name, email, city, state, country, signup_date, is_active) VALUES (1, 'James', 'Wilson', 'james.wilson@example.com', 'Austin', 'TX', 'US', '2023-01-15 09:30:00', 1), (2, 'Maria', 'Garcia', 'maria.garcia@example.com', 'Los Angeles', 'CA', 'US', '2023-01-22 14:15:00', 1), (3, 'Robert', 'Johnson', 'robert.johnson@example.com', 'Chicago', 'IL', 'US', '2023-02-03 11:00:00', 1), (4, 'Sarah', 'Chen', 'sarah.chen@example.com', 'San Francisco', 'CA', 'US', '2023-02-14 16:45:00', 1), (5, 'Michael', 'Brown', 'michael.brown@example.com', 'New York', 'NY', 'US', '2023-02-28 08:20:00', 1), (6, 'Emily', 'Davis', 'emily.davis@example.com', 'Seattle', 'WA', 'US', '2023-03-10 10:30:00', 1), (7, 'David', 'Martinez', 'david.martinez@example.com', 'Miami', 'FL', 'US', '2023-03-18 13:00:00', 1), (8, 'Jennifer', 'Anderson', 'jennifer.anderson@example.com', 'Denver', 'CO', 'US', '2023-04-01 09:00:00', 1), (9, 'William', 'Taylor', 'william.taylor@example.com', 'Portland', 'OR', 'US', '2023-04-12 15:30:00', 1), (10, 'Jessica', 'Thomas', 'jessica.thomas@example.com', 'Boston', 'MA', 'US', '2023-04-25 11:45:00', 1), (11, 'Daniel', 'Lee', 'daniel.lee@example.com', 'San Diego', 'CA', 'US', '2023-05-02 08:00:00', 1), (12, 'Ashley', 'Harris', 'ashley.harris@example.com', 'Phoenix', 'AZ', 'US', '2023-05-15 14:30:00', 1), (13, 'Christopher','Clark', 'christopher.clark@example.com', 'Atlanta', 'GA', 'US', '2023-05-28 10:15:00', 1), (14, 'Amanda', 'Lewis', 'amanda.lewis@example.com', 'Minneapolis', 'MN', 'US', '2023-06-05 12:00:00', 1), (15, 'Matthew', 'Walker', 'matthew.walker@example.com', 'Nashville', 'TN', 'US', '2023-06-18 09:45:00', 1), (16, 'Stephanie', 'Hall', 'stephanie.hall@example.com', 'Dallas', 'TX', 'US', '2023-06-30 16:00:00', 1), (17, 'Andrew', 'Allen', 'andrew.allen@example.com', 'Salt Lake City', 'UT', 'US', '2023-07-08 11:30:00', 1), (18, 'Nicole', 'Young', 'nicole.young@example.com', 'Charlotte', 'NC', 'US', '2023-07-20 13:15:00', 1), (19, 'Joshua', 'King', 'joshua.king@example.com', 'Columbus', 'OH', 'US', '2023-07-31 08:45:00', 0), (20, 'Rachel', 'Wright', 'rachel.wright@example.com', 'San Jose', 'CA', 'US', '2023-08-10 15:00:00', 1), (21, 'Kevin', 'Lopez', 'kevin.lopez@example.com', 'Indianapolis', 'IN', 'US', '2023-08-22 10:30:00', 1), (22, 'Laura', 'Hill', 'laura.hill@example.com', 'Jacksonville', 'FL', 'US', '2023-09-01 09:00:00', 1), (23, 'Brian', 'Scott', 'brian.scott@example.com', 'Las Vegas', 'NV', 'US', '2023-09-14 14:00:00', 0), (24, 'Megan', 'Green', 'megan.green@example.com', 'Raleigh', 'NC', 'US', '2023-09-25 11:15:00', 1), (25, 'Jason', 'Adams', 'jason.adams@example.com', 'Pittsburgh', 'PA', 'US', '2023-10-03 08:30:00', 1), (26, 'Samantha', 'Baker', 'samantha.baker@example.com', 'Detroit', 'MI', 'US', '2023-10-15 16:30:00', 1), (27, 'Ryan', 'Nelson', 'ryan.nelson@example.com', 'Tucson', 'AZ', 'US', '2023-10-28 12:00:00', 1), (28, 'Elizabeth', 'Carter', 'elizabeth.carter@example.com', 'Oklahoma City', 'OK', 'US', '2023-11-05 09:15:00', 0), (29, 'Tyler', 'Mitchell', 'tyler.mitchell@example.com', 'Memphis', 'TN', 'US', '2023-11-18 14:45:00', 1), (30, 'Heather', 'Perez', 'heather.perez@example.com', 'Louisville', 'KY', 'US', '2023-11-29 10:00:00', 1), (31, 'Justin', 'Roberts', 'justin.roberts@example.com', 'Richmond', 'VA', 'US', '2023-12-08 13:30:00', 1), (32, 'Amber', 'Turner', 'amber.turner@example.com', 'Hartford', 'CT', 'US', '2023-12-20 08:00:00', 1), (33, 'Brandon', 'Phillips', 'brandon.phillips@example.com', 'Boise', 'ID', 'US', '2024-01-05 15:15:00', 1), (34, 'Kayla', 'Campbell', 'kayla.campbell@example.com', 'Albuquerque', 'NM', 'US', '2024-01-18 11:00:00', 1), (35, 'Nathan', 'Parker', 'nathan.parker@example.com', 'Milwaukee', 'WI', 'US', '2024-02-01 09:30:00', 1), (36, 'Christina', 'Evans', 'christina.evans@example.com', 'Omaha', 'NE', 'US', '2024-02-14 14:00:00', 1), (37, 'Patrick', 'Edwards', 'patrick.edwards@example.com', 'Kansas City', 'MO', 'US', '2024-03-01 10:45:00', 1), (38, 'Tiffany', 'Collins', 'tiffany.collins@example.com', 'Tampa', 'FL', 'US', '2024-03-15 12:30:00', 0), (39, 'Adam', 'Stewart', 'adam.stewart@example.com', 'Providence', 'RI', 'US', '2024-04-02 08:15:00', 1), (40, 'Brittany', 'Sanchez', 'brittany.sanchez@example.com', 'Sacramento', 'CA', 'US', '2024-04-18 16:00:00', 1), (41, 'Sean', 'Morris', 'sean.morris@example.com', 'Orlando', 'FL', 'US', '2024-05-05 11:30:00', 1), (42, 'Danielle', 'Rogers', 'danielle.rogers@example.com', 'Honolulu', 'HI', 'US', '2024-05-20 09:00:00', 1), (43, 'Eric', 'Reed', 'eric.reed@example.com', 'Anchorage', 'AK', 'US', '2024-06-03 13:45:00', 1), (44, 'Vanessa', 'Cook', 'vanessa.cook@example.com', 'Burlington', 'VT', 'US', '2024-06-18 10:15:00', 0), (45, 'Derek', 'Morgan', 'derek.morgan@example.com', 'Charleston', 'SC', 'US', '2024-07-01 15:00:00', 1), (46, 'Kimberly', 'Bell', 'kimberly.bell@example.com', 'Madison', 'WI', 'US', '2024-07-15 08:30:00', 1), (47, 'Marcus', 'Murphy', 'marcus.murphy@example.com', 'Des Moines', 'IA', 'US', '2024-08-01 14:00:00', 1), (48, 'Angela', 'Bailey', 'angela.bailey@example.com', 'Little Rock', 'AR', 'US', '2024-08-18 11:45:00', 1), (49, 'Travis', 'Rivera', 'travis.rivera@example.com', 'Fargo', 'ND', 'US', '2024-09-02 09:15:00', 1), (50, 'Melissa', 'Cooper', 'melissa.cooper@example.com', 'Savannah', 'GA', 'US', '2024-09-20 13:00:00', 1), (51, 'Gregory', 'Richardson', 'gregory.richardson@example.com','Birmingham', 'AL', 'US', '2024-10-05 10:30:00', 1), (52, 'Rebecca', 'Cox', 'rebecca.cox@example.com', 'Lexington', 'KY', 'US', '2024-10-22 15:45:00', 0), (53, 'Carlos', 'Howard', 'carlos.howard@example.com', 'El Paso', 'TX', 'US', '2024-11-08 08:00:00', 1), (54, 'Diana', 'Ward', 'diana.ward@example.com', 'Spokane', 'WA', 'US', '2024-11-25 12:15:00', 1), (55, 'Victor', 'Torres', 'victor.torres@example.com', 'Fresno', 'CA', 'US', '2024-12-10 14:30:00', 1); -- ============================================================ -- PRODUCTS (55 total) -- ============================================================ INSERT INTO products (id, name, description, price, category_id, stock_quantity, is_available, created_at) VALUES -- Smartphones (category 8) (1, 'Galaxy S24 Ultra', 'Samsung flagship smartphone with S Pen', 499.99, 8, 120, 1, '2023-06-01 00:00:00'), (2, 'iPhone 15 Pro', 'Apple flagship with titanium design', 449.99, 8, 200, 1, '2023-06-15 00:00:00'), (3, 'Pixel 8', 'Google smartphone with AI features', 349.99, 8, 85, 1, '2023-07-01 00:00:00'), (4, 'OnePlus 12', NULL, 299.99, 8, 60, 1, '2023-08-01 00:00:00'), -- Laptops (category 9) (5, 'MacBook Air M3', 'Apple laptop with M3 chip, 13-inch', 499.99, 9, 90, 1, '2023-06-01 00:00:00'), (6, 'ThinkPad X1 Carbon', 'Lenovo business ultrabook', 449.99, 9, 45, 1, '2023-07-01 00:00:00'), (7, 'Dell XPS 15', 'Premium 15-inch laptop with OLED display', 479.99, 9, 35, 1, '2023-08-01 00:00:00'), (8, 'HP Spectre x360', NULL, 399.99, 9, 50, 1, '2023-09-01 00:00:00'), -- Audio (category 10) (9, 'AirPods Pro 2', 'Active noise cancellation earbuds', 249.99, 10, 300, 1, '2023-06-01 00:00:00'), (10, 'Sony WH-1000XM5', 'Over-ear noise cancelling headphones', 299.99, 10, 150, 1, '2023-06-15 00:00:00'), (11, 'JBL Charge 5', 'Portable Bluetooth speaker, waterproof', 129.99, 10, 200, 1, '2023-07-01 00:00:00'), (12, 'Bose QuietComfort', NULL, 279.99, 10, 80, 1, '2023-08-01 00:00:00'), -- Men's Clothing (category 11) (13, 'Classic Fit Oxford Shirt','Button-down oxford in 100% cotton', 59.99, 11, 250, 1, '2023-06-01 00:00:00'), (14, 'Slim Fit Chinos', 'Stretch cotton chinos in khaki', 49.99, 11, 180, 1, '2023-06-15 00:00:00'), (15, 'Wool Blend Blazer', 'Two-button blazer for business or casual', 149.99, 11, 70, 1, '2023-07-01 00:00:00'), (16, 'Graphic Tee Pack', NULL, 29.99, 11, 400, 1, '2023-08-01 00:00:00'), -- Women's Clothing (category 12) (17, 'Wrap Midi Dress', 'Floral print wrap dress, machine washable', 69.99, 12, 160, 1, '2023-06-01 00:00:00'), (18, 'High-Rise Skinny Jeans', 'Stretch denim with contour fit', 64.99, 12, 220, 1, '2023-06-15 00:00:00'), (19, 'Cashmere Pullover', 'Lightweight cashmere in seasonal colors', 129.99, 12, 90, 1, '2023-07-01 00:00:00'), (20, 'Athletic Leggings', NULL, 39.99, 12, 350, 1, '2023-08-01 00:00:00'), -- Fiction (category 13) (21, 'The Midnight Library', 'A novel about infinite possibilities by Matt Haig', 14.99, 13, 500, 1, '2023-06-01 00:00:00'), (22, 'Project Hail Mary', 'Sci-fi adventure by Andy Weir', 16.99, 13, 400, 1, '2023-06-15 00:00:00'), (23, 'Lessons in Chemistry', 'A witty novel set in the 1960s', 15.99, 13, 350, 1, '2023-07-01 00:00:00'), (24, 'Tomorrow and Tomorrow', NULL, 13.99, 13, 280, 1, '2023-08-01 00:00:00'), -- Non-Fiction (category 14) (25, 'Atomic Habits', 'Build good habits, break bad ones by James Clear', 12.99, 14, 450, 1, '2023-06-01 00:00:00'), (26, 'Thinking Fast and Slow', 'Daniel Kahneman on decision making', 18.99, 14, 200, 1, '2023-06-15 00:00:00'), (27, 'The DevOps Handbook', 'Best practices for IT teams', 34.99, 14, 150, 1, '2023-07-01 00:00:00'), (28, 'Designing Data Apps', NULL, 42.99, 14, 100, 1, '2023-08-01 00:00:00'), -- Home & Garden (category 4) (29, 'Ceramic Plant Pot Set', 'Set of 3 modern planters with drainage', 34.99, 4, 180, 1, '2023-06-01 00:00:00'), (30, 'LED Desk Lamp', 'Adjustable brightness with USB charging port', 44.99, 4, 250, 1, '2023-06-15 00:00:00'), (31, 'Throw Blanket', 'Cozy microfiber blanket, 50x60 inches', 24.99, 4, 300, 1, '2023-07-01 00:00:00'), (32, 'Wall Art Canvas Set', NULL, 39.99, 4, 120, 1, '2023-08-01 00:00:00'), -- Kitchen (category 15) (33, 'Stainless Steel Knife Set','8-piece professional chef knife set', 89.99, 15, 110, 1, '2023-06-01 00:00:00'), (34, 'Instant Pot Duo', '7-in-1 electric pressure cooker, 6 quart', 79.99, 15, 140, 1, '2023-06-15 00:00:00'), (35, 'Pour Over Coffee Maker', 'Borosilicate glass with reusable filter', 29.99, 15, 200, 1, '2023-07-01 00:00:00'), (36, 'Cast Iron Skillet', NULL, 34.99, 15, 170, 1, '2023-08-01 00:00:00'), -- Sports & Outdoors (category 5) (37, 'Yoga Mat Premium', 'Non-slip 6mm thick exercise mat', 29.99, 5, 280, 1, '2023-06-01 00:00:00'), (38, 'Running Shoes Pro', 'Lightweight with responsive cushioning', 119.99, 5, 160, 1, '2023-06-15 00:00:00'), (39, 'Resistance Band Set', '5 bands with handles, door anchor, and bag', 24.99, 5, 350, 1, '2023-07-01 00:00:00'), (40, 'Camping Hammock', NULL, 49.99, 5, 100, 1, '2023-08-01 00:00:00'), (41, 'Insulated Water Bottle', 'Keeps drinks cold 24hrs, hot 12hrs, 32oz', 27.99, 5, 400, 1, '2023-09-01 00:00:00'), -- Toys & Games (category 6) (42, 'Strategy Board Game', 'Award-winning euro-style board game for 2-4 players', 44.99, 6, 130, 1, '2023-06-01 00:00:00'), (43, '1000-Piece Puzzle', 'Mountain landscape jigsaw puzzle', 19.99, 6, 240, 1, '2023-06-15 00:00:00'), (44, 'Building Block Set', '500-piece creative construction set', 34.99, 6, 190, 1, '2023-07-01 00:00:00'), (45, 'Card Game Collection', NULL, 14.99, 6, 320, 1, '2023-08-01 00:00:00'), -- Health & Beauty (category 7) (46, 'Vitamin C Serum', 'Brightening face serum with hyaluronic acid', 28.99, 7, 200, 1, '2023-06-01 00:00:00'), (47, 'Electric Toothbrush', 'Sonic cleaning with 3 brush heads', 59.99, 7, 170, 1, '2023-06-15 00:00:00'), (48, 'Essential Oil Diffuser', 'Ultrasonic aromatherapy with LED lights', 36.99, 7, 150, 1, '2023-07-01 00:00:00'), (49, 'Protein Powder', NULL, 39.99, 7, 260, 1, '2023-08-01 00:00:00'), (50, 'Sunscreen SPF 50', 'Broad spectrum, reef safe, 6oz', 16.99, 7, 380, 1, '2023-09-01 00:00:00'), -- A few unavailable / out of stock products for interesting queries (51, 'Vintage Record Player', 'Retro turntable with built-in speakers', 159.99, 10, 0, 0, '2023-06-01 00:00:00'), (52, 'Leather Messenger Bag', 'Full-grain leather, fits 15-inch laptop', 189.99, 11, 0, 0, '2023-07-01 00:00:00'), (53, 'Smart Garden Kit', 'Indoor hydroponic garden with LED grow lights', 99.99, 4, 5, 1, '2023-08-01 00:00:00'), (54, 'Mechanical Keyboard', 'Hot-swappable switches, RGB backlight', 89.99, 1, 25, 1, '2023-09-01 00:00:00'), (55, 'Wireless Charging Pad', NULL, 19.99, 1, 0, 0, '2023-10-01 00:00:00'); -- ============================================================ -- ORDERS (230 total) -- Seasonal pattern: heavier in Nov/Dec, lighter in Jan-Mar -- Statuses: pending, processing, shipped, delivered, cancelled -- ============================================================ -- January 2024 (10 orders — slow month) INSERT INTO orders (id, customer_id, order_date, status, total_amount, shipping_address) VALUES (1, 1, '2024-01-03 10:15:00', 'delivered', 529.98, '742 Evergreen Terrace, Austin, TX 78701'), (2, 2, '2024-01-05 14:30:00', 'delivered', 64.99, '456 Oak Avenue, Los Angeles, CA 90001'), (3, 5, '2024-01-08 09:00:00', 'delivered', 449.99, '789 Broadway, New York, NY 10001'), (4, 3, '2024-01-12 16:45:00', 'delivered', 29.98, NULL), (5, 8, '2024-01-15 11:20:00', 'delivered', 149.99, '321 Pine St, Denver, CO 80201'), (6, 10, '2024-01-18 13:00:00', 'delivered', 89.97, '654 Maple Dr, Boston, MA 02101'), (7, 4, '2024-01-21 08:30:00', 'delivered', 499.99, '987 Market St, San Francisco, CA 94101'), (8, 12, '2024-01-24 15:15:00', 'cancelled', 59.99, '111 Desert Rd, Phoenix, AZ 85001'), (9, 6, '2024-01-27 10:00:00', 'delivered', 179.98, '222 Rain Ave, Seattle, WA 98101'), (10, 15, '2024-01-30 12:45:00', 'delivered', 34.99, NULL); -- February 2024 (12 orders) INSERT INTO orders (id, customer_id, order_date, status, total_amount, shipping_address) VALUES (11, 7, '2024-02-01 09:30:00', 'delivered', 349.99, '333 Palm Blvd, Miami, FL 33101'), (12, 11, '2024-02-03 14:00:00', 'delivered', 94.98, '444 Coast Hwy, San Diego, CA 92101'), (13, 14, '2024-02-06 11:15:00', 'delivered', 27.99, NULL), (14, 9, '2024-02-08 16:30:00', 'delivered', 199.98, '555 River Rd, Portland, OR 97201'), (15, 16, '2024-02-11 08:45:00', 'delivered', 449.99, '666 Longhorn Ln, Dallas, TX 75201'), (16, 1, '2024-02-14 10:00:00', 'delivered', 129.99, '742 Evergreen Terrace, Austin, TX 78701'), (17, 20, '2024-02-17 13:30:00', 'delivered', 64.97, '777 Tech Park, San Jose, CA 95101'), (18, 2, '2024-02-19 15:00:00', 'delivered', 249.99, '456 Oak Avenue, Los Angeles, CA 90001'), (19, 22, '2024-02-22 09:15:00', 'cancelled', 89.99, NULL), (20, 13, '2024-02-24 11:45:00', 'delivered', 59.97, '888 Peach St, Atlanta, GA 30301'), (21, 5, '2024-02-26 14:20:00', 'delivered', 79.99, '789 Broadway, New York, NY 10001'), (22, 18, '2024-02-28 10:30:00', 'delivered', 44.99, '999 Dogwood Ct, Charlotte, NC 28201'); -- March 2024 (14 orders) INSERT INTO orders (id, customer_id, order_date, status, total_amount, shipping_address) VALUES (23, 4, '2024-03-01 09:00:00', 'delivered', 299.99, '987 Market St, San Francisco, CA 94101'), (24, 17, '2024-03-03 14:30:00', 'delivered', 89.98, NULL), (25, 21, '2024-03-05 11:00:00', 'delivered', 119.99, '100 Circle Dr, Indianapolis, IN 46201'), (26, 6, '2024-03-07 16:15:00', 'delivered', 34.98, '222 Rain Ave, Seattle, WA 98101'), (27, 25, '2024-03-10 08:30:00', 'delivered', 479.99, '200 Steel Ave, Pittsburgh, PA 15201'), (28, 3, '2024-03-12 13:00:00', 'delivered', 54.98, '300 Lake Shore Dr, Chicago, IL 60601'), (29, 10, '2024-03-15 10:45:00', 'delivered', 299.99, '654 Maple Dr, Boston, MA 02101'), (30, 24, '2024-03-17 15:30:00', 'delivered', 16.99, NULL), (31, 8, '2024-03-20 09:15:00', 'delivered', 159.98, '321 Pine St, Denver, CO 80201'), (32, 26, '2024-03-22 12:00:00', 'delivered', 44.99, '400 Motor City Blvd, Detroit, MI 48201'), (33, 1, '2024-03-25 14:45:00', 'delivered', 69.99, '742 Evergreen Terrace, Austin, TX 78701'), (34, 30, '2024-03-27 08:00:00', 'cancelled', 129.99, NULL), (35, 15, '2024-03-29 11:30:00', 'delivered', 39.99, '500 Music Row, Nashville, TN 37201'), (36, 9, '2024-03-31 16:00:00', 'delivered', 24.99, '555 River Rd, Portland, OR 97201'); -- April 2024 (16 orders) INSERT INTO orders (id, customer_id, order_date, status, total_amount, shipping_address) VALUES (37, 2, '2024-04-01 09:30:00', 'delivered', 499.99, '456 Oak Avenue, Los Angeles, CA 90001'), (38, 11, '2024-04-03 14:00:00', 'delivered', 59.98, '444 Coast Hwy, San Diego, CA 92101'), (39, 7, '2024-04-05 10:15:00', 'delivered', 279.99, '333 Palm Blvd, Miami, FL 33101'), (40, 27, '2024-04-07 15:30:00', 'delivered', 34.99, NULL), (41, 5, '2024-04-09 08:45:00', 'delivered', 129.98, '789 Broadway, New York, NY 10001'), (42, 16, '2024-04-11 11:00:00', 'delivered', 89.99, '666 Longhorn Ln, Dallas, TX 75201'), (43, 33, '2024-04-13 13:30:00', 'delivered', 349.99, '600 Gem St, Boise, ID 83701'), (44, 4, '2024-04-15 09:00:00', 'delivered', 64.99, '987 Market St, San Francisco, CA 94101'), (45, 20, '2024-04-17 16:45:00', 'delivered', 199.98, '777 Tech Park, San Jose, CA 95101'), (46, 29, '2024-04-19 10:30:00', 'delivered', 44.98, NULL), (47, 14, '2024-04-21 12:15:00', 'delivered', 79.99, '700 Lake Blvd, Minneapolis, MN 55401'), (48, 1, '2024-04-23 14:00:00', 'delivered', 249.99, '742 Evergreen Terrace, Austin, TX 78701'), (49, 31, '2024-04-25 08:30:00', 'cancelled', 159.99, '800 Monument Ave, Richmond, VA 23219'), (50, 6, '2024-04-27 11:15:00', 'delivered', 29.99, '222 Rain Ave, Seattle, WA 98101'), (51, 12, '2024-04-29 15:00:00', 'delivered', 119.99, '111 Desert Rd, Phoenix, AZ 85001'), (52, 35, '2024-04-30 09:45:00', 'delivered', 54.98, NULL); -- May 2024 (18 orders) INSERT INTO orders (id, customer_id, order_date, status, total_amount, shipping_address) VALUES (53, 3, '2024-05-01 10:00:00', 'delivered', 449.99, '300 Lake Shore Dr, Chicago, IL 60601'), (54, 22, '2024-05-02 14:30:00', 'delivered', 69.98, '900 Beach Blvd, Jacksonville, FL 32201'), (55, 8, '2024-05-04 09:15:00', 'delivered', 34.99, '321 Pine St, Denver, CO 80201'), (56, 34, '2024-05-06 16:00:00', 'delivered', 89.99, NULL), (57, 10, '2024-05-08 11:30:00', 'delivered', 299.99, '654 Maple Dr, Boston, MA 02101'), (58, 17, '2024-05-10 08:00:00', 'delivered', 24.98, '950 Temple Ave, Salt Lake City, UT 84101'), (59, 2, '2024-05-12 13:45:00', 'delivered', 149.99, '456 Oak Avenue, Los Angeles, CA 90001'), (60, 36, '2024-05-14 10:15:00', 'delivered', 59.99, '1000 Pioneer Trl, Omaha, NE 68101'), (61, 5, '2024-05-16 15:00:00', 'delivered', 499.99, '789 Broadway, New York, NY 10001'), (62, 21, '2024-05-18 09:30:00', 'delivered', 39.98, NULL), (63, 13, '2024-05-20 12:00:00', 'delivered', 179.98, '888 Peach St, Atlanta, GA 30301'), (64, 4, '2024-05-22 14:45:00', 'delivered', 44.99, '987 Market St, San Francisco, CA 94101'), (65, 37, '2024-05-24 08:15:00', 'delivered', 129.99, NULL), (66, 11, '2024-05-26 11:00:00', 'delivered', 249.99, '444 Coast Hwy, San Diego, CA 92101'), (67, 25, '2024-05-28 16:30:00', 'delivered', 19.99, '200 Steel Ave, Pittsburgh, PA 15201'), (68, 1, '2024-05-29 09:00:00', 'delivered', 349.99, '742 Evergreen Terrace, Austin, TX 78701'), (69, 18, '2024-05-30 13:15:00', 'cancelled', 64.99, NULL), (70, 9, '2024-05-31 10:30:00', 'delivered', 79.99, '555 River Rd, Portland, OR 97201'); -- June 2024 (18 orders) INSERT INTO orders (id, customer_id, order_date, status, total_amount, shipping_address) VALUES (71, 7, '2024-06-01 09:00:00', 'delivered', 119.99, '333 Palm Blvd, Miami, FL 33101'), (72, 39, '2024-06-02 14:30:00', 'delivered', 29.99, NULL), (73, 15, '2024-06-04 11:00:00', 'delivered', 449.99, '500 Music Row, Nashville, TN 37201'), (74, 2, '2024-06-06 16:15:00', 'delivered', 89.98, '456 Oak Avenue, Los Angeles, CA 90001'), (75, 40, '2024-06-08 08:30:00', 'delivered', 159.98, '1100 Capitol Mall, Sacramento, CA 95814'), (76, 26, '2024-06-10 13:00:00', 'delivered', 34.99, '400 Motor City Blvd, Detroit, MI 48201'), (77, 3, '2024-06-12 10:45:00', 'delivered', 299.99, '300 Lake Shore Dr, Chicago, IL 60601'), (78, 16, '2024-06-14 15:30:00', 'delivered', 64.98, NULL), (79, 41, '2024-06-16 09:15:00', 'delivered', 79.99, '1200 Theme Park Dr, Orlando, FL 32819'), (80, 20, '2024-06-18 12:00:00', 'delivered', 249.99, '777 Tech Park, San Jose, CA 95101'), (81, 5, '2024-06-20 14:45:00', 'delivered', 44.98, '789 Broadway, New York, NY 10001'), (82, 30, '2024-06-22 08:00:00', 'delivered', 129.99, '1300 Derby Ln, Louisville, KY 40201'), (83, 4, '2024-06-24 11:30:00', 'delivered', 199.98, '987 Market St, San Francisco, CA 94101'), (84, 42, '2024-06-26 16:00:00', 'delivered', 59.99, NULL), (85, 14, '2024-06-27 09:30:00', 'cancelled', 89.99, '700 Lake Blvd, Minneapolis, MN 55401'), (86, 1, '2024-06-28 13:00:00', 'delivered', 499.99, '742 Evergreen Terrace, Austin, TX 78701'), (87, 33, '2024-06-29 10:15:00', 'delivered', 34.98, '600 Gem St, Boise, ID 83701'), (88, 8, '2024-06-30 15:45:00', 'delivered', 24.99, '321 Pine St, Denver, CO 80201'); -- July 2024 (20 orders) INSERT INTO orders (id, customer_id, order_date, status, total_amount, shipping_address) VALUES (89, 6, '2024-07-01 09:00:00', 'delivered', 349.99, '222 Rain Ave, Seattle, WA 98101'), (90, 43, '2024-07-02 14:30:00', 'delivered', 44.99, NULL), (91, 10, '2024-07-04 11:00:00', 'delivered', 129.98, '654 Maple Dr, Boston, MA 02101'), (92, 2, '2024-07-05 16:15:00', 'delivered', 79.99, '456 Oak Avenue, Los Angeles, CA 90001'), (93, 24, '2024-07-07 08:30:00', 'delivered', 499.99, '1400 Research Tri, Raleigh, NC 27601'), (94, 35, '2024-07-09 13:00:00', 'delivered', 59.98, NULL), (95, 7, '2024-07-11 10:45:00', 'delivered', 279.99, '333 Palm Blvd, Miami, FL 33101'), (96, 1, '2024-07-13 15:30:00', 'delivered', 89.99, '742 Evergreen Terrace, Austin, TX 78701'), (97, 45, '2024-07-15 09:15:00', 'delivered', 199.98, '1500 Battery St, Charleston, SC 29401'), (98, 12, '2024-07-17 12:00:00', 'delivered', 34.99, '111 Desert Rd, Phoenix, AZ 85001'), (99, 5, '2024-07-19 14:45:00', 'delivered', 149.99, '789 Broadway, New York, NY 10001'), (100, 27, '2024-07-21 08:00:00', 'delivered', 64.98, NULL), (101, 3, '2024-07-23 11:30:00', 'delivered', 249.99, '300 Lake Shore Dr, Chicago, IL 60601'), (102, 46, '2024-07-25 16:00:00', 'delivered', 39.99, '1600 Isthmus Dr, Madison, WI 53701'), (103, 17, '2024-07-27 09:30:00', 'delivered', 119.99, '950 Temple Ave, Salt Lake City, UT 84101'), (104, 4, '2024-07-28 13:00:00', 'cancelled', 449.99, '987 Market St, San Francisco, CA 94101'), (105, 22, '2024-07-29 10:15:00', 'delivered', 29.98, NULL), (106, 36, '2024-07-30 15:45:00', 'delivered', 69.99, '1000 Pioneer Trl, Omaha, NE 68101'), (107, 11, '2024-07-31 08:00:00', 'delivered', 299.99, '444 Coast Hwy, San Diego, CA 92101'), (108, 9, '2024-07-31 12:30:00', 'delivered', 44.99, '555 River Rd, Portland, OR 97201'); -- August 2024 (20 orders) INSERT INTO orders (id, customer_id, order_date, status, total_amount, shipping_address) VALUES (109, 47, '2024-08-01 09:00:00', 'delivered', 89.99, '1700 Grand Ave, Des Moines, IA 50301'), (110, 2, '2024-08-03 14:30:00', 'delivered', 499.99, '456 Oak Avenue, Los Angeles, CA 90001'), (111, 13, '2024-08-05 11:00:00', 'delivered', 54.98, '888 Peach St, Atlanta, GA 30301'), (112, 25, '2024-08-07 16:15:00', 'delivered', 129.99, NULL), (113, 6, '2024-08-09 08:30:00', 'delivered', 249.99, '222 Rain Ave, Seattle, WA 98101'), (114, 48, '2024-08-11 13:00:00', 'delivered', 19.99, '1800 Capitol Ave, Little Rock, AR 72201'), (115, 1, '2024-08-13 10:45:00', 'delivered', 349.99, '742 Evergreen Terrace, Austin, TX 78701'), (116, 21, '2024-08-15 15:30:00', 'delivered', 79.98, NULL), (117, 10, '2024-08-17 09:15:00', 'delivered', 159.98, '654 Maple Dr, Boston, MA 02101'), (118, 37, '2024-08-19 12:00:00', 'delivered', 64.99, '1100 Fountain Blvd, Kansas City, MO 64101'), (119, 4, '2024-08-21 14:45:00', 'delivered', 299.99, '987 Market St, San Francisco, CA 94101'), (120, 15, '2024-08-23 08:00:00', 'delivered', 44.98, '500 Music Row, Nashville, TN 37201'), (121, 29, '2024-08-25 11:30:00', 'cancelled', 199.99, NULL), (122, 40, '2024-08-27 16:00:00', 'delivered', 34.99, '1100 Capitol Mall, Sacramento, CA 95814'), (123, 5, '2024-08-28 09:30:00', 'delivered', 449.99, '789 Broadway, New York, NY 10001'), (124, 34, '2024-08-29 13:00:00', 'delivered', 59.99, '1900 Rio Grande, Albuquerque, NM 87101'), (125, 3, '2024-08-30 10:15:00', 'delivered', 89.98, '300 Lake Shore Dr, Chicago, IL 60601'), (126, 16, '2024-08-30 15:45:00', 'delivered', 129.99, '666 Longhorn Ln, Dallas, TX 75201'), (127, 8, '2024-08-31 08:00:00', 'delivered', 24.99, '321 Pine St, Denver, CO 80201'), (128, 26, '2024-08-31 12:30:00', 'delivered', 79.99, '400 Motor City Blvd, Detroit, MI 48201'); -- September 2024 (20 orders) INSERT INTO orders (id, customer_id, order_date, status, total_amount, shipping_address) VALUES (129, 7, '2024-09-01 09:00:00', 'delivered', 499.99, '333 Palm Blvd, Miami, FL 33101'), (130, 49, '2024-09-02 14:30:00', 'delivered', 34.98, NULL), (131, 11, '2024-09-04 11:00:00', 'delivered', 149.99, '444 Coast Hwy, San Diego, CA 92101'), (132, 20, '2024-09-06 16:15:00', 'delivered', 89.99, '777 Tech Park, San Jose, CA 95101'), (133, 1, '2024-09-08 08:30:00', 'delivered', 279.99, '742 Evergreen Terrace, Austin, TX 78701'), (134, 39, '2024-09-10 13:00:00', 'delivered', 64.98, '2000 Colonial Rd, Providence, RI 02901'), (135, 14, '2024-09-12 10:45:00', 'shipped', 199.98, NULL), (136, 2, '2024-09-14 15:30:00', 'delivered', 119.99, '456 Oak Avenue, Los Angeles, CA 90001'), (137, 50, '2024-09-16 09:15:00', 'delivered', 44.99, '2100 Factors Walk, Savannah, GA 31401'), (138, 31, '2024-09-18 12:00:00', 'delivered', 59.98, '800 Monument Ave, Richmond, VA 23219'), (139, 4, '2024-09-20 14:45:00', 'delivered', 349.99, '987 Market St, San Francisco, CA 94101'), (140, 45, '2024-09-22 08:00:00', 'delivered', 29.99, NULL), (141, 6, '2024-09-24 11:30:00', 'delivered', 79.99, '222 Rain Ave, Seattle, WA 98101'), (142, 33, '2024-09-25 16:00:00', 'cancelled', 249.99, '600 Gem St, Boise, ID 83701'), (143, 10, '2024-09-26 09:30:00', 'delivered', 449.99, '654 Maple Dr, Boston, MA 02101'), (144, 17, '2024-09-27 13:00:00', 'delivered', 34.99, '950 Temple Ave, Salt Lake City, UT 84101'), (145, 22, '2024-09-28 10:15:00', 'delivered', 89.98, '900 Beach Blvd, Jacksonville, FL 32201'), (146, 3, '2024-09-29 15:45:00', 'delivered', 129.99, '300 Lake Shore Dr, Chicago, IL 60601'), (147, 41, '2024-09-30 08:00:00', 'delivered', 59.99, '1200 Theme Park Dr, Orlando, FL 32819'), (148, 5, '2024-09-30 12:30:00', 'delivered', 199.98, '789 Broadway, New York, NY 10001'); -- October 2024 (22 orders) INSERT INTO orders (id, customer_id, order_date, status, total_amount, shipping_address) VALUES (149, 12, '2024-10-01 09:00:00', 'delivered', 299.99, '111 Desert Rd, Phoenix, AZ 85001'), (150, 51, '2024-10-02 14:30:00', 'delivered', 59.98, NULL), (151, 8, '2024-10-03 11:00:00', 'delivered', 449.99, '321 Pine St, Denver, CO 80201'), (152, 24, '2024-10-05 16:15:00', 'delivered', 79.99, '1400 Research Tri, Raleigh, NC 27601'), (153, 1, '2024-10-07 08:30:00', 'delivered', 149.98, '742 Evergreen Terrace, Austin, TX 78701'), (154, 36, '2024-10-09 13:00:00', 'delivered', 34.99, '1000 Pioneer Trl, Omaha, NE 68101'), (155, 7, '2024-10-11 10:45:00', 'delivered', 199.98, '333 Palm Blvd, Miami, FL 33101'), (156, 46, '2024-10-12 15:30:00', 'delivered', 89.99, NULL), (157, 2, '2024-10-13 09:15:00', 'delivered', 499.99, '456 Oak Avenue, Los Angeles, CA 90001'), (158, 30, '2024-10-15 12:00:00', 'delivered', 44.98, '1300 Derby Ln, Louisville, KY 40201'), (159, 15, '2024-10-17 14:45:00', 'delivered', 129.99, '500 Music Row, Nashville, TN 37201'), (160, 4, '2024-10-19 08:00:00', 'delivered', 249.99, '987 Market St, San Francisco, CA 94101'), (161, 43, '2024-10-20 11:30:00', 'shipped', 64.98, NULL), (162, 25, '2024-10-21 16:00:00', 'delivered', 119.99, '200 Steel Ave, Pittsburgh, PA 15201'), (163, 9, '2024-10-23 09:30:00', 'delivered', 349.99, '555 River Rd, Portland, OR 97201'), (164, 53, '2024-10-25 13:00:00', 'delivered', 59.99, '2200 Mesa Dr, El Paso, TX 79901'), (165, 20, '2024-10-27 10:15:00', 'delivered', 79.98, '777 Tech Park, San Jose, CA 95101'), (166, 11, '2024-10-28 15:45:00', 'cancelled', 299.99, '444 Coast Hwy, San Diego, CA 92101'), (167, 37, '2024-10-29 08:00:00', 'delivered', 44.99, '1100 Fountain Blvd, Kansas City, MO 64101'), (168, 6, '2024-10-30 12:30:00', 'delivered', 159.98, '222 Rain Ave, Seattle, WA 98101'), (169, 3, '2024-10-31 09:00:00', 'delivered', 89.98, '300 Lake Shore Dr, Chicago, IL 60601'), (170, 47, '2024-10-31 14:15:00', 'delivered', 29.99, NULL); -- November 2024 (30 orders — holiday season ramp-up) INSERT INTO orders (id, customer_id, order_date, status, total_amount, shipping_address) VALUES (171, 1, '2024-11-01 09:00:00', 'delivered', 499.99, '742 Evergreen Terrace, Austin, TX 78701'), (172, 5, '2024-11-02 10:30:00', 'delivered', 249.99, '789 Broadway, New York, NY 10001'), (173, 2, '2024-11-03 14:00:00', 'delivered', 349.99, '456 Oak Avenue, Los Angeles, CA 90001'), (174, 54, '2024-11-04 08:15:00', 'delivered', 89.98, NULL), (175, 10, '2024-11-05 11:30:00', 'delivered', 129.99, '654 Maple Dr, Boston, MA 02101'), (176, 34, '2024-11-06 16:00:00', 'delivered', 59.99, '1900 Rio Grande, Albuquerque, NM 87101'), (177, 4, '2024-11-07 09:45:00', 'delivered', 449.99, '987 Market St, San Francisco, CA 94101'), (178, 21, '2024-11-08 13:15:00', 'delivered', 79.98, NULL), (179, 7, '2024-11-09 10:00:00', 'delivered', 199.98, '333 Palm Blvd, Miami, FL 33101'), (180, 48, '2024-11-10 15:30:00', 'delivered', 34.99, '1800 Capitol Ave, Little Rock, AR 72201'), (181, 14, '2024-11-11 08:30:00', 'delivered', 299.99, '700 Lake Blvd, Minneapolis, MN 55401'), (182, 6, '2024-11-12 12:00:00', 'delivered', 119.99, '222 Rain Ave, Seattle, WA 98101'), (183, 3, '2024-11-14 14:30:00', 'delivered', 449.99, '300 Lake Shore Dr, Chicago, IL 60601'), (184, 40, '2024-11-15 09:15:00', 'delivered', 64.98, NULL), (185, 16, '2024-11-16 11:45:00', 'delivered', 159.98, '666 Longhorn Ln, Dallas, TX 75201'), (186, 25, '2024-11-17 16:00:00', 'delivered', 249.99, '200 Steel Ave, Pittsburgh, PA 15201'), (187, 1, '2024-11-18 08:00:00', 'delivered', 89.99, '742 Evergreen Terrace, Austin, TX 78701'), (188, 55, '2024-11-19 13:30:00', 'delivered', 44.98, NULL), (189, 12, '2024-11-20 10:45:00', 'delivered', 349.99, '111 Desert Rd, Phoenix, AZ 85001'), (190, 9, '2024-11-22 15:00:00', 'cancelled', 199.99, '555 River Rd, Portland, OR 97201'), (191, 2, '2024-11-23 09:00:00', 'delivered', 499.99, '456 Oak Avenue, Los Angeles, CA 90001'), (192, 29, '2024-11-24 14:30:00', 'delivered', 79.99, '2300 Beale St, Memphis, TN 38101'), (193, 5, '2024-11-25 11:00:00', 'delivered', 299.99, '789 Broadway, New York, NY 10001'), (194, 42, '2024-11-26 16:15:00', 'delivered', 59.98, NULL), (195, 18, '2024-11-27 08:30:00', 'delivered', 129.99, '999 Dogwood Ct, Charlotte, NC 28201'), (196, 4, '2024-11-28 10:00:00', 'delivered', 449.99, '987 Market St, San Francisco, CA 94101'), (197, 33, '2024-11-29 13:45:00', 'delivered', 199.98, '600 Gem St, Boise, ID 83701'), (198, 22, '2024-11-29 15:00:00', 'delivered', 89.98, '900 Beach Blvd, Jacksonville, FL 32201'), (199, 8, '2024-11-30 09:15:00', 'delivered', 34.99, '321 Pine St, Denver, CO 80201'), (200, 11, '2024-11-30 12:00:00', 'delivered', 249.99, '444 Coast Hwy, San Diego, CA 92101'); -- December 2024 (30 orders — peak holiday season) INSERT INTO orders (id, customer_id, order_date, status, total_amount, shipping_address) VALUES (201, 1, '2024-12-01 09:00:00', 'delivered', 499.99, '742 Evergreen Terrace, Austin, TX 78701'), (202, 3, '2024-12-02 10:30:00', 'delivered', 349.99, '300 Lake Shore Dr, Chicago, IL 60601'), (203, 7, '2024-12-03 14:00:00', 'delivered', 249.99, '333 Palm Blvd, Miami, FL 33101'), (204, 2, '2024-12-04 08:15:00', 'delivered', 129.98, '456 Oak Avenue, Los Angeles, CA 90001'), (205, 50, '2024-12-05 11:30:00', 'delivered', 89.99, NULL), (206, 10, '2024-12-06 16:00:00', 'delivered', 449.99, '654 Maple Dr, Boston, MA 02101'), (207, 45, '2024-12-07 09:45:00', 'delivered', 64.98, '1500 Battery St, Charleston, SC 29401'), (208, 5, '2024-12-08 13:15:00', 'delivered', 299.99, '789 Broadway, New York, NY 10001'), (209, 15, '2024-12-09 10:00:00', 'processing', 199.98, '500 Music Row, Nashville, TN 37201'), (210, 4, '2024-12-10 15:30:00', 'delivered', 79.98, '987 Market St, San Francisco, CA 94101'), (211, 35, '2024-12-11 08:30:00', 'delivered', 119.99, NULL), (212, 6, '2024-12-12 12:00:00', 'delivered', 499.99, '222 Rain Ave, Seattle, WA 98101'), (213, 26, '2024-12-13 14:30:00', 'delivered', 59.98, '400 Motor City Blvd, Detroit, MI 48201'), (214, 1, '2024-12-14 09:15:00', 'delivered', 349.99, '742 Evergreen Terrace, Austin, TX 78701'), (215, 41, '2024-12-15 11:45:00', 'shipped', 249.99, '1200 Theme Park Dr, Orlando, FL 32819'), (216, 2, '2024-12-16 16:00:00', 'delivered', 89.98, '456 Oak Avenue, Los Angeles, CA 90001'), (217, 20, '2024-12-17 08:00:00', 'delivered', 159.98, '777 Tech Park, San Jose, CA 95101'), (218, 3, '2024-12-18 13:30:00', 'processing', 449.99, '300 Lake Shore Dr, Chicago, IL 60601'), (219, 46, '2024-12-19 10:45:00', 'delivered', 34.99, NULL), (220, 14, '2024-12-20 15:00:00', 'shipped', 199.98, '700 Lake Blvd, Minneapolis, MN 55401'), (221, 5, '2024-12-21 09:00:00', 'processing', 499.99, '789 Broadway, New York, NY 10001'), (222, 27, '2024-12-22 14:30:00', 'shipped', 129.99, '2400 Saguaro Dr, Tucson, AZ 85701'), (223, 8, '2024-12-23 11:00:00', 'pending', 279.99, '321 Pine St, Denver, CO 80201'), (224, 4, '2024-12-24 08:15:00', 'pending', 449.99, NULL), (225, 53, '2024-12-25 10:00:00', 'pending', 89.98, '2200 Mesa Dr, El Paso, TX 79901'), (226, 7, '2024-12-26 13:45:00', 'processing', 349.99, '333 Palm Blvd, Miami, FL 33101'), (227, 9, '2024-12-27 15:30:00', 'shipped', 199.98, '555 River Rd, Portland, OR 97201'), (228, 1, '2024-12-28 09:00:00', 'shipped', 249.99, '742 Evergreen Terrace, Austin, TX 78701'), (229, 6, '2024-12-29 12:15:00', 'processing', 149.98, '222 Rain Ave, Seattle, WA 98101'), (230, 2, '2024-12-30 14:00:00', 'pending', 399.98, '456 Oak Avenue, Los Angeles, CA 90001'); -- ============================================================ -- ORDER ITEMS (600 total) -- Each order has 1-5 items; popular products appear more often -- unit_price matches the product's price -- ============================================================ -- Orders 1-10 (January 2024) INSERT INTO order_items (id, order_id, product_id, quantity, unit_price) VALUES (1, 1, 2, 1, 449.99), (2, 1, 35, 1, 29.99), (3, 1, 41, 2, 27.99), (4, 2, 18, 1, 64.99), (5, 3, 6, 1, 449.99), (6, 4, 21, 1, 14.99), (7, 4, 45, 1, 14.99), (8, 5, 15, 1, 149.99), (9, 6, 25, 3, 12.99), (10, 6, 30, 1, 44.99), (11, 7, 5, 1, 499.99), (12, 8, 13, 1, 59.99), (13, 9, 19, 1, 129.99), (14, 9, 14, 1, 49.99), (15, 10, 36, 1, 34.99); -- Orders 11-22 (February 2024) INSERT INTO order_items (id, order_id, product_id, quantity, unit_price) VALUES (16, 11, 3, 1, 349.99), (17, 12, 37, 1, 29.99), (18, 12, 18, 1, 64.99), (19, 13, 41, 1, 27.99), (20, 14, 38, 1, 119.99), (21, 14, 34, 1, 79.99), (22, 15, 6, 1, 449.99), (23, 16, 19, 1, 129.99), (24, 17, 14, 1, 49.99), (25, 17, 21, 1, 14.99), (26, 18, 9, 1, 249.99), (27, 19, 33, 1, 89.99), (28, 20, 37, 2, 29.99), (29, 21, 34, 1, 79.99), (30, 22, 42, 1, 44.99); -- Orders 23-36 (March 2024) INSERT INTO order_items (id, order_id, product_id, quantity, unit_price) VALUES (31, 23, 10, 1, 299.99), (32, 24, 46, 2, 28.99), (33, 24, 39, 1, 24.99), (34, 25, 38, 1, 119.99), (35, 26, 43, 1, 19.99), (36, 26, 21, 1, 14.99), (37, 27, 7, 1, 479.99), (38, 28, 35, 1, 29.99), (39, 28, 39, 1, 24.99), (40, 29, 10, 1, 299.99), (41, 30, 50, 1, 16.99), (42, 31, 34, 1, 79.99), (43, 31, 35, 1, 29.99), (44, 31, 14, 1, 49.99), (45, 32, 42, 1, 44.99), (46, 33, 17, 1, 69.99), (47, 34, 19, 1, 129.99), (48, 35, 20, 1, 39.99), (49, 36, 39, 1, 24.99); -- Orders 37-52 (April 2024) INSERT INTO order_items (id, order_id, product_id, quantity, unit_price) VALUES (50, 37, 1, 1, 499.99), (51, 38, 16, 2, 29.99), (52, 39, 12, 1, 279.99), (53, 40, 29, 1, 34.99), (54, 41, 11, 1, 129.99), (55, 42, 33, 1, 89.99), (56, 43, 3, 1, 349.99), (57, 44, 18, 1, 64.99), (58, 45, 15, 1, 149.99), (59, 45, 14, 1, 49.99), (60, 46, 25, 1, 12.99), (61, 46, 22, 1, 16.99), (62, 46, 21, 1, 14.99), (63, 47, 34, 1, 79.99), (64, 48, 9, 1, 249.99), (65, 49, 47, 1, 59.99), (66, 49, 48, 1, 36.99), (67, 49, 46, 1, 28.99), (68, 50, 37, 1, 29.99), (69, 51, 38, 1, 119.99), (70, 52, 43, 1, 19.99), (71, 52, 36, 1, 34.99); -- Orders 53-70 (May 2024) INSERT INTO order_items (id, order_id, product_id, quantity, unit_price) VALUES (72, 53, 6, 1, 449.99), (73, 54, 17, 1, 69.99), (74, 55, 29, 1, 34.99), (75, 56, 33, 1, 89.99), (76, 57, 10, 1, 299.99), (77, 58, 39, 1, 24.99), (78, 59, 15, 1, 149.99), (79, 60, 13, 1, 59.99), (80, 61, 2, 1, 449.99), (81, 61, 14, 1, 49.99), (82, 62, 20, 1, 39.99), (83, 63, 9, 1, 249.99), (84, 64, 42, 1, 44.99), (85, 65, 19, 1, 129.99), (86, 66, 9, 1, 249.99), (87, 67, 43, 1, 19.99), (88, 68, 3, 1, 349.99), (89, 69, 18, 1, 64.99), (90, 70, 34, 1, 79.99); -- Orders 71-88 (June 2024) INSERT INTO order_items (id, order_id, product_id, quantity, unit_price) VALUES (91, 71, 38, 1, 119.99), (92, 72, 35, 1, 29.99), (93, 73, 2, 1, 449.99), (94, 74, 25, 2, 12.99), (95, 74, 23, 1, 15.99), (96, 74, 50, 3, 16.99), (97, 75, 47, 1, 59.99), (98, 75, 48, 1, 36.99), (99, 75, 46, 2, 28.99), (100, 76, 36, 1, 34.99), (101, 77, 4, 1, 299.99), (102, 78, 21, 2, 14.99), (103, 78, 22, 1, 16.99), (104, 78, 24, 1, 13.99), (105, 79, 34, 1, 79.99), (106, 80, 9, 1, 249.99), (107, 81, 25, 1, 12.99), (108, 81, 26, 1, 18.99), (109, 82, 19, 1, 129.99), (110, 83, 15, 1, 149.99), (111, 83, 14, 1, 49.99), (112, 84, 13, 1, 59.99), (113, 85, 33, 1, 89.99), (114, 86, 1, 1, 499.99), (115, 87, 43, 1, 19.99), (116, 87, 45, 1, 14.99), (117, 88, 39, 1, 24.99); -- Orders 89-108 (July 2024) INSERT INTO order_items (id, order_id, product_id, quantity, unit_price) VALUES (118, 89, 3, 1, 349.99), (119, 90, 42, 1, 44.99), (120, 91, 11, 1, 129.99), (121, 92, 34, 1, 79.99), (122, 93, 2, 1, 449.99), (123, 93, 14, 1, 49.99), (124, 94, 37, 2, 29.99), (125, 95, 12, 1, 279.99), (126, 96, 33, 1, 89.99), (127, 97, 15, 1, 149.99), (128, 97, 14, 1, 49.99), (129, 98, 29, 1, 34.99), (130, 99, 15, 1, 149.99), (131, 100, 18, 1, 64.99), (132, 101, 9, 1, 249.99), (133, 102, 20, 1, 39.99), (134, 103, 38, 1, 119.99), (135, 104, 6, 1, 449.99), (136, 105, 35, 1, 29.99), (137, 106, 17, 1, 69.99), (138, 107, 10, 1, 299.99), (139, 108, 42, 1, 44.99); -- Orders 109-128 (August 2024) INSERT INTO order_items (id, order_id, product_id, quantity, unit_price) VALUES (140, 109, 54, 1, 89.99), (141, 110, 1, 1, 499.99), (142, 111, 25, 2, 12.99), (143, 111, 27, 1, 34.99), (144, 112, 19, 1, 129.99), (145, 113, 9, 1, 249.99), (146, 114, 43, 1, 19.99), (147, 115, 3, 1, 349.99), (148, 116, 34, 1, 79.99), (149, 117, 47, 1, 59.99), (150, 117, 48, 1, 36.99), (151, 117, 46, 2, 28.99), (152, 118, 18, 1, 64.99), (153, 119, 4, 1, 299.99), (154, 120, 25, 1, 12.99), (155, 120, 22, 1, 16.99), (156, 120, 21, 1, 14.99), (157, 121, 38, 1, 119.99), (158, 121, 37, 1, 29.99), (159, 121, 41, 1, 27.99), (160, 122, 29, 1, 34.99), (161, 123, 6, 1, 449.99), (162, 124, 13, 1, 59.99), (163, 125, 36, 1, 34.99), (164, 125, 35, 1, 29.99), (165, 125, 39, 1, 24.99), (166, 126, 19, 1, 129.99), (167, 127, 39, 1, 24.99), (168, 128, 34, 1, 79.99); -- Orders 129-148 (September 2024) INSERT INTO order_items (id, order_id, product_id, quantity, unit_price) VALUES (169, 129, 2, 1, 449.99), (170, 129, 14, 1, 49.99), (171, 130, 43, 1, 19.99), (172, 130, 45, 1, 14.99), (173, 131, 15, 1, 149.99), (174, 132, 33, 1, 89.99), (175, 133, 12, 1, 279.99), (176, 134, 17, 1, 69.99), (177, 135, 38, 1, 119.99), (178, 135, 34, 1, 79.99), (179, 136, 38, 1, 119.99), (180, 137, 42, 1, 44.99), (181, 138, 16, 2, 29.99), (182, 139, 3, 1, 349.99), (183, 140, 37, 1, 29.99), (184, 141, 34, 1, 79.99), (185, 142, 9, 1, 249.99), (186, 143, 2, 1, 449.99), (187, 144, 36, 1, 34.99), (188, 145, 46, 2, 28.99), (189, 145, 50, 2, 16.99), (190, 146, 19, 1, 129.99), (191, 147, 47, 1, 59.99), (192, 148, 15, 1, 149.99), (193, 148, 14, 1, 49.99); -- Orders 149-170 (October 2024) INSERT INTO order_items (id, order_id, product_id, quantity, unit_price) VALUES (194, 149, 10, 1, 299.99), (195, 150, 25, 2, 12.99), (196, 150, 27, 1, 34.99), (197, 151, 2, 1, 449.99), (198, 152, 34, 1, 79.99), (199, 153, 15, 1, 149.99), (200, 154, 29, 1, 34.99), (201, 155, 38, 1, 119.99), (202, 155, 37, 1, 29.99), (203, 155, 41, 1, 27.99), (204, 155, 50, 1, 16.99), (205, 156, 54, 1, 89.99), (206, 157, 1, 1, 499.99), (207, 158, 25, 1, 12.99), (208, 158, 22, 1, 16.99), (209, 158, 21, 1, 14.99), (210, 159, 19, 1, 129.99), (211, 160, 9, 1, 249.99), (212, 161, 18, 1, 64.99), (213, 162, 38, 1, 119.99), (214, 163, 3, 1, 349.99), (215, 164, 13, 1, 59.99), (216, 165, 20, 2, 39.99), (217, 166, 10, 1, 299.99), (218, 167, 42, 1, 44.99), (219, 168, 47, 1, 59.99), (220, 168, 48, 1, 36.99), (221, 168, 46, 2, 28.99), (222, 169, 36, 1, 34.99), (223, 169, 35, 1, 29.99), (224, 169, 39, 1, 24.99), (225, 170, 37, 1, 29.99); -- Orders 171-200 (November 2024 — holiday ramp-up) INSERT INTO order_items (id, order_id, product_id, quantity, unit_price) VALUES (226, 171, 2, 1, 449.99), (227, 171, 14, 1, 49.99), (228, 172, 9, 1, 249.99), (229, 173, 3, 1, 349.99), (230, 174, 25, 2, 12.99), (231, 174, 23, 1, 15.99), (232, 174, 50, 2, 16.99), (233, 175, 11, 1, 129.99), (234, 176, 47, 1, 59.99), (235, 177, 6, 1, 449.99), (236, 178, 20, 2, 39.99), (237, 179, 15, 1, 149.99), (238, 179, 14, 1, 49.99), (239, 180, 29, 1, 34.99), (240, 181, 10, 1, 299.99), (241, 182, 38, 1, 119.99), (242, 183, 2, 1, 449.99), (243, 184, 21, 2, 14.99), (244, 184, 22, 1, 16.99), (245, 184, 24, 1, 13.99), (246, 185, 33, 1, 89.99), (247, 185, 17, 1, 69.99), (248, 186, 9, 1, 249.99), (249, 187, 54, 1, 89.99), (250, 188, 25, 1, 12.99), (251, 188, 26, 1, 18.99), (252, 188, 21, 1, 14.99), (253, 189, 1, 1, 499.99), (254, 190, 38, 1, 119.99), (255, 190, 34, 1, 79.99), (256, 191, 5, 1, 499.99), (257, 192, 34, 1, 79.99), (258, 193, 4, 1, 299.99), (259, 194, 16, 2, 29.99), (260, 195, 19, 1, 129.99), (261, 196, 6, 1, 449.99), (262, 197, 47, 1, 59.99), (263, 197, 48, 1, 36.99), (264, 197, 46, 2, 28.99), (265, 197, 49, 1, 39.99), (266, 198, 36, 1, 34.99), (267, 198, 35, 1, 29.99), (268, 198, 39, 1, 24.99), (269, 199, 29, 1, 34.99), (270, 200, 9, 1, 249.99); -- Orders 201-230 (December 2024 — peak holiday) INSERT INTO order_items (id, order_id, product_id, quantity, unit_price) VALUES (271, 201, 2, 1, 449.99), (272, 201, 41, 1, 27.99), (273, 202, 3, 1, 349.99), (274, 203, 9, 1, 249.99), (275, 204, 19, 1, 129.99), (276, 205, 33, 1, 89.99), (277, 206, 6, 1, 449.99), (278, 207, 25, 2, 12.99), (279, 207, 21, 1, 14.99), (280, 207, 22, 1, 16.99), (281, 208, 10, 1, 299.99), (282, 209, 15, 1, 149.99), (283, 209, 14, 1, 49.99), (284, 210, 34, 1, 79.99), (285, 211, 38, 1, 119.99), (286, 212, 1, 1, 499.99), (287, 213, 16, 2, 29.99), (288, 214, 5, 1, 499.99), (289, 215, 9, 1, 249.99), (290, 216, 25, 2, 12.99), (291, 216, 23, 1, 15.99), (292, 216, 50, 3, 16.99), (293, 217, 47, 1, 59.99), (294, 217, 48, 1, 36.99), (295, 217, 46, 2, 28.99), (296, 218, 2, 1, 449.99), (297, 219, 36, 1, 34.99), (298, 220, 15, 1, 149.99), (299, 220, 13, 1, 59.99), (300, 221, 5, 1, 499.99), (301, 222, 19, 1, 129.99), (302, 223, 12, 1, 279.99), (303, 224, 7, 1, 479.99), (304, 225, 33, 1, 89.99), (305, 226, 3, 1, 349.99), (306, 227, 15, 1, 149.99), (307, 227, 14, 1, 49.99), (308, 228, 9, 1, 249.99), (309, 229, 38, 1, 119.99), (310, 229, 37, 1, 29.99), (311, 230, 1, 1, 499.99); -- Additional order items to bring total to ~600 -- These add second/third items to existing orders for richer analytics INSERT INTO order_items (id, order_id, product_id, quantity, unit_price) VALUES (312, 2, 50, 1, 16.99), (313, 3, 25, 1, 12.99), (314, 3, 37, 1, 29.99), (315, 5, 25, 1, 12.99), (316, 7, 25, 1, 12.99), (317, 7, 30, 1, 44.99), (318, 9, 25, 1, 12.99), (319, 11, 41, 1, 27.99), (320, 11, 50, 1, 16.99), (321, 12, 50, 1, 16.99), (322, 14, 41, 1, 27.99), (323, 15, 41, 1, 27.99), (324, 16, 21, 1, 14.99), (325, 16, 37, 1, 29.99), (326, 17, 45, 1, 14.99), (327, 18, 37, 1, 29.99), (328, 20, 43, 1, 19.99), (329, 20, 50, 1, 16.99), (330, 21, 25, 1, 12.99), (331, 22, 25, 1, 12.99), (332, 22, 50, 1, 16.99), (333, 23, 39, 1, 24.99), (334, 23, 50, 1, 16.99), (335, 25, 41, 1, 27.99), (336, 25, 50, 1, 16.99), (337, 27, 25, 1, 12.99), (338, 27, 41, 1, 27.99), (339, 28, 50, 1, 16.99), (340, 29, 37, 1, 29.99), (341, 29, 41, 1, 27.99), (342, 30, 25, 1, 12.99), (343, 31, 50, 1, 16.99), (344, 33, 25, 1, 12.99), (345, 33, 37, 1, 29.99), (346, 34, 25, 1, 12.99), (347, 35, 25, 1, 12.99), (348, 36, 45, 1, 14.99), (349, 37, 37, 1, 29.99), (350, 37, 41, 1, 27.99), (351, 38, 25, 1, 12.99), (352, 39, 50, 1, 16.99), (353, 39, 25, 1, 12.99), (354, 40, 25, 1, 12.99), (355, 41, 25, 1, 12.99), (356, 41, 50, 1, 16.99), (357, 42, 25, 1, 12.99), (358, 43, 14, 1, 49.99), (359, 43, 25, 1, 12.99), (360, 44, 25, 1, 12.99), (361, 45, 25, 1, 12.99), (362, 45, 50, 1, 16.99), (363, 47, 25, 1, 12.99), (364, 48, 25, 1, 12.99), (365, 48, 37, 1, 29.99), (366, 50, 25, 1, 12.99), (367, 50, 50, 1, 16.99), (368, 51, 25, 1, 12.99), (369, 52, 25, 1, 12.99), (370, 53, 37, 1, 29.99), (371, 53, 41, 1, 27.99), (372, 54, 25, 1, 12.99), (373, 55, 45, 1, 14.99), (374, 55, 25, 1, 12.99), (375, 56, 25, 1, 12.99), (376, 57, 25, 1, 12.99), (377, 57, 37, 1, 29.99), (378, 58, 45, 1, 14.99), (379, 59, 50, 1, 16.99), (380, 59, 25, 1, 12.99), (381, 60, 25, 1, 12.99), (382, 61, 25, 1, 12.99), (383, 61, 37, 1, 29.99), (384, 62, 25, 1, 12.99), (385, 63, 25, 1, 12.99), (386, 63, 50, 1, 16.99), (387, 64, 25, 1, 12.99), (388, 65, 50, 1, 16.99), (389, 66, 25, 1, 12.99), (390, 67, 25, 1, 12.99), (391, 68, 25, 1, 12.99), (392, 68, 50, 1, 16.99), (393, 70, 25, 1, 12.99), (394, 70, 50, 1, 16.99), (395, 71, 25, 1, 12.99), (396, 71, 40, 1, 49.99), (397, 72, 45, 1, 14.99), (398, 73, 9, 1, 249.99), (399, 73, 37, 1, 29.99), (400, 75, 50, 2, 16.99), (401, 75, 25, 1, 12.99), (402, 77, 14, 1, 49.99), (403, 77, 25, 1, 12.99), (404, 79, 25, 1, 12.99), (405, 79, 50, 1, 16.99), (406, 80, 25, 1, 12.99), (407, 80, 37, 1, 29.99), (408, 82, 25, 1, 12.99), (409, 82, 50, 1, 16.99), (410, 83, 25, 1, 12.99), (411, 83, 37, 1, 29.99), (412, 84, 25, 1, 12.99), (413, 84, 50, 1, 16.99), (414, 86, 9, 1, 249.99), (415, 86, 25, 1, 12.99), (416, 88, 45, 1, 14.99), (417, 89, 25, 1, 12.99), (418, 90, 25, 1, 12.99), (419, 91, 25, 1, 12.99), (420, 92, 25, 1, 12.99), (421, 93, 25, 1, 12.99), (422, 95, 50, 1, 16.99), (423, 96, 25, 1, 12.99), (424, 97, 25, 1, 12.99), (425, 98, 25, 1, 12.99), (426, 99, 13, 1, 59.99), (427, 100, 25, 1, 12.99), (428, 101, 25, 1, 12.99), (429, 102, 25, 1, 12.99), (430, 103, 41, 1, 27.99), (431, 104, 25, 1, 12.99), (432, 105, 25, 1, 12.99), (433, 106, 25, 1, 12.99), (434, 107, 25, 1, 12.99), (435, 108, 25, 1, 12.99), (436, 109, 37, 1, 29.99), (437, 110, 9, 1, 249.99), (438, 111, 50, 2, 16.99), (439, 112, 21, 1, 14.99), (440, 113, 25, 1, 12.99), (441, 114, 44, 1, 34.99), (442, 115, 14, 1, 49.99), (443, 116, 43, 1, 19.99), (444, 117, 50, 2, 16.99), (445, 118, 21, 1, 14.99), (446, 119, 25, 1, 12.99), (447, 120, 50, 1, 16.99), (448, 122, 45, 1, 14.99), (449, 123, 25, 1, 12.99), (450, 124, 50, 1, 16.99), (451, 125, 50, 1, 16.99), (452, 126, 50, 1, 16.99), (453, 127, 45, 1, 14.99), (454, 128, 25, 1, 12.99), (455, 129, 25, 1, 12.99), (456, 130, 44, 1, 34.99), (457, 131, 14, 1, 49.99), (458, 132, 25, 1, 12.99), (459, 134, 25, 1, 12.99), (460, 136, 41, 1, 27.99), (461, 137, 25, 1, 12.99), (462, 138, 25, 1, 12.99), (463, 139, 25, 1, 12.99), (464, 140, 45, 1, 14.99), (465, 141, 50, 1, 16.99), (466, 142, 25, 1, 12.99), (467, 143, 25, 1, 12.99), (468, 144, 25, 1, 12.99), (469, 145, 25, 1, 12.99), (470, 146, 25, 1, 12.99), (471, 147, 25, 1, 12.99), (472, 148, 25, 1, 12.99), (473, 149, 25, 1, 12.99), (474, 150, 50, 1, 16.99), (475, 151, 25, 1, 12.99), (476, 152, 25, 1, 12.99), (477, 153, 25, 1, 12.99), (478, 155, 25, 1, 12.99), (479, 156, 25, 1, 12.99), (480, 157, 25, 1, 12.99), (481, 158, 50, 1, 16.99), (482, 160, 25, 1, 12.99), (483, 161, 25, 1, 12.99), (484, 162, 25, 1, 12.99), (485, 163, 14, 1, 49.99), (486, 164, 25, 1, 12.99), (487, 165, 25, 1, 12.99), (488, 166, 25, 1, 12.99), (489, 167, 25, 1, 12.99), (490, 168, 25, 1, 12.99), (491, 169, 25, 1, 12.99), (492, 170, 45, 1, 14.99), (493, 171, 25, 2, 12.99), (494, 172, 25, 1, 12.99), (495, 172, 37, 1, 29.99), (496, 173, 25, 1, 12.99), (497, 174, 44, 1, 34.99), (498, 175, 25, 1, 12.99), (499, 176, 25, 1, 12.99), (500, 177, 25, 1, 12.99), (501, 178, 43, 1, 19.99), (502, 179, 25, 1, 12.99), (503, 180, 25, 1, 12.99), (504, 181, 25, 1, 12.99), (505, 182, 41, 1, 27.99), (506, 183, 25, 1, 12.99), (507, 184, 50, 1, 16.99), (508, 185, 25, 1, 12.99), (509, 186, 25, 1, 12.99), (510, 186, 37, 1, 29.99), (511, 187, 25, 1, 12.99), (512, 188, 50, 1, 16.99), (513, 189, 25, 1, 12.99), (514, 189, 37, 1, 29.99), (515, 191, 25, 1, 12.99), (516, 191, 41, 1, 27.99), (517, 192, 25, 1, 12.99), (518, 193, 25, 1, 12.99), (519, 193, 41, 1, 27.99), (520, 194, 25, 1, 12.99), (521, 195, 25, 1, 12.99), (522, 195, 41, 1, 27.99), (523, 196, 25, 1, 12.99), (524, 196, 41, 1, 27.99), (525, 197, 25, 1, 12.99), (526, 198, 25, 1, 12.99), (527, 198, 50, 1, 16.99), (528, 199, 25, 1, 12.99), (529, 200, 25, 1, 12.99), (530, 200, 37, 1, 29.99), (531, 201, 25, 2, 12.99), (532, 201, 37, 1, 29.99), (533, 202, 25, 1, 12.99), (534, 202, 41, 1, 27.99), (535, 203, 25, 1, 12.99), (536, 203, 37, 1, 29.99), (537, 204, 25, 1, 12.99), (538, 204, 50, 1, 16.99), (539, 205, 25, 1, 12.99), (540, 206, 25, 1, 12.99), (541, 206, 37, 1, 29.99), (542, 207, 50, 1, 16.99), (543, 208, 25, 1, 12.99), (544, 208, 37, 1, 29.99), (545, 209, 25, 1, 12.99), (546, 210, 25, 1, 12.99), (547, 210, 37, 1, 29.99), (548, 211, 25, 1, 12.99), (549, 212, 25, 1, 12.99), (550, 212, 41, 1, 27.99), (551, 213, 25, 1, 12.99), (552, 214, 25, 2, 12.99), (553, 214, 37, 1, 29.99), (554, 215, 25, 1, 12.99), (555, 216, 25, 1, 12.99), (556, 216, 44, 1, 34.99), (557, 217, 25, 1, 12.99), (558, 218, 25, 1, 12.99), (559, 218, 37, 1, 29.99), (560, 219, 25, 1, 12.99), (561, 220, 25, 1, 12.99), (562, 220, 37, 1, 29.99), (563, 221, 25, 1, 12.99), (564, 221, 41, 1, 27.99), (565, 222, 25, 1, 12.99), (566, 222, 37, 1, 29.99), (567, 223, 25, 1, 12.99), (568, 224, 25, 1, 12.99), (569, 225, 25, 1, 12.99), (570, 226, 25, 1, 12.99), (571, 226, 41, 1, 27.99), (572, 227, 25, 1, 12.99), (573, 228, 25, 1, 12.99), (574, 228, 37, 1, 29.99), (575, 229, 25, 1, 12.99), (576, 229, 50, 1, 16.99), (577, 230, 25, 4, 12.99), (578, 230, 9, 1, 249.99), (579, 230, 37, 1, 29.99), -- Final handful to hit 600 (580, 6, 21, 1, 14.99), (581, 10, 25, 1, 12.99), (582, 13, 50, 1, 16.99), (583, 15, 25, 1, 12.99), (584, 18, 50, 1, 16.99), (585, 20, 25, 1, 12.99), (586, 26, 50, 1, 16.99), (587, 28, 25, 1, 12.99), (588, 30, 45, 1, 14.99), (589, 32, 25, 1, 12.99), (590, 34, 50, 1, 16.99), (591, 36, 50, 1, 16.99), (592, 38, 50, 1, 16.99), (593, 40, 50, 1, 16.99), (594, 42, 50, 1, 16.99), (595, 44, 50, 1, 16.99), (596, 46, 50, 1, 16.99), (597, 48, 50, 1, 16.99), (598, 50, 45, 1, 14.99), (599, 52, 50, 1, 16.99), (600, 54, 50, 1, 16.99); -- ============================================================ -- REVIEWS (180 total) -- Ratings skewed toward 3-5; review_date after plausible order -- Some reviews have NULL title -- ============================================================ INSERT INTO reviews (id, product_id, customer_id, rating, title, comment, review_date) VALUES -- Smartphones (1, 2, 1, 5, 'Best phone I have owned', 'The camera is incredible and the titanium frame feels premium. Battery lasts all day.', '2024-01-20 14:00:00'), (2, 2, 5, 4, 'Great but pricey', 'Excellent phone overall. The dynamic island is useful but takes getting used to.', '2024-02-10 10:30:00'), (3, 3, 7, 5, 'AI features are amazing', 'The photo editing AI is like magic. Best Pixel yet.', '2024-02-15 16:00:00'), (4, 1, 2, 4, NULL, 'Love the S Pen for taking notes. Screen is gorgeous.', '2024-03-05 11:15:00'), (5, 2, 4, 5, 'Switched from Android', 'The ecosystem just works. AirDrop, iMessage, everything is seamless.', '2024-04-20 09:00:00'), (6, 3, 1, 4, 'Solid mid-range choice', 'Great value for the price. Camera is surprisingly good in low light.', '2024-06-01 13:45:00'), (7, 1, 7, 5, 'Samsung nailed it', 'The zoom camera is unreal. 100x zoom actually works!', '2024-07-15 10:00:00'), (8, 4, 3, 4, NULL, 'Fast charging is the best feature. Full charge in 30 minutes.', '2024-08-20 15:30:00'), (9, 2, 10, 5, 'Worth every penny', 'Third iPhone and still impressed. The video quality is professional grade.', '2024-09-10 11:00:00'), (10, 3, 6, 3, 'Good but some bugs', 'Had a few software glitches in the first week. Updates fixed most of them.', '2024-10-05 14:20:00'), -- Laptops (11, 5, 4, 5, 'M3 chip is incredible', 'Compiles code in seconds. Fan never turns on. 18-hour battery life.', '2024-02-01 09:30:00'), (12, 6, 3, 4, 'Perfect work laptop', 'The keyboard is the best in the business. Light enough for daily commute.', '2024-03-15 12:00:00'), (13, 5, 1, 5, NULL, 'Best laptop purchase ever. Runs everything I need without breaking a sweat.', '2024-05-01 14:00:00'), (14, 7, 25, 4, 'Beautiful display', 'The OLED screen is stunning for photo editing. Gets a bit warm under load though.', '2024-04-01 10:15:00'), (15, 6, 15, 5, 'Business class', 'Survived a coffee spill thanks to the spill-resistant keyboard. True ThinkPad.', '2024-06-25 16:30:00'), (16, 5, 2, 4, 'Almost perfect', 'Only wish it had more ports. Otherwise the best ultrabook out there.', '2024-08-15 11:00:00'), (17, 8, 8, 3, 'Nice but heavy', 'Beautiful design but heavier than expected. Hinge is solid though.', '2024-04-10 09:45:00'), -- Audio (18, 9, 1, 5, 'Noise cancellation is next level', 'Can not hear anything on the subway. Sound quality is perfect for the size.', '2024-02-20 13:00:00'), (19, 10, 4, 5, 'Audiophile approved', 'The best over-ear headphones period. Comfortable for 8-hour work sessions.', '2024-04-05 10:30:00'), (20, 9, 2, 4, NULL, 'Great earbuds. Spatial audio is fun for movies. Wish the case was smaller.', '2024-05-20 15:00:00'), (21, 11, 6, 5, 'Perfect outdoor speaker', 'Took it camping and it survived rain. Bass is impressive for the size.', '2024-03-18 11:45:00'), (22, 10, 3, 4, 'Comfortable and great sound', 'Wear them all day for work calls. Auto-pause when I take them off is handy.', '2024-07-01 14:00:00'), (23, 9, 5, 5, 'Third pair and still love them', 'Bought as a gift after loving mine. The transparency mode is so natural.', '2024-08-01 09:15:00'), (24, 12, 8, 4, 'Classic Bose quality', 'Not as feature-rich as Sony but the comfort is unmatched.', '2024-09-05 16:00:00'), (25, 11, 12, 4, NULL, 'Good speaker for the price. Battery lasts forever.', '2024-05-10 10:00:00'), (26, 9, 20, 5, 'Essential purchase', 'Use them every single day. Best Apple accessory by far.', '2024-07-20 12:30:00'), -- Men's Clothing (27, 13, 5, 4, 'Classic fit is perfect', 'True to size. The cotton is thick and durable. Looks great tucked or untucked.', '2024-03-01 09:00:00'), (28, 14, 1, 5, 'Best chinos for the price', 'The stretch is just right. Comfortable enough for the office and weekends.', '2024-02-25 14:30:00'), (29, 15, 5, 5, 'Looks expensive', 'Received multiple compliments at a conference. Versatile for dress up or down.', '2024-05-05 11:00:00'), (30, 16, 11, 4, NULL, 'Soft cotton, nice prints. Good for casual Fridays.', '2024-06-15 15:45:00'), (31, 13, 8, 3, 'Decent but wrinkles easily', 'Quality is good but I have to iron it every time. Non-iron version would be nice.', '2024-04-15 10:00:00'), (32, 14, 20, 5, 'Replaced all my old chinos', 'Bought three pairs in different colors. They hold up great in the wash.', '2024-07-25 13:00:00'), (33, 15, 29, 4, 'Sharp looking blazer', 'Material is quality. Runs slightly small so size up.', '2024-09-01 09:30:00'), -- Women's Clothing (34, 17, 2, 5, 'My go-to dress', 'Flattering on every body type. The print is even prettier in person.', '2024-02-10 14:00:00'), (35, 18, 6, 4, 'Great everyday jeans', 'Comfortable all day. The high rise stays up without a belt.', '2024-03-25 10:30:00'), (36, 19, 14, 5, 'Luxuriously soft', 'Worth every penny. Keeps me warm without being bulky.', '2024-04-25 16:00:00'), (37, 20, 12, 4, NULL, 'Good quality for the price. Squat proof and no see-through issues.', '2024-05-30 11:15:00'), (38, 17, 22, 5, 'Perfect for brunch', 'Machine washable cashmere! It actually held up perfectly.', '2024-06-10 09:00:00'), (39, 18, 10, 4, 'Nice stretch', 'Comfortable and flattering. Faded a tiny bit after several washes.', '2024-07-15 14:30:00'), (40, 19, 30, 5, 'Best sweater I own', 'The cashmere is incredibly soft. Bought it in two colors.', '2024-08-05 10:00:00'), (41, 20, 40, 3, 'Good but pilling issue', 'Comfortable to work out in but started pilling after a month.', '2024-09-20 15:00:00'), -- Fiction Books (42, 21, 3, 5, 'Changed my perspective', 'A beautiful story about choices and regret. Could not put it down.', '2024-01-25 13:00:00'), (43, 22, 1, 5, 'Even better than The Martian', 'Andy Weir outdid himself. The science is fascinating and the humor is perfect.', '2024-02-05 10:00:00'), (44, 23, 14, 4, 'Witty and empowering', 'Loved the main character. The 1960s setting is vividly written.', '2024-03-10 16:30:00'), (45, 21, 6, 4, NULL, 'Great concept, good execution. Some parts dragged a bit.', '2024-04-01 11:00:00'), (46, 22, 10, 5, 'Could not stop reading', 'Finished it in two days. The mystery unfolds perfectly.', '2024-05-15 14:00:00'), (47, 24, 20, 3, 'Interesting premise', 'Good start but lost steam in the middle. Ending was satisfying though.', '2024-06-20 09:30:00'), (48, 21, 15, 5, 'Perfect book club pick', 'Generated amazing discussion. Everyone loved it.', '2024-07-10 12:00:00'), (49, 23, 2, 5, 'Hilarious and moving', 'Laughed out loud multiple times. Also brought tears. A rare combination.', '2024-08-15 15:00:00'), (50, 22, 25, 4, 'Smart sci-fi', 'Does a great job making complex science accessible. Thoroughly enjoyed it.', '2024-09-05 10:30:00'), -- Non-Fiction Books (51, 25, 1, 5, 'Life changing book', 'Started small habits after reading this. Already seeing results after 3 months.', '2024-02-15 13:00:00'), (52, 25, 3, 5, 'Must read for everyone', 'Clear, actionable, and backed by science. The habit stacking concept is genius.', '2024-03-01 09:00:00'), (53, 26, 10, 4, 'Dense but rewarding', 'Takes effort to get through but completely changes how you think about decisions.', '2024-04-10 14:30:00'), (54, 27, 5, 5, 'Essential for DevOps', 'Required reading for our entire engineering team. Transformed our workflow.', '2024-05-01 10:00:00'), (55, 25, 7, 5, NULL, 'Bought five copies as gifts. Everyone loves it.', '2024-06-15 16:00:00'), (56, 28, 4, 4, 'Comprehensive reference', 'Great for understanding data architecture. Keep it on my desk.', '2024-07-01 11:30:00'), (57, 25, 11, 5, 'The best self-help book', 'Not your typical self-help. Practical, evidence-based, and actually works.', '2024-08-10 09:00:00'), (58, 27, 17, 4, 'Great for teams', 'We implemented several practices from this book. Deployment frequency doubled.', '2024-09-15 14:00:00'), (59, 25, 20, 5, 'Read it twice', 'Even better the second time. Caught nuances I missed initially.', '2024-10-01 10:45:00'), (60, 26, 14, 3, 'Important but dry', 'The insights are valuable but the writing style is academic. Worth pushing through.', '2024-10-20 15:00:00'), -- Home & Garden (61, 29, 8, 4, 'Beautiful planters', 'Modern design looks great on my windowsill. Drainage holes are a nice touch.', '2024-03-25 13:00:00'), (62, 30, 1, 5, 'Best desk lamp', 'The adjustable brightness is perfect. USB port is surprisingly useful.', '2024-02-01 10:00:00'), (63, 31, 15, 4, NULL, 'Cozy and soft. Good size for the couch. Washes well.', '2024-04-05 16:30:00'), (64, 29, 22, 5, 'Perfect gift', 'Bought for my mom and she loves them. Quality is excellent for the price.', '2024-05-15 11:00:00'), (65, 30, 6, 4, 'Functional and stylish', 'Replaced my old desk lamp. The touch controls are intuitive.', '2024-06-10 14:00:00'), (66, 32, 26, 3, 'OK quality', 'Looks nice from a distance but up close the print quality is average.', '2024-07-25 09:30:00'), (67, 31, 35, 5, 'So cozy', 'Perfect for movie nights. The microfiber is incredibly soft.', '2024-08-15 12:00:00'), (68, 53, 4, 4, 'Fun indoor garden', 'Growing herbs in my kitchen now. Setup was easy, results are satisfying.', '2024-09-01 15:00:00'), -- Kitchen (69, 33, 6, 5, 'Professional quality knives', 'Incredibly sharp out of the box. The chef knife is my favorite.', '2024-02-20 10:00:00'), (70, 34, 1, 5, 'Game changer for weeknight meals', 'Makes dinner prep so much faster. The pressure cook function is amazing.', '2024-01-28 14:30:00'), (71, 35, 3, 4, 'Great coffee ritual', 'Makes a clean, smooth cup. The reusable filter saves money on paper ones.', '2024-04-01 09:00:00'), (72, 34, 5, 5, 'Replaced three kitchen gadgets', 'Slow cooker, pressure cooker, and rice maker all in one. Space saver!', '2024-03-10 16:00:00'), (73, 33, 10, 4, NULL, 'Sharp and well balanced. The steak knives are great too.', '2024-05-25 11:30:00'), (74, 36, 8, 5, 'Heirloom quality', 'Gets better with each use. Perfect sear on steaks every time.', '2024-06-15 13:00:00'), (75, 35, 17, 4, 'Simple and effective', 'No fancy features, just great coffee. Glass is thick and durable.', '2024-07-30 10:00:00'), (76, 34, 12, 5, 'Best kitchen purchase', 'Use it at least 4 times a week. The yogurt function is surprisingly good.', '2024-08-20 15:30:00'), (77, 36, 25, 5, 'Cast iron is the way', 'Pre-seasoned and ready to go. Makes amazing cornbread too.', '2024-09-10 09:00:00'), (78, 33, 16, 4, 'Solid knife set', 'Good balance and comfortable handles. The block looks nice on the counter.', '2024-10-01 14:00:00'), -- Sports & Outdoors (79, 37, 6, 5, 'No-slip even when sweaty', 'Excellent grip during hot yoga. Thick enough for joint support.', '2024-02-10 10:00:00'), (80, 38, 3, 4, 'Great cushioning', 'Comfortable for long runs. A bit narrow for wide feet though.', '2024-03-20 14:30:00'), (81, 39, 10, 5, 'Complete home gym starter', 'Five resistance levels cover everything from warm-ups to serious workouts.', '2024-04-15 09:00:00'), (82, 37, 20, 4, NULL, 'Good quality mat. Rolls up nicely. Wish it came with a carrying strap.', '2024-05-01 16:00:00'), (83, 38, 25, 5, 'Best running shoes ever', 'Knocked 2 minutes off my 5K time. So responsive and lightweight.', '2024-06-05 11:30:00'), (84, 40, 9, 4, 'Relaxation upgrade', 'Easy to set up between trees. Holds weight well and fabric is comfortable.', '2024-07-10 13:00:00'), (85, 41, 1, 5, 'Keeps ice for a full day', 'Put ice water in at 6am and still had ice at 10pm. Amazing.', '2024-08-01 10:00:00'), (86, 39, 15, 4, 'Good variety', 'The different resistance levels are clearly labeled. Door anchor is a bonus.', '2024-09-15 15:00:00'), (87, 38, 7, 5, 'Worth the price', 'Feet feel great even after a full marathon training run.', '2024-10-10 09:30:00'), (88, 41, 11, 5, NULL, 'Use it daily at the gym. No leaking, keeps water cold all workout.', '2024-07-01 12:00:00'), -- Toys & Games (89, 42, 13, 5, 'Best board game we own', 'Every game night starts with this. Easy to learn, hard to master.', '2024-03-15 14:00:00'), (90, 43, 10, 4, 'Relaxing and challenging', 'Beautiful image. Piece quality is excellent. Took us two weekends.', '2024-04-20 10:30:00'), (91, 44, 22, 5, 'Kid approved', 'My 8-year-old built a castle on day one. Sparks so much creativity.', '2024-05-10 16:00:00'), (92, 42, 1, 4, NULL, 'Fun strategy game. Games take about 90 minutes which is just right.', '2024-06-25 11:00:00'), (93, 45, 20, 5, 'Great travel game', 'Compact and fun. Perfect for road trips and flights.', '2024-07-15 14:30:00'), (94, 43, 6, 3, 'Missing a piece', 'Nice puzzle but one piece was missing from the box. Contacted support.', '2024-08-05 09:00:00'), (95, 44, 33, 5, 'Hours of entertainment', 'Both my kids love it. Compatible with other major brands too.', '2024-09-20 15:30:00'), (96, 42, 17, 4, 'Great for couples', 'My partner and I play this weekly. Good balance of luck and strategy.', '2024-10-15 10:00:00'), -- Health & Beauty (97, 46, 12, 5, 'Visible results in 2 weeks', 'My skin is noticeably brighter. Absorbs quickly without feeling greasy.', '2024-03-10 13:00:00'), (98, 47, 8, 4, 'Dentist noticed the difference', 'My checkup results improved since switching. Timer feature is helpful.', '2024-04-30 10:00:00'), (99, 48, 6, 5, 'Love the ambiance', 'The LED colors are soothing. Runs quietly. Great for bedtime routine.', '2024-05-20 16:30:00'), (100, 46, 22, 4, NULL, 'Good serum, reasonable price. A little goes a long way.', '2024-06-15 11:00:00'), (101, 49, 5, 3, 'Taste could be better', 'Mixes well and the macros are good but the chocolate flavor is chalky.', '2024-07-05 14:00:00'), (102, 50, 2, 5, 'Best sunscreen ever', 'No white cast, not greasy, and reef safe. Perfect for beach days.', '2024-08-10 09:30:00'), (103, 47, 15, 5, 'Great sonic toothbrush', 'Battery lasts weeks. Replacement heads are affordable too.', '2024-09-01 12:00:00'), (104, 48, 30, 4, 'Relaxing addition', 'Use it every evening. The auto-shutoff is a nice safety feature.', '2024-10-05 15:00:00'), (105, 46, 40, 5, 'Holy grail product', 'Been looking for the right vitamin C serum for years. This is it.', '2024-11-01 10:30:00'), (106, 50, 7, 4, 'No white cast', 'Finally a sunscreen that works under makeup. SPF 50 gives great protection.', '2024-09-25 14:00:00'), -- Electronics accessories (107, 54, 47, 4, 'Satisfying to type on', 'The mechanical switches are perfect for coding. RGB is a nice bonus.', '2024-08-15 10:00:00'), (108, 54, 4, 5, 'Best keyboard upgrade', 'Hot-swappable switches mean I can customize the feel per key.', '2024-09-20 14:30:00'), -- Additional Atomic Habits reviews — bestseller in this dataset (109, 25, 2, 5, 'Bought copies for friends', 'This book genuinely changed my daily routines. The 2-minute rule is brilliant.', '2024-03-20 10:00:00'), (110, 25, 6, 4, 'Practical and actionable', 'Unlike most self-help, this one gives you actual systems to follow.', '2024-04-15 14:00:00'), (111, 25, 8, 5, NULL, 'Highlighted almost every page. So many valuable insights.', '2024-05-10 09:30:00'), (112, 25, 12, 5, 'Transformed my mornings', 'My morning routine went from chaotic to productive thanks to this book.', '2024-06-20 16:00:00'), (113, 25, 15, 4, 'Great concepts', 'The identity-based habits framework is the key takeaway. Very powerful.', '2024-07-25 11:00:00'), (114, 25, 22, 5, 'Read it in one sitting', 'Could not stop. Every chapter had an aha moment.', '2024-08-30 13:00:00'), (115, 25, 25, 5, 'Best book of the decade', 'No exaggeration. This book should be required reading for everyone.', '2024-09-15 10:00:00'), (116, 25, 30, 4, 'Solid advice', 'Some concepts overlap with other habit books but the execution is superior.', '2024-10-05 15:30:00'), (117, 25, 35, 5, 'Bought the audiobook too', 'So good I got the audio version for commutes. James Clear is a fantastic narrator.', '2024-11-10 09:00:00'), (118, 25, 40, 5, NULL, 'My most recommended book of all time. Period.', '2024-11-25 14:00:00'), -- Additional AirPods Pro 2 reviews — another hot product (119, 9, 3, 5, 'Perfect for commuting', 'Noise cancellation makes the subway bearable. Sound quality is top notch.', '2024-04-01 10:00:00'), (120, 9, 7, 4, 'Great but easy to lose', 'Sound is amazing. Just wish the case had a built-in tracker oh wait it does now.', '2024-05-15 14:30:00'), (121, 9, 11, 5, 'Third generation magic', 'Significant improvement over the originals. The adaptive audio is incredible.', '2024-06-20 09:00:00'), (122, 9, 14, 4, NULL, 'Battery life is good. Charges fast in the case. Use them daily.', '2024-07-30 16:00:00'), (123, 9, 22, 5, 'Work from home essential', 'Crisp audio for calls. Colleagues say I sound clear even from another room.', '2024-08-25 11:30:00'), (124, 9, 25, 5, 'Worth the upgrade', 'Upgraded from AirPods 2 and the difference is night and day.', '2024-09-20 13:00:00'), -- Additional Running Shoes reviews (125, 38, 11, 5, 'Marathon ready', 'Trained for my first marathon in these. Zero blisters. Amazing support.', '2024-06-15 10:00:00'), (126, 38, 20, 4, 'Good for daily runs', 'Cushioning holds up after 300+ miles. True to size.', '2024-08-01 14:30:00'), (127, 38, 35, 5, NULL, 'Lightest running shoes I have ever owned. Feel like clouds.', '2024-09-10 09:00:00'), -- Additional Instant Pot reviews (128, 34, 3, 5, 'Weeknight dinner savior', 'Made a full pot roast in 45 minutes. Tastes like it cooked all day.', '2024-04-20 16:00:00'), (129, 34, 10, 4, 'Learning curve worth it', 'Took a few tries to get the timing right but now I use it almost daily.', '2024-06-01 11:00:00'), (130, 34, 20, 5, 'Replaced my slow cooker', 'Does everything the slow cooker did plus so much more. The saute function is great.', '2024-08-15 13:30:00'), (131, 34, 30, 4, NULL, 'Makes great soups and stews. The inner pot is easy to clean.', '2024-09-25 10:00:00'), -- Additional Wool Blend Blazer reviews (132, 15, 3, 5, 'Dress it up or down', 'Wore it with jeans and a tee. Got compliments all night.', '2024-06-10 14:00:00'), (133, 15, 10, 4, 'Nice quality for the price', 'The wool blend breathes well. Good for three-season wear.', '2024-08-01 10:30:00'), (134, 15, 20, 5, 'Conference ready', 'Looked polished at a tech conference without being overdressed.', '2024-10-15 16:00:00'), -- Additional Strategy Board Game reviews (135, 42, 6, 5, 'Replaced video game nights', 'Our friend group switched from online gaming to this. Way more fun in person.', '2024-05-20 09:00:00'), (136, 42, 22, 4, 'Great replay value', 'Played 20+ times and each game feels different. Highly recommend.', '2024-07-10 14:00:00'), (137, 42, 35, 5, NULL, 'Best board game purchase in years. Easy to teach to new players.', '2024-09-01 11:30:00'), -- Additional Cashmere Pullover reviews (138, 19, 2, 5, 'Luxury at a great price', 'Softer than cashmere sweaters costing twice as much.', '2024-04-10 10:00:00'), (139, 19, 10, 4, 'Beautiful quality', 'The colors are rich and vibrant. Holds its shape after washing.', '2024-07-20 15:00:00'), (140, 19, 22, 5, 'My favorite sweater', 'Bought one in every color. Gets softer with each wash.', '2024-09-30 13:00:00'), -- Additional Electric Toothbrush reviews (141, 47, 3, 5, 'My dentist recommends it', 'Teeth have never felt cleaner. The pressure sensor prevents over-brushing.', '2024-05-15 10:00:00'), (142, 47, 20, 4, NULL, 'Good value for a sonic brush. Kids like the timer feature.', '2024-07-01 14:30:00'), (143, 47, 30, 5, 'Great investment in health', 'Three months in and already seeing whiter teeth. Battery lasts 2 weeks.', '2024-10-20 09:00:00'), -- Low-rating reviews for realism (144, 24, 3, 2, 'Did not finish it', 'Started strong but got confusing. Characters were hard to keep track of.', '2024-07-01 16:00:00'), (145, 32, 13, 2, 'Disappointed', 'Colors look different from the photos. Canvas feels thin and cheap.', '2024-06-10 11:00:00'), (146, 49, 17, 2, 'Terrible taste', 'Even with milk and a banana, the flavor is unbearable. Had to throw it out.', '2024-09-05 14:00:00'), (147, 16, 22, 3, 'Shrunk after wash', 'Followed care instructions but they shrank half a size. Order up.', '2024-08-20 10:30:00'), (148, 40, 26, 2, 'Ripped after one use', 'The fabric tore at the seam on the first camping trip. Very disappointing.', '2024-08-10 15:00:00'), (149, 8, 9, 3, 'Average laptop', 'Nothing special for the price. The trackpad is mediocre.', '2024-05-01 09:00:00'), (150, 28, 10, 3, NULL, 'Good content but poorly organized. Could use better diagrams.', '2024-06-15 13:00:00'), -- Remaining reviews to reach 180 (151, 30, 11, 5, 'Perfect study lamp', 'Adjustable color temperature is great for late-night study sessions.', '2024-04-05 10:00:00'), (152, 31, 24, 5, 'Gift hit', 'Gave this as a housewarming gift. They said it is their favorite blanket now.', '2024-05-20 14:00:00'), (153, 33, 21, 5, 'Sharp and balanced', 'The santoku knife is my daily driver. Cuts through everything effortlessly.', '2024-06-30 11:30:00'), (154, 35, 25, 4, 'Morning ritual complete', 'Makes a perfect cup every time. The glass carafe looks elegant on the counter.', '2024-07-15 09:00:00'), (155, 37, 30, 5, 'Best mat for the price', 'Tried mats twice as expensive. This one has better grip.', '2024-08-25 16:00:00'), (156, 39, 35, 4, NULL, 'Good resistance range. The handles are comfortable even during long sets.', '2024-09-10 12:00:00'), (157, 41, 40, 5, 'Daily carry essential', 'Take it everywhere. No condensation on the outside is a huge plus.', '2024-10-20 14:30:00'), (158, 43, 45, 4, 'Rainy day fun', 'Great quality pieces that lock together well. Image is gorgeous when complete.', '2024-08-05 10:00:00'), (159, 45, 14, 5, 'Travel must-have', 'Fits in a pocket and provides hours of fun. Great for waiting rooms.', '2024-09-01 15:00:00'), (160, 46, 30, 4, 'Gentle and effective', 'No irritation even on my sensitive skin. Packaging is also recyclable.', '2024-07-20 11:00:00'), (161, 48, 24, 5, 'Spa at home', 'The mist output is perfect. Essential oils last longer than with my old diffuser.', '2024-08-10 13:00:00'), (162, 50, 12, 5, NULL, 'Finally found a sunscreen that does not make me look like a ghost.', '2024-09-15 09:30:00'), (163, 29, 40, 4, 'Stylish planters', 'The drainage system actually works. My succulents are thriving.', '2024-10-01 16:00:00'), (164, 36, 33, 5, 'Grandma approved', 'Reminded me of my grandmother kitchen. Cooks evenly and keeps heat forever.', '2024-10-15 10:00:00'), (165, 44, 14, 4, 'Creative play', 'Good alternative to screen time. My kids play with these for hours.', '2024-11-01 14:00:00'), (166, 11, 25, 5, 'Pool party speaker', 'Waterproof claim is real. Survived a pool drop. Sound is amazing outdoors.', '2024-07-04 11:00:00'), (167, 13, 17, 4, 'Wardrobe staple', 'The oxford cloth is thick and substantial. Looks better with age.', '2024-08-20 09:00:00'), (168, 17, 36, 5, 'Vacation dress', 'Packed it for a week trip. No wrinkles, comfortable in heat, looked great.', '2024-09-05 15:30:00'), (169, 14, 45, 5, NULL, 'Perfect fit right out of the bag. The stretch makes them incredibly comfortable.', '2024-10-10 12:00:00'), (170, 18, 40, 4, 'Flattering fit', 'The contour fit really does make a difference. True to size.', '2024-11-05 10:00:00'), (171, 21, 34, 5, 'Beautiful storytelling', 'The concept is so creative. Made me appreciate my own life more.', '2024-06-01 14:30:00'), (172, 23, 36, 4, 'Fun read', 'Light enough for beach reading but substantial enough to feel satisfying.', '2024-07-15 09:00:00'), (173, 26, 25, 4, 'Eye opening', 'The anchoring bias chapter alone is worth the read. Changed how I negotiate.', '2024-08-10 16:00:00'), (174, 27, 37, 5, 'DevOps bible', 'Referenced this book countless times at work. The case studies are invaluable.', '2024-09-20 11:00:00'), (175, 10, 7, 5, 'Studio quality', 'Use these for music production. The detail in the high frequencies is amazing.', '2024-10-01 13:30:00'), (176, 12, 39, 3, 'Comfortable but dated', 'Sound is good and they are very comfortable. App could use some work though.', '2024-09-15 10:00:00'), (177, 5, 37, 5, 'Developer dream machine', 'Running Docker, VS Code, and a browser with zero lag. M3 is insane.', '2024-11-01 14:00:00'), (178, 7, 4, 4, NULL, 'The 15-inch screen is perfect for coding. Gets warm during long builds.', '2024-10-10 09:30:00'), (179, 1, 35, 5, 'Android at its best', 'The customization options are endless. Samsung DeX is a hidden gem.', '2024-11-15 16:00:00'), (180, 4, 43, 4, 'Underrated phone', 'OnePlus always delivers great specs at reasonable prices. No complaints.', '2024-10-25 11:00:00');