File size: 2,321 Bytes
981d8b1 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 | INSERT INTO customers (customer_id, name, email, country, created_at) VALUES
(1, 'Alice Johnson', 'alice@example.com', 'USA', DATE '2023-01-15'),
(2, 'Bob Smith', 'bob@example.com', 'USA', DATE '2023-02-20'),
(3, 'Carlos Diaz', 'carlos@example.com','Mexico', DATE '2023-03-10'),
(4, 'Diana Prince', 'diana@example.com', 'UK', DATE '2023-04-05'),
(5, 'Ethan Hunt', 'ethan@example.com', 'USA', DATE '2023-05-12'),
(6, 'Fatima Noor', 'fatima@example.com','UAE', DATE '2023-06-18'),
(7, 'Grace Lee', 'grace@example.com', 'Canada', DATE '2023-07-22'),
(8, 'Hiro Tanaka', 'hiro@example.com', 'Japan', DATE '2023-08-30');
INSERT INTO products (product_id, name, category, price) VALUES
(1, 'Laptop', 'Electronics', 1200.00),
(2, 'Smartphone', 'Electronics', 800.00),
(3, 'Headphones', 'Electronics', 150.00),
(4, 'Desk Chair', 'Furniture', 250.00),
(5, 'Standing Desk', 'Furniture', 450.00),
(6, 'Coffee Maker', 'Appliances', 90.00),
(7, 'Blender', 'Appliances', 60.00),
(8, 'Notebook', 'Stationery', 5.00),
(9, 'Pen Set', 'Stationery', 12.00),
(10, 'Monitor', 'Electronics', 300.00);
INSERT INTO orders (order_id, customer_id, order_date, status) VALUES
(1, 1, DATE '2023-09-01', 'completed'),
(2, 2, DATE '2023-09-03', 'completed'),
(3, 1, DATE '2023-09-10', 'completed'),
(4, 3, DATE '2023-09-15', 'shipped'),
(5, 4, DATE '2023-10-01', 'completed'),
(6, 5, DATE '2023-10-05', 'cancelled'),
(7, 2, DATE '2023-10-10', 'completed'),
(8, 6, DATE '2023-10-12', 'shipped'),
(9, 7, DATE '2023-11-01', 'completed'),
(10, 1, DATE '2023-11-05', 'completed'),
(11, 8, DATE '2023-11-20', 'pending'),
(12, 5, DATE '2023-12-01', 'completed');
INSERT INTO order_items (order_item_id, order_id, product_id, quantity, unit_price) VALUES
(1, 1, 1, 1, 1200.00),
(2, 1, 3, 2, 150.00),
(3, 2, 2, 1, 800.00),
(4, 3, 10, 2, 300.00),
(5, 3, 8, 5, 5.00),
(6, 4, 4, 1, 250.00),
(7, 5, 5, 1, 450.00),
(8, 5, 4, 2, 250.00),
(9, 6, 2, 1, 800.00),
(10, 7, 6, 1, 90.00),
(11, 7, 7, 1, 60.00),
(12, 8, 1, 1, 1200.00),
(13, 9, 3, 1, 150.00),
(14, 9, 9, 3, 12.00),
(15, 10, 2, 1, 800.00),
(16, 11, 8, 10, 5.00),
(17, 12, 10, 1, 300.00);
|