ecommerce-sql-business-case-study/sample_data.sql at main · EmmanuelThomas2004/ecommerce-sql-business-case-study · GitHub

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
INSERT INTO users VALUES
(1, '2025-01-15', 'USA', 'Premium'),
(2, '2025-02-10', 'India', 'Free'),
(3, '2025-03-01', 'UK', 'Premium'),
(4, '2025-03-15', 'USA', 'Free'),
(5, '2025-04-20', 'India', 'Premium'),
(6, '2025-05-01', 'Germany', 'Free');

INSERT INTO products VALUES
(101, 'iPhone 15', 'Electronics', 999.00),
(102, 'AirPods Pro', 'Electronics', 249.00),
(103, 'Running Shoes', 'Apparel', 120.00),
(104, 'Leather Jacket', 'Apparel', 350.00),
(105, 'Coffee Maker', 'Home', 89.00),
(106, 'Desk Lamp', 'Home', 45.00);

INSERT INTO orders VALUES
(1001, 1, '2025-01-20', 1248.00, 'Completed'),
(1002, 1, '2025-02-15', 249.00, 'Completed'),
(1003, 2, '2025-02-12', 120.00, 'Completed'),
(1004, 3, '2025-03-05', 1349.00, 'Completed'),
(1005, 4, '2025-03-18', 45.00, 'Cancelled'),
(1006, 2, '2025-04-01', 350.00, 'Completed'),
(1007, 1, '2025-04-10', 89.00, 'Completed'),
(1008, 5, '2025-04-25', 999.00, 'Completed'),
(1009, 3, '2025-05-05', 249.00, 'Refunded'),
(1010, 2, '2025-05-10', 45.00, 'Completed'),
(1011, 1, '2025-06-01', 120.00, 'Completed');

INSERT INTO order_items VALUES
(1, 1001, 101, 1, 999.00),
(2, 1001, 102, 1, 249.00),
(3, 1002, 102, 1, 249.00),
(4, 1003, 103, 1, 120.00),
(5, 1004, 101, 1, 999.00),
(6, 1004, 104, 1, 350.00),
(7, 1005, 106, 1, 45.00),
(8, 1006, 104, 1, 350.00),
(9, 1007, 105, 1, 89.00),
(10, 1008, 101, 1, 999.00),
(11, 1009, 102, 1, 249.00),
(12, 1010, 106, 1, 45.00),
(13, 1011, 103, 1, 120.00);

INSERT INTO user_sessions VALUES
(5001, 1, '2025-01-20 10:00:00', '2025-01-20 10:30:00', 12),
(5002, 1, '2025-01-20 14:00:00', '2025-01-20 14:15:00', 5),
(5003, 2, '2025-02-12 09:00:00', '2025-02-12 09:45:00', 20),
(5004, 3, '2025-03-05 18:00:00', '2025-03-05 19:00:00', 35),
(5005, 4, '2025-03-18 11:00:00', '2025-03-18 11:05:00', 2),
(5006, 2, '2025-03-31 23:30:00', '2025-04-01 00:15:00', 18),
(5007, 1, '2025-04-10 08:00:00', '2025-04-10 08:10:00', 4),
(5008, 5, '2025-04-25 15:00:00', '2025-04-25 15:40:00', 25);