-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathOrders.sql
More file actions
116 lines (116 loc) · 13.3 KB
/
Orders.sql
File metadata and controls
116 lines (116 loc) · 13.3 KB
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
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (1, 1, '2023-08-30', 34.29, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (2, 1, '2023-04-02', 34.82, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (3, 1, '2023-01-15', 135.59, 'cancelled');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (4, 2, '2023-02-15', 195.36, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (5, 2, '2022-08-05', 83.32, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (6, 2, '2023-01-28', 59.93, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (7, 2, '2023-07-30', 112.55, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (8, 2, '2024-02-23', 57.25, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (9, 3, '2022-09-23', 53.65, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (10, 3, '2022-06-06', 101.56, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (11, 3, '2022-04-17', 76.43, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (12, 3, '2022-11-06', 29.15, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (13, 4, '2022-05-04', 166.56, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (14, 4, '2023-01-27', 76.16, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (15, 4, '2022-11-06', 24.85, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (16, 4, '2022-06-12', 84.38, 'cancelled');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (17, 4, '2022-07-24', 198.93, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (18, 6, '2024-02-08', 53.22, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (19, 6, '2024-01-25', 144.82, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (20, 6, '2022-09-25', 103.84, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (21, 6, '2023-10-02', 197.69, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (22, 7, '2022-10-06', 117.86, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (23, 7, '2022-02-21', 88.49, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (24, 8, '2022-04-28', 103.57, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (25, 8, '2023-05-24', 135.2, 'cancelled');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (26, 9, '2023-08-13', 40.36, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (27, 10, '2023-07-02', 31.27, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (28, 10, '2022-12-22', 16.24, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (29, 10, '2023-02-25', 186.26, 'cancelled');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (30, 10, '2022-02-23', 71.05, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (31, 11, '2022-01-27', 194.51, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (32, 11, '2022-03-31', 114.65, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (33, 11, '2023-04-18', 101.92, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (34, 11, '2023-04-17', 137.22, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (35, 12, '2023-09-25', 48.14, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (36, 12, '2022-11-29', 94.21, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (37, 13, '2022-12-17', 97.59, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (38, 13, '2022-02-25', 28.02, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (39, 13, '2023-08-10', 162.69, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (40, 14, '2022-10-07', 108.52, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (41, 14, '2023-01-08', 146.0, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (42, 14, '2022-12-29', 13.05, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (43, 14, '2023-07-21', 108.89, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (44, 15, '2024-02-05', 139.66, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (45, 15, '2024-01-08', 186.63, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (46, 16, '2023-02-12', 46.51, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (47, 16, '2022-02-01', 137.37, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (48, 16, '2024-01-03', 159.1, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (49, 16, '2022-07-16', 61.63, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (50, 17, '2022-05-08', 134.18, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (51, 17, '2022-05-29', 19.32, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (52, 17, '2022-11-02', 91.2, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (53, 17, '2022-03-19', 187.36, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (54, 17, '2023-06-10', 63.68, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (55, 18, '2023-10-10', 180.57, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (56, 18, '2022-07-07', 102.96, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (57, 18, '2022-01-19', 69.67, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (58, 18, '2023-09-20', 65.66, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (59, 19, '2024-01-07', 129.89, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (60, 19, '2024-02-28', 73.03, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (61, 19, '2022-02-18', 67.03, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (62, 20, '2023-11-02', 38.43, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (63, 20, '2022-05-03', 69.07, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (64, 20, '2022-10-27', 71.54, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (65, 20, '2023-05-28', 49.35, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (66, 21, '2022-11-30', 75.68, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (67, 21, '2022-04-07', 141.81, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (68, 21, '2023-10-30', 137.7, 'cancelled');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (69, 21, '2023-06-15', 84.74, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (70, 22, '2024-03-01', 26.28, 'cancelled');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (71, 22, '2022-10-23', 148.54, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (72, 22, '2023-05-15', 119.58, 'cancelled');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (73, 22, '2023-08-23', 187.6, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (74, 22, '2023-11-07', 54.11, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (75, 23, '2023-01-07', 61.16, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (76, 23, '2023-07-07', 44.2, 'cancelled');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (77, 23, '2022-02-09', 43.8, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (78, 23, '2022-09-06', 105.09, 'cancelled');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (79, 23, '2022-02-16', 128.28, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (80, 24, '2023-09-03', 8.62, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (81, 25, '2023-10-01', 178.28, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (82, 25, '2022-03-12', 173.41, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (83, 26, '2023-01-17', 75.29, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (84, 26, '2023-11-09', 108.23, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (85, 26, '2022-11-21', 49.62, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (86, 27, '2023-03-09', 62.88, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (87, 27, '2024-01-03', 70.61, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (88, 27, '2022-10-25', 169.08, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (89, 27, '2023-03-28', 168.42, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (90, 27, '2022-03-06', 176.0, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (91, 28, '2024-02-01', 154.15, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (92, 28, '2022-09-10', 28.91, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (93, 28, '2022-06-30', 6.32, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (94, 28, '2023-11-30', 144.52, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (95, 29, '2024-02-20', 174.03, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (96, 29, '2023-01-14', 112.11, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (97, 30, '2023-01-17', 183.95, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (98, 30, '2023-11-20', 16.68, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (99, 30, '2022-12-28', 97.45, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (100, 30, '2023-04-22', 168.08, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (101, 30, '2022-10-28', 39.52, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (102, 31, '2024-01-29', 131.19, 'cancelled');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (103, 31, '2024-01-30', 70.33, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (104, 31, '2022-01-01', 46.22, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (105, 31, '2023-03-01', 106.05, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (106, 32, '2022-05-11', 134.26, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (107, 32, '2023-05-25', 113.55, 'pending');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (108, 33, '2023-11-07', 85.95, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (109, 33, '2023-06-12', 127.56, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (110, 33, '2022-11-28', 135.22, 'cancelled');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (111, 33, '2023-03-08', 150.95, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (112, 34, '2022-11-14', 197.74, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (113, 34, '2022-06-14', 124.44, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (114, 34, '2023-05-11', 95.24, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (115, 35, '2023-05-01', 10.49, 'completed');
INSERT INTO orders (order_id, user_id, order_date, amount, status) VALUES (116, 35, '2023-10-06', 75.88, 'completed');