Repository navigation
Expand file tree
/
Copy pathorders.sql
More file actions
331 lines (323 loc) · 35.6 KB
/
Copy pathorders.sql
File metadata and controls
331 lines (323 loc) · 35.6 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
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
-- 300 synthetic orders placed by the users in `users`. Invented data; it describes nobody.
-- Portable enough for SQLite, PostgreSQL, and MySQL.
DROP TABLE IF EXISTS orders;
CREATE TABLE orders (
order_id TEXT PRIMARY KEY,
user_id INTEGER NOT NULL,
ordered_at TEXT NOT NULL,
status TEXT NOT NULL,
items INTEGER NOT NULL,
subtotal REAL NOT NULL,
shipping REAL NOT NULL,
tax REAL NOT NULL,
total REAL NOT NULL,
currency TEXT NOT NULL,
payment_method TEXT NOT NULL,
shipping_city TEXT NOT NULL
);
INSERT INTO orders (order_id, user_id, ordered_at, status, items, subtotal, shipping, tax, total, currency, payment_method, shipping_city) VALUES
('ORD-10001', 11, '2025-01-02T08:40:00Z', 'delivered', 1, 32.31, 9.99, 2.67, 44.97, 'USD', 'card', 'Alderport'),
('ORD-10002', 45, '2025-01-03T11:55:00Z', 'refunded', 2, 228.8, 0.0, 18.88, 247.68, 'USD', 'bank-transfer', 'Cinderhollow'),
('ORD-10003', 37, '2025-01-04T03:45:00Z', 'pending', 2, 379.57, 0.0, 31.31, 410.88, 'USD', 'wallet', 'Dunmarrow'),
('ORD-10004', 56, '2025-01-04T15:42:00Z', 'shipped', 5, 92.81, 0.0, 7.66, 100.47, 'USD', 'card', 'Dunmarrow'),
('ORD-10005', 99, '2025-01-04T18:02:00Z', 'paid', 1, 129.65, 0.0, 10.7, 140.35, 'USD', 'wallet', 'Ironvale'),
('ORD-10006', 8, '2025-01-05T00:18:00Z', 'delivered', 3, 430.42, 0.0, 35.51, 465.93, 'USD', 'card', 'Juniper Rest'),
('ORD-10007', 61, '2025-01-05T17:39:00Z', 'shipped', 2, 142.69, 0.0, 11.77, 154.46, 'USD', 'bank-transfer', 'Oakenshade'),
('ORD-10008', 13, '2025-01-05T23:21:00Z', 'pending', 1, 9.6, 9.99, 0.79, 20.38, 'USD', 'card', 'Stonebay'),
('ORD-10009', 94, '2025-01-06T07:34:00Z', 'shipped', 2, 37.36, 4.99, 3.08, 45.43, 'USD', 'card', 'Vellmont'),
('ORD-10010', 92, '2025-01-06T18:43:00Z', 'shipped', 1, 13.03, 6.99, 1.07, 21.09, 'USD', 'wallet', 'Yarrowend'),
('ORD-10011', 63, '2025-01-07T13:16:00Z', 'paid', 1, 9.96, 9.99, 0.82, 20.77, 'USD', 'bank-transfer', 'Kelbridge'),
('ORD-10012', 92, '2025-01-08T12:09:00Z', 'delivered', 2, 155.38, 0.0, 12.82, 168.2, 'USD', 'card', 'Yarrowend'),
('ORD-10013', 89, '2025-01-10T22:57:00Z', 'delivered', 1, 185.36, 0.0, 15.29, 200.65, 'USD', 'gift-card', 'Marrowfen'),
('ORD-10014', 113, '2025-01-11T06:53:00Z', 'refunded', 1, 25.78, 9.99, 2.13, 37.9, 'USD', 'card', 'Alderport'),
('ORD-10015', 71, '2025-01-13T07:45:00Z', 'refunded', 3, 293.8, 0.0, 24.24, 318.04, 'USD', 'card', 'Quillmoor'),
('ORD-10016', 38, '2025-01-13T20:48:00Z', 'paid', 1, 59.65, 4.99, 4.92, 69.56, 'USD', 'card', 'Westhollow'),
('ORD-10017', 32, '2025-01-15T05:36:00Z', 'shipped', 6, 206.19, 0.0, 17.01, 223.2, 'USD', 'card', 'Dunmarrow'),
('ORD-10018', 16, '2025-01-15T08:51:00Z', 'cancelled', 3, 183.27, 0.0, 15.12, 198.39, 'USD', 'card', 'Yarrowend'),
('ORD-10019', 18, '2025-01-16T07:10:00Z', 'paid', 2, 148.53, 0.0, 12.25, 160.78, 'USD', 'card', 'Glenhaven'),
('ORD-10020', 106, '2025-01-16T21:20:00Z', 'delivered', 3, 134.86, 0.0, 11.13, 145.99, 'USD', 'card', 'Vellmont'),
('ORD-10021', 106, '2025-01-17T18:01:00Z', 'delivered', 3, 214.19, 0.0, 17.67, 231.86, 'USD', 'card', 'Vellmont'),
('ORD-10022', 87, '2025-01-20T15:17:00Z', 'delivered', 6, 216.28, 0.0, 17.84, 234.12, 'USD', 'card', 'Brightwater'),
('ORD-10023', 2, '2025-01-21T12:42:00Z', 'refunded', 2, 176.03, 0.0, 14.52, 190.55, 'USD', 'card', 'Oakenshade'),
('ORD-10024', 12, '2025-01-22T21:42:00Z', 'delivered', 8, 470.14, 0.0, 38.79, 508.93, 'USD', 'card', 'Brightwater'),
('ORD-10025', 92, '2025-01-22T22:32:00Z', 'paid', 2, 188.62, 0.0, 15.56, 204.18, 'USD', 'wallet', 'Yarrowend'),
('ORD-10026', 82, '2025-01-24T07:46:00Z', 'refunded', 7, 223.4, 0.0, 18.43, 241.83, 'USD', 'card', 'Brightwater'),
('ORD-10027', 79, '2025-01-24T23:02:00Z', 'shipped', 3, 20.63, 6.99, 1.7, 29.32, 'USD', 'card', 'Yarrowend'),
('ORD-10028', 28, '2025-01-24T23:59:00Z', 'refunded', 4, 297.33, 0.0, 24.53, 321.86, 'USD', 'card', 'Dunmarrow'),
('ORD-10029', 10, '2025-01-27T00:40:00Z', 'delivered', 1, 25.19, 6.99, 2.08, 34.26, 'USD', 'card', 'Yarrowend'),
('ORD-10030', 37, '2025-01-29T04:16:00Z', 'shipped', 1, 99.67, 0.0, 8.22, 107.89, 'USD', 'card', 'Dunmarrow'),
('ORD-10031', 5, '2025-01-29T07:46:00Z', 'pending', 1, 25.25, 4.99, 2.08, 32.32, 'USD', 'card', 'Ravensford'),
('ORD-10032', 46, '2025-02-01T23:15:00Z', 'cancelled', 4, 309.6, 0.0, 25.54, 335.14, 'USD', 'card', 'Glenhaven'),
('ORD-10033', 81, '2025-02-03T10:32:00Z', 'delivered', 7, 664.69, 0.0, 54.84, 719.53, 'USD', 'card', 'Marrowfen'),
('ORD-10034', 75, '2025-02-06T14:25:00Z', 'paid', 1, 25.81, 4.99, 2.13, 32.93, 'USD', 'card', 'Fernbrook'),
('ORD-10035', 58, '2025-02-06T18:49:00Z', 'paid', 1, 75.28, 0.0, 6.21, 81.49, 'USD', 'card', 'Dunmarrow'),
('ORD-10036', 76, '2025-02-07T01:41:00Z', 'cancelled', 7, 737.33, 0.0, 60.83, 798.16, 'USD', 'card', 'Dunmarrow'),
('ORD-10037', 117, '2025-02-07T13:40:00Z', 'shipped', 5, 636.56, 0.0, 52.52, 689.08, 'USD', 'card', 'Eastvale'),
('ORD-10038', 64, '2025-02-07T14:41:00Z', 'delivered', 3, 158.7, 0.0, 13.09, 171.79, 'USD', 'wallet', 'Dunmarrow'),
('ORD-10039', 53, '2025-02-11T06:17:00Z', 'delivered', 1, 9.12, 4.99, 0.75, 14.86, 'USD', 'bank-transfer', 'Brightwater'),
('ORD-10040', 41, '2025-02-12T11:46:00Z', 'cancelled', 7, 600.95, 0.0, 49.58, 650.53, 'USD', 'card', 'Larkfield'),
('ORD-10041', 10, '2025-02-14T12:59:00Z', 'paid', 1, 185.04, 0.0, 15.27, 200.31, 'USD', 'bank-transfer', 'Yarrowend'),
('ORD-10042', 10, '2025-02-17T17:12:00Z', 'shipped', 3, 181.22, 0.0, 14.95, 196.17, 'USD', 'card', 'Yarrowend'),
('ORD-10043', 33, '2025-02-19T15:37:00Z', 'pending', 2, 499.11, 0.0, 41.18, 540.29, 'USD', 'wallet', 'Westhollow'),
('ORD-10044', 119, '2025-02-21T19:30:00Z', 'paid', 2, 309.37, 0.0, 25.52, 334.89, 'USD', 'card', 'Alderport'),
('ORD-10045', 101, '2025-02-22T11:42:00Z', 'delivered', 5, 323.78, 0.0, 26.71, 350.49, 'USD', 'wallet', 'Ironvale'),
('ORD-10046', 111, '2025-02-24T11:21:00Z', 'shipped', 5, 656.34, 0.0, 54.15, 710.49, 'USD', 'card', 'Cinderhollow'),
('ORD-10047', 106, '2025-02-26T03:28:00Z', 'paid', 5, 689.69, 0.0, 56.9, 746.59, 'USD', 'bank-transfer', 'Vellmont'),
('ORD-10048', 18, '2025-02-26T06:46:00Z', 'cancelled', 1, 25.79, 4.99, 2.13, 32.91, 'USD', 'card', 'Glenhaven'),
('ORD-10049', 93, '2025-02-26T19:41:00Z', 'shipped', 1, 185.73, 0.0, 15.32, 201.05, 'USD', 'card', 'Stonebay'),
('ORD-10050', 18, '2025-03-02T07:04:00Z', 'delivered', 1, 13.24, 9.99, 1.09, 24.32, 'USD', 'card', 'Glenhaven');
INSERT INTO orders (order_id, user_id, ordered_at, status, items, subtotal, shipping, tax, total, currency, payment_method, shipping_city) VALUES
('ORD-10051', 47, '2025-03-03T22:33:00Z', 'delivered', 1, 19.16, 4.99, 1.58, 25.73, 'USD', 'bank-transfer', 'Yarrowend'),
('ORD-10052', 110, '2025-03-04T21:57:00Z', 'paid', 2, 18.39, 6.99, 1.52, 26.9, 'USD', 'bank-transfer', 'Northmere'),
('ORD-10053', 116, '2025-03-07T15:33:00Z', 'delivered', 2, 158.75, 0.0, 13.1, 171.85, 'USD', 'card', 'Marrowfen'),
('ORD-10054', 13, '2025-03-08T18:44:00Z', 'shipped', 1, 185.55, 0.0, 15.31, 200.86, 'USD', 'card', 'Stonebay'),
('ORD-10055', 12, '2025-03-08T23:42:00Z', 'paid', 2, 91.98, 0.0, 7.59, 99.57, 'USD', 'card', 'Brightwater'),
('ORD-10056', 48, '2025-03-10T14:26:00Z', 'paid', 1, 5.24, 4.99, 0.43, 10.66, 'USD', 'gift-card', 'Ravensford'),
('ORD-10057', 86, '2025-03-11T07:46:00Z', 'delivered', 5, 385.72, 0.0, 31.82, 417.54, 'USD', 'card', 'Kelbridge'),
('ORD-10058', 61, '2025-03-12T13:24:00Z', 'delivered', 5, 419.91, 0.0, 34.64, 454.55, 'USD', 'card', 'Oakenshade'),
('ORD-10059', 10, '2025-03-13T03:29:00Z', 'paid', 1, 12.79, 9.99, 1.06, 23.84, 'USD', 'card', 'Yarrowend'),
('ORD-10060', 37, '2025-03-14T11:07:00Z', 'refunded', 3, 319.76, 0.0, 26.38, 346.14, 'USD', 'wallet', 'Dunmarrow'),
('ORD-10061', 8, '2025-03-14T14:19:00Z', 'delivered', 1, 99.17, 0.0, 8.18, 107.35, 'USD', 'card', 'Juniper Rest'),
('ORD-10062', 116, '2025-03-14T20:23:00Z', 'pending', 2, 124.86, 0.0, 10.3, 135.16, 'USD', 'card', 'Marrowfen'),
('ORD-10063', 59, '2025-03-15T11:27:00Z', 'delivered', 6, 346.85, 0.0, 28.62, 375.47, 'USD', 'wallet', 'Juniper Rest'),
('ORD-10064', 35, '2025-03-17T19:15:00Z', 'paid', 3, 360.1, 0.0, 29.71, 389.81, 'USD', 'card', 'Quillmoor'),
('ORD-10065', 117, '2025-03-18T21:38:00Z', 'pending', 1, 9.29, 4.99, 0.77, 15.05, 'USD', 'card', 'Eastvale'),
('ORD-10066', 107, '2025-03-19T15:43:00Z', 'refunded', 2, 198.22, 0.0, 16.35, 214.57, 'USD', 'card', 'Northmere'),
('ORD-10067', 1, '2025-03-19T22:46:00Z', 'delivered', 6, 268.47, 0.0, 22.15, 290.62, 'USD', 'gift-card', 'Harrowgate'),
('ORD-10068', 7, '2025-03-20T18:25:00Z', 'paid', 3, 84.96, 0.0, 7.01, 91.97, 'USD', 'card', 'Ravensford'),
('ORD-10069', 99, '2025-03-21T17:48:00Z', 'paid', 1, 249.85, 0.0, 20.61, 270.46, 'USD', 'card', 'Ironvale'),
('ORD-10070', 95, '2025-03-22T05:34:00Z', 'refunded', 3, 558.54, 0.0, 46.08, 604.62, 'USD', 'bank-transfer', 'Kelbridge'),
('ORD-10071', 1, '2025-03-23T02:58:00Z', 'delivered', 1, 9.52, 6.99, 0.79, 17.3, 'USD', 'card', 'Harrowgate'),
('ORD-10072', 30, '2025-03-23T05:43:00Z', 'shipped', 4, 228.61, 0.0, 18.86, 247.47, 'USD', 'invoice', 'Eastvale'),
('ORD-10073', 117, '2025-03-24T09:13:00Z', 'delivered', 3, 144.81, 0.0, 11.95, 156.76, 'USD', 'card', 'Eastvale'),
('ORD-10074', 30, '2025-03-24T21:03:00Z', 'paid', 2, 65.16, 6.99, 5.38, 77.53, 'USD', 'bank-transfer', 'Eastvale'),
('ORD-10075', 37, '2025-03-25T05:55:00Z', 'delivered', 2, 42.41, 4.99, 3.5, 50.9, 'USD', 'wallet', 'Dunmarrow'),
('ORD-10076', 52, '2025-03-25T12:21:00Z', 'shipped', 3, 328.33, 0.0, 27.09, 355.42, 'USD', 'card', 'Eastvale'),
('ORD-10077', 21, '2025-03-30T00:01:00Z', 'delivered', 3, 271.48, 0.0, 22.4, 293.88, 'USD', 'bank-transfer', 'Ironvale'),
('ORD-10078', 1, '2025-03-30T20:07:00Z', 'paid', 1, 32.04, 9.99, 2.64, 44.67, 'USD', 'bank-transfer', 'Harrowgate'),
('ORD-10079', 73, '2025-04-03T19:32:00Z', 'paid', 7, 718.72, 0.0, 59.29, 778.01, 'USD', 'card', 'Quillmoor'),
('ORD-10080', 28, '2025-04-05T01:53:00Z', 'delivered', 1, 129.85, 0.0, 10.71, 140.56, 'USD', 'card', 'Dunmarrow'),
('ORD-10081', 79, '2025-04-05T12:02:00Z', 'paid', 1, 74.99, 4.99, 6.19, 86.17, 'USD', 'card', 'Yarrowend'),
('ORD-10082', 102, '2025-04-05T13:59:00Z', 'delivered', 1, 13.46, 9.99, 1.11, 24.56, 'USD', 'card', 'Westhollow'),
('ORD-10083', 97, '2025-04-05T21:48:00Z', 'shipped', 3, 302.0, 0.0, 24.92, 326.92, 'USD', 'bank-transfer', 'Alderport'),
('ORD-10084', 63, '2025-04-08T13:22:00Z', 'pending', 1, 46.4, 6.99, 3.83, 57.22, 'USD', 'wallet', 'Kelbridge'),
('ORD-10085', 63, '2025-04-08T14:55:00Z', 'pending', 3, 67.89, 9.99, 5.6, 83.48, 'USD', 'bank-transfer', 'Kelbridge'),
('ORD-10086', 53, '2025-04-12T01:20:00Z', 'paid', 7, 757.41, 0.0, 62.49, 819.9, 'USD', 'card', 'Brightwater'),
('ORD-10087', 39, '2025-04-13T10:28:00Z', 'paid', 2, 37.95, 9.99, 3.13, 51.07, 'USD', 'card', 'Larkfield'),
('ORD-10088', 73, '2025-04-13T11:53:00Z', 'pending', 5, 97.04, 0.0, 8.01, 105.05, 'USD', 'card', 'Quillmoor'),
('ORD-10089', 30, '2025-04-14T09:38:00Z', 'delivered', 5, 242.37, 0.0, 20.0, 262.37, 'USD', 'card', 'Eastvale'),
('ORD-10090', 113, '2025-04-14T21:20:00Z', 'shipped', 2, 55.72, 6.99, 4.6, 67.31, 'USD', 'card', 'Alderport'),
('ORD-10091', 14, '2025-04-15T15:56:00Z', 'shipped', 1, 75.34, 0.0, 6.22, 81.56, 'USD', 'card', 'Fernbrook'),
('ORD-10092', 116, '2025-04-17T06:35:00Z', 'shipped', 5, 280.17, 0.0, 23.11, 303.28, 'USD', 'card', 'Marrowfen'),
('ORD-10093', 30, '2025-04-22T00:02:00Z', 'shipped', 4, 188.04, 0.0, 15.51, 203.55, 'USD', 'bank-transfer', 'Eastvale'),
('ORD-10094', 116, '2025-04-22T03:26:00Z', 'delivered', 6, 211.98, 0.0, 17.49, 229.47, 'USD', 'invoice', 'Marrowfen'),
('ORD-10095', 64, '2025-04-23T22:32:00Z', 'delivered', 7, 461.66, 0.0, 38.09, 499.75, 'USD', 'card', 'Dunmarrow'),
('ORD-10096', 42, '2025-04-25T04:06:00Z', 'delivered', 1, 25.77, 6.99, 2.13, 34.89, 'USD', 'bank-transfer', 'Dunmarrow'),
('ORD-10097', 108, '2025-04-26T00:00:00Z', 'delivered', 5, 322.28, 0.0, 26.59, 348.87, 'USD', 'wallet', 'Westhollow'),
('ORD-10098', 119, '2025-04-26T11:11:00Z', 'delivered', 1, 185.5, 0.0, 15.3, 200.8, 'USD', 'card', 'Alderport'),
('ORD-10099', 67, '2025-04-26T14:30:00Z', 'delivered', 1, 129.0, 0.0, 10.64, 139.64, 'USD', 'card', 'Alderport'),
('ORD-10100', 96, '2025-04-27T15:12:00Z', 'pending', 1, 249.01, 0.0, 20.54, 269.55, 'USD', 'bank-transfer', 'Larkfield');
INSERT INTO orders (order_id, user_id, ordered_at, status, items, subtotal, shipping, tax, total, currency, payment_method, shipping_city) VALUES
('ORD-10101', 114, '2025-04-27T19:19:00Z', 'refunded', 3, 114.71, 0.0, 9.46, 124.17, 'USD', 'invoice', 'Ravensford'),
('ORD-10102', 73, '2025-04-28T03:36:00Z', 'delivered', 2, 85.81, 0.0, 7.08, 92.89, 'USD', 'card', 'Quillmoor'),
('ORD-10103', 116, '2025-04-28T15:11:00Z', 'delivered', 3, 333.54, 0.0, 27.52, 361.06, 'USD', 'card', 'Marrowfen'),
('ORD-10104', 40, '2025-04-28T15:43:00Z', 'delivered', 1, 59.18, 4.99, 4.88, 69.05, 'USD', 'gift-card', 'Eastvale'),
('ORD-10105', 111, '2025-04-29T02:34:00Z', 'shipped', 3, 261.24, 0.0, 21.55, 282.79, 'USD', 'card', 'Cinderhollow'),
('ORD-10106', 73, '2025-05-02T13:14:00Z', 'delivered', 2, 498.59, 0.0, 41.13, 539.72, 'USD', 'bank-transfer', 'Quillmoor'),
('ORD-10107', 27, '2025-05-05T04:48:00Z', 'delivered', 2, 161.82, 0.0, 13.35, 175.17, 'USD', 'card', 'Harrowgate'),
('ORD-10108', 100, '2025-05-05T06:15:00Z', 'paid', 8, 695.52, 0.0, 57.38, 752.9, 'USD', 'card', 'Ravensford'),
('ORD-10109', 11, '2025-05-05T18:01:00Z', 'refunded', 4, 298.49, 0.0, 24.63, 323.12, 'USD', 'card', 'Alderport'),
('ORD-10110', 111, '2025-05-05T21:12:00Z', 'delivered', 1, 185.03, 0.0, 15.26, 200.29, 'USD', 'card', 'Cinderhollow'),
('ORD-10111', 40, '2025-05-06T00:19:00Z', 'delivered', 1, 75.09, 0.0, 6.19, 81.28, 'USD', 'card', 'Eastvale'),
('ORD-10112', 107, '2025-05-06T02:34:00Z', 'delivered', 1, 5.61, 6.99, 0.46, 13.06, 'USD', 'card', 'Northmere'),
('ORD-10113', 31, '2025-05-06T23:07:00Z', 'delivered', 2, 134.82, 0.0, 11.12, 145.94, 'USD', 'card', 'Oakenshade'),
('ORD-10114', 91, '2025-05-08T18:11:00Z', 'pending', 5, 194.08, 0.0, 16.01, 210.09, 'USD', 'bank-transfer', 'Westhollow'),
('ORD-10115', 90, '2025-05-09T08:17:00Z', 'shipped', 2, 282.73, 0.0, 23.33, 306.06, 'USD', 'card', 'Yarrowend'),
('ORD-10116', 93, '2025-05-10T00:38:00Z', 'paid', 1, 99.03, 0.0, 8.17, 107.2, 'USD', 'card', 'Stonebay'),
('ORD-10117', 42, '2025-05-10T15:24:00Z', 'delivered', 2, 65.06, 9.99, 5.37, 80.42, 'USD', 'card', 'Dunmarrow'),
('ORD-10118', 95, '2025-05-11T02:27:00Z', 'paid', 1, 249.85, 0.0, 20.61, 270.46, 'USD', 'wallet', 'Kelbridge'),
('ORD-10119', 77, '2025-05-12T19:09:00Z', 'shipped', 2, 176.29, 0.0, 14.54, 190.83, 'USD', 'card', 'Harrowgate'),
('ORD-10120', 16, '2025-05-13T11:39:00Z', 'delivered', 1, 129.8, 0.0, 10.71, 140.51, 'USD', 'card', 'Yarrowend'),
('ORD-10121', 67, '2025-05-14T21:51:00Z', 'shipped', 7, 350.6, 0.0, 28.92, 379.52, 'USD', 'card', 'Alderport'),
('ORD-10122', 38, '2025-05-17T02:53:00Z', 'delivered', 3, 340.11, 0.0, 28.06, 368.17, 'USD', 'card', 'Westhollow'),
('ORD-10123', 75, '2025-05-17T03:24:00Z', 'delivered', 3, 309.62, 0.0, 25.54, 335.16, 'USD', 'bank-transfer', 'Fernbrook'),
('ORD-10124', 47, '2025-05-17T21:48:00Z', 'pending', 2, 11.33, 9.99, 0.93, 22.25, 'USD', 'card', 'Yarrowend'),
('ORD-10125', 94, '2025-05-18T01:59:00Z', 'delivered', 2, 88.05, 0.0, 7.26, 95.31, 'USD', 'card', 'Vellmont'),
('ORD-10126', 110, '2025-05-18T14:18:00Z', 'paid', 3, 236.82, 0.0, 19.54, 256.36, 'USD', 'card', 'Northmere'),
('ORD-10127', 43, '2025-05-21T05:41:00Z', 'delivered', 2, 142.34, 0.0, 11.74, 154.08, 'USD', 'wallet', 'Northmere'),
('ORD-10128', 73, '2025-05-22T01:47:00Z', 'shipped', 6, 386.14, 0.0, 31.86, 418.0, 'USD', 'bank-transfer', 'Quillmoor'),
('ORD-10129', 51, '2025-05-24T08:09:00Z', 'paid', 3, 289.26, 0.0, 23.86, 313.12, 'USD', 'card', 'Northmere'),
('ORD-10130', 1, '2025-05-26T15:08:00Z', 'pending', 2, 217.87, 0.0, 17.97, 235.84, 'USD', 'bank-transfer', 'Harrowgate'),
('ORD-10131', 14, '2025-05-27T10:05:00Z', 'delivered', 5, 251.7, 0.0, 20.77, 272.47, 'USD', 'card', 'Fernbrook'),
('ORD-10132', 67, '2025-05-27T15:15:00Z', 'delivered', 5, 359.51, 0.0, 29.66, 389.17, 'USD', 'wallet', 'Alderport'),
('ORD-10133', 29, '2025-05-28T01:16:00Z', 'pending', 4, 382.26, 0.0, 31.54, 413.8, 'USD', 'card', 'Eastvale'),
('ORD-10134', 82, '2025-05-29T00:22:00Z', 'delivered', 6, 376.01, 0.0, 31.02, 407.03, 'USD', 'gift-card', 'Brightwater'),
('ORD-10135', 64, '2025-05-29T09:18:00Z', 'delivered', 3, 154.56, 0.0, 12.75, 167.31, 'USD', 'card', 'Dunmarrow'),
('ORD-10136', 81, '2025-05-29T18:27:00Z', 'delivered', 8, 854.39, 0.0, 70.49, 924.88, 'USD', 'card', 'Marrowfen'),
('ORD-10137', 46, '2025-05-30T05:32:00Z', 'delivered', 5, 328.65, 0.0, 27.11, 355.76, 'USD', 'card', 'Glenhaven'),
('ORD-10138', 11, '2025-05-31T08:53:00Z', 'shipped', 5, 334.02, 0.0, 27.56, 361.58, 'USD', 'card', 'Alderport'),
('ORD-10139', 60, '2025-06-01T22:31:00Z', 'delivered', 7, 503.49, 0.0, 41.54, 545.03, 'USD', 'card', 'Marrowfen'),
('ORD-10140', 19, '2025-06-02T06:36:00Z', 'shipped', 2, 199.0, 0.0, 16.42, 215.42, 'USD', 'card', 'Ravensford'),
('ORD-10141', 48, '2025-06-03T13:51:00Z', 'shipped', 3, 317.8, 0.0, 26.22, 344.02, 'USD', 'card', 'Ravensford'),
('ORD-10142', 101, '2025-06-03T15:46:00Z', 'refunded', 5, 477.15, 0.0, 39.36, 516.51, 'USD', 'bank-transfer', 'Ironvale'),
('ORD-10143', 83, '2025-06-03T19:38:00Z', 'shipped', 2, 79.33, 0.0, 6.54, 85.87, 'USD', 'card', 'Ironvale'),
('ORD-10144', 116, '2025-06-03T20:57:00Z', 'delivered', 2, 55.83, 9.99, 4.61, 70.43, 'USD', 'gift-card', 'Marrowfen'),
('ORD-10145', 8, '2025-06-06T18:44:00Z', 'cancelled', 1, 12.82, 6.99, 1.06, 20.87, 'USD', 'card', 'Juniper Rest'),
('ORD-10146', 89, '2025-06-09T01:41:00Z', 'delivered', 2, 269.11, 0.0, 22.2, 291.31, 'USD', 'card', 'Marrowfen'),
('ORD-10147', 70, '2025-06-10T02:50:00Z', 'refunded', 4, 290.49, 0.0, 23.97, 314.46, 'USD', 'gift-card', 'Vellmont'),
('ORD-10148', 120, '2025-06-11T09:25:00Z', 'delivered', 1, 9.37, 9.99, 0.77, 20.13, 'USD', 'bank-transfer', 'Eastvale'),
('ORD-10149', 26, '2025-06-12T02:15:00Z', 'shipped', 3, 214.22, 0.0, 17.67, 231.89, 'USD', 'wallet', 'Thistledown'),
('ORD-10150', 42, '2025-06-15T15:58:00Z', 'cancelled', 2, 285.28, 0.0, 23.54, 308.82, 'USD', 'card', 'Dunmarrow');
INSERT INTO orders (order_id, user_id, ordered_at, status, items, subtotal, shipping, tax, total, currency, payment_method, shipping_city) VALUES
('ORD-10151', 41, '2025-06-16T02:40:00Z', 'pending', 2, 138.56, 0.0, 11.43, 149.99, 'USD', 'bank-transfer', 'Larkfield'),
('ORD-10152', 84, '2025-06-16T15:48:00Z', 'shipped', 1, 185.51, 0.0, 15.3, 200.81, 'USD', 'wallet', 'Dunmarrow'),
('ORD-10153', 63, '2025-06-16T16:35:00Z', 'delivered', 2, 24.33, 9.99, 2.01, 36.33, 'USD', 'invoice', 'Kelbridge'),
('ORD-10154', 43, '2025-06-18T21:12:00Z', 'delivered', 1, 249.33, 0.0, 20.57, 269.9, 'USD', 'gift-card', 'Northmere'),
('ORD-10155', 120, '2025-06-20T14:36:00Z', 'delivered', 5, 201.41, 0.0, 16.62, 218.03, 'USD', 'bank-transfer', 'Eastvale'),
('ORD-10156', 52, '2025-06-22T17:18:00Z', 'delivered', 2, 33.36, 4.99, 2.75, 41.1, 'USD', 'gift-card', 'Eastvale'),
('ORD-10157', 54, '2025-06-22T17:47:00Z', 'shipped', 2, 142.13, 0.0, 11.73, 153.86, 'USD', 'card', 'Larkfield'),
('ORD-10158', 77, '2025-06-26T01:33:00Z', 'refunded', 5, 417.36, 0.0, 34.43, 451.79, 'USD', 'invoice', 'Harrowgate'),
('ORD-10159', 10, '2025-06-28T15:57:00Z', 'delivered', 1, 12.66, 6.99, 1.04, 20.69, 'USD', 'wallet', 'Yarrowend'),
('ORD-10160', 3, '2025-06-29T12:28:00Z', 'pending', 4, 264.69, 0.0, 21.84, 286.53, 'USD', 'card', 'Alderport'),
('ORD-10161', 111, '2025-07-01T04:14:00Z', 'delivered', 2, 324.7, 0.0, 26.79, 351.49, 'USD', 'card', 'Cinderhollow'),
('ORD-10162', 94, '2025-07-01T20:25:00Z', 'shipped', 2, 55.55, 9.99, 4.58, 70.12, 'USD', 'card', 'Vellmont'),
('ORD-10163', 18, '2025-07-02T04:20:00Z', 'pending', 5, 222.82, 0.0, 18.38, 241.2, 'USD', 'invoice', 'Glenhaven'),
('ORD-10164', 56, '2025-07-03T01:24:00Z', 'shipped', 2, 84.54, 0.0, 6.97, 91.51, 'USD', 'wallet', 'Dunmarrow'),
('ORD-10165', 38, '2025-07-03T15:59:00Z', 'shipped', 4, 568.45, 0.0, 46.9, 615.35, 'USD', 'card', 'Westhollow'),
('ORD-10166', 42, '2025-07-04T05:24:00Z', 'delivered', 6, 196.44, 0.0, 16.21, 212.65, 'USD', 'card', 'Dunmarrow'),
('ORD-10167', 46, '2025-07-05T08:30:00Z', 'shipped', 8, 443.62, 0.0, 36.6, 480.22, 'USD', 'wallet', 'Glenhaven'),
('ORD-10168', 55, '2025-07-05T08:31:00Z', 'pending', 1, 32.14, 9.99, 2.65, 44.78, 'USD', 'card', 'Ravensford'),
('ORD-10169', 56, '2025-07-09T06:13:00Z', 'refunded', 3, 234.9, 0.0, 19.38, 254.28, 'USD', 'card', 'Dunmarrow'),
('ORD-10170', 7, '2025-07-10T23:11:00Z', 'delivered', 4, 379.47, 0.0, 31.31, 410.78, 'USD', 'bank-transfer', 'Ravensford'),
('ORD-10171', 97, '2025-07-14T07:43:00Z', 'delivered', 1, 25.0, 4.99, 2.06, 32.05, 'USD', 'bank-transfer', 'Alderport'),
('ORD-10172', 53, '2025-07-14T15:23:00Z', 'delivered', 6, 647.32, 0.0, 53.4, 700.72, 'USD', 'card', 'Brightwater'),
('ORD-10173', 44, '2025-07-15T11:53:00Z', 'pending', 3, 36.09, 4.99, 2.98, 44.06, 'USD', 'card', 'Stonebay'),
('ORD-10174', 20, '2025-07-16T07:50:00Z', 'cancelled', 4, 255.28, 0.0, 21.06, 276.34, 'USD', 'card', 'Ravensford'),
('ORD-10175', 67, '2025-07-17T21:48:00Z', 'pending', 2, 91.85, 0.0, 7.58, 99.43, 'USD', 'card', 'Alderport'),
('ORD-10176', 21, '2025-07-19T04:26:00Z', 'shipped', 1, 99.92, 0.0, 8.24, 108.16, 'USD', 'card', 'Ironvale'),
('ORD-10177', 118, '2025-07-19T12:27:00Z', 'delivered', 4, 611.79, 0.0, 50.47, 662.26, 'USD', 'wallet', 'Northmere'),
('ORD-10178', 45, '2025-07-19T17:42:00Z', 'delivered', 1, 25.77, 9.99, 2.13, 37.89, 'USD', 'card', 'Cinderhollow'),
('ORD-10179', 80, '2025-07-21T07:53:00Z', 'shipped', 5, 336.2, 0.0, 27.74, 363.94, 'USD', 'card', 'Quillmoor'),
('ORD-10180', 99, '2025-07-23T10:31:00Z', 'shipped', 1, 32.4, 4.99, 2.67, 40.06, 'USD', 'card', 'Ironvale'),
('ORD-10181', 77, '2025-07-24T09:55:00Z', 'delivered', 1, 185.77, 0.0, 15.33, 201.1, 'USD', 'gift-card', 'Harrowgate'),
('ORD-10182', 86, '2025-07-26T02:56:00Z', 'delivered', 4, 395.76, 0.0, 32.65, 428.41, 'USD', 'wallet', 'Kelbridge'),
('ORD-10183', 70, '2025-07-26T23:10:00Z', 'delivered', 3, 164.44, 0.0, 13.57, 178.01, 'USD', 'card', 'Vellmont'),
('ORD-10184', 62, '2025-07-29T07:32:00Z', 'shipped', 2, 118.56, 0.0, 9.78, 128.34, 'USD', 'wallet', 'Kelbridge'),
('ORD-10185', 112, '2025-07-29T23:34:00Z', 'pending', 5, 237.56, 0.0, 19.6, 257.16, 'USD', 'wallet', 'Vellmont'),
('ORD-10186', 81, '2025-07-31T19:42:00Z', 'delivered', 4, 195.33, 0.0, 16.11, 211.44, 'USD', 'card', 'Marrowfen'),
('ORD-10187', 105, '2025-08-01T04:29:00Z', 'pending', 2, 211.08, 0.0, 17.41, 228.49, 'USD', 'bank-transfer', 'Ironvale'),
('ORD-10188', 61, '2025-08-01T22:02:00Z', 'cancelled', 2, 100.03, 0.0, 8.25, 108.28, 'USD', 'wallet', 'Oakenshade'),
('ORD-10189', 106, '2025-08-02T05:51:00Z', 'delivered', 8, 413.08, 0.0, 34.08, 447.16, 'USD', 'card', 'Vellmont'),
('ORD-10190', 36, '2025-08-02T08:14:00Z', 'delivered', 4, 483.81, 0.0, 39.91, 523.72, 'USD', 'bank-transfer', 'Northmere'),
('ORD-10191', 14, '2025-08-05T21:15:00Z', 'pending', 2, 258.56, 0.0, 21.33, 279.89, 'USD', 'gift-card', 'Fernbrook'),
('ORD-10192', 28, '2025-08-06T17:04:00Z', 'delivered', 3, 171.76, 0.0, 14.17, 185.93, 'USD', 'card', 'Dunmarrow'),
('ORD-10193', 110, '2025-08-06T20:46:00Z', 'delivered', 4, 152.13, 0.0, 12.55, 164.68, 'USD', 'card', 'Northmere'),
('ORD-10194', 72, '2025-08-08T12:56:00Z', 'paid', 2, 55.33, 9.99, 4.56, 69.88, 'USD', 'invoice', 'Stonebay'),
('ORD-10195', 23, '2025-08-08T14:37:00Z', 'shipped', 2, 205.15, 0.0, 16.92, 222.07, 'USD', 'invoice', 'Marrowfen'),
('ORD-10196', 100, '2025-08-11T23:32:00Z', 'delivered', 1, 9.5, 6.99, 0.78, 17.27, 'USD', 'bank-transfer', 'Ravensford'),
('ORD-10197', 77, '2025-08-14T07:52:00Z', 'delivered', 3, 320.3, 0.0, 26.42, 346.72, 'USD', 'card', 'Harrowgate'),
('ORD-10198', 115, '2025-08-15T21:59:00Z', 'delivered', 2, 139.31, 0.0, 11.49, 150.8, 'USD', 'card', 'Alderport'),
('ORD-10199', 44, '2025-08-16T10:47:00Z', 'pending', 5, 763.32, 0.0, 62.97, 826.29, 'USD', 'card', 'Stonebay'),
('ORD-10200', 56, '2025-08-17T02:15:00Z', 'shipped', 7, 186.5, 0.0, 15.39, 201.89, 'USD', 'card', 'Dunmarrow');
INSERT INTO orders (order_id, user_id, ordered_at, status, items, subtotal, shipping, tax, total, currency, payment_method, shipping_city) VALUES
('ORD-10201', 42, '2025-08-17T13:01:00Z', 'cancelled', 1, 9.59, 9.99, 0.79, 20.37, 'USD', 'wallet', 'Dunmarrow'),
('ORD-10202', 39, '2025-08-17T13:28:00Z', 'paid', 2, 108.43, 0.0, 8.95, 117.38, 'USD', 'card', 'Larkfield'),
('ORD-10203', 69, '2025-08-21T04:28:00Z', 'delivered', 3, 278.18, 0.0, 22.95, 301.13, 'USD', 'card', 'Alderport'),
('ORD-10204', 98, '2025-08-21T18:18:00Z', 'cancelled', 1, 99.39, 0.0, 8.2, 107.59, 'USD', 'card', 'Oakenshade'),
('ORD-10205', 74, '2025-08-22T01:41:00Z', 'delivered', 2, 121.95, 0.0, 10.06, 132.01, 'USD', 'card', 'Juniper Rest'),
('ORD-10206', 116, '2025-08-24T18:15:00Z', 'delivered', 2, 35.4, 4.99, 2.92, 43.31, 'USD', 'wallet', 'Marrowfen'),
('ORD-10207', 47, '2025-08-24T19:08:00Z', 'shipped', 2, 158.29, 0.0, 13.06, 171.35, 'USD', 'wallet', 'Yarrowend'),
('ORD-10208', 67, '2025-08-27T06:16:00Z', 'shipped', 7, 700.17, 0.0, 57.76, 757.93, 'USD', 'invoice', 'Alderport'),
('ORD-10209', 99, '2025-08-27T16:28:00Z', 'delivered', 6, 268.03, 0.0, 22.11, 290.14, 'USD', 'card', 'Ironvale'),
('ORD-10210', 105, '2025-08-29T17:55:00Z', 'delivered', 6, 365.11, 0.0, 30.12, 395.23, 'USD', 'card', 'Ironvale'),
('ORD-10211', 92, '2025-08-29T21:40:00Z', 'pending', 4, 124.65, 0.0, 10.28, 134.93, 'USD', 'card', 'Yarrowend'),
('ORD-10212', 106, '2025-08-30T03:24:00Z', 'cancelled', 3, 168.06, 0.0, 13.86, 181.92, 'USD', 'card', 'Vellmont'),
('ORD-10213', 101, '2025-09-01T11:01:00Z', 'cancelled', 1, 5.11, 4.99, 0.42, 10.52, 'USD', 'card', 'Ironvale'),
('ORD-10214', 39, '2025-09-01T14:56:00Z', 'refunded', 5, 512.74, 0.0, 42.3, 555.04, 'USD', 'invoice', 'Larkfield'),
('ORD-10215', 107, '2025-09-03T14:29:00Z', 'delivered', 6, 413.54, 0.0, 34.12, 447.66, 'USD', 'card', 'Northmere'),
('ORD-10216', 84, '2025-09-04T00:46:00Z', 'delivered', 1, 99.77, 0.0, 8.23, 108.0, 'USD', 'card', 'Dunmarrow'),
('ORD-10217', 40, '2025-09-04T09:52:00Z', 'refunded', 3, 263.62, 0.0, 21.75, 285.37, 'USD', 'bank-transfer', 'Eastvale'),
('ORD-10218', 58, '2025-09-07T02:07:00Z', 'paid', 2, 217.56, 0.0, 17.95, 235.51, 'USD', 'card', 'Dunmarrow'),
('ORD-10219', 58, '2025-09-07T06:54:00Z', 'pending', 3, 146.56, 0.0, 12.09, 158.65, 'USD', 'card', 'Dunmarrow'),
('ORD-10220', 53, '2025-09-15T08:22:00Z', 'delivered', 6, 541.94, 0.0, 44.71, 586.65, 'USD', 'card', 'Brightwater'),
('ORD-10221', 105, '2025-09-15T19:40:00Z', 'shipped', 1, 9.1, 6.99, 0.75, 16.84, 'USD', 'card', 'Ironvale'),
('ORD-10222', 8, '2025-09-16T03:45:00Z', 'shipped', 5, 237.27, 0.0, 19.57, 256.84, 'USD', 'wallet', 'Juniper Rest'),
('ORD-10223', 43, '2025-09-16T16:11:00Z', 'shipped', 3, 444.53, 0.0, 36.67, 481.2, 'USD', 'card', 'Northmere'),
('ORD-10224', 95, '2025-09-17T08:38:00Z', 'delivered', 2, 56.65, 6.99, 4.67, 68.31, 'USD', 'card', 'Kelbridge'),
('ORD-10225', 110, '2025-09-18T11:37:00Z', 'cancelled', 1, 99.09, 0.0, 8.17, 107.26, 'USD', 'wallet', 'Northmere'),
('ORD-10226', 33, '2025-09-19T00:01:00Z', 'delivered', 4, 311.92, 0.0, 25.73, 337.65, 'USD', 'gift-card', 'Westhollow'),
('ORD-10227', 80, '2025-09-21T04:17:00Z', 'shipped', 3, 85.06, 0.0, 7.02, 92.08, 'USD', 'card', 'Quillmoor'),
('ORD-10228', 98, '2025-09-22T08:17:00Z', 'refunded', 4, 152.38, 0.0, 12.57, 164.95, 'USD', 'bank-transfer', 'Oakenshade'),
('ORD-10229', 46, '2025-09-22T22:27:00Z', 'delivered', 1, 25.59, 4.99, 2.11, 32.69, 'USD', 'card', 'Glenhaven'),
('ORD-10230', 3, '2025-09-24T22:58:00Z', 'shipped', 1, 185.52, 0.0, 15.31, 200.83, 'USD', 'wallet', 'Alderport'),
('ORD-10231', 112, '2025-09-24T23:23:00Z', 'delivered', 1, 19.42, 4.99, 1.6, 26.01, 'USD', 'bank-transfer', 'Vellmont'),
('ORD-10232', 40, '2025-09-24T23:54:00Z', 'delivered', 4, 297.77, 0.0, 24.57, 322.34, 'USD', 'card', 'Eastvale'),
('ORD-10233', 95, '2025-09-26T04:09:00Z', 'shipped', 4, 420.4, 0.0, 34.68, 455.08, 'USD', 'card', 'Kelbridge'),
('ORD-10234', 114, '2025-09-27T21:08:00Z', 'delivered', 2, 112.67, 0.0, 9.3, 121.97, 'USD', 'card', 'Ravensford'),
('ORD-10235', 73, '2025-09-28T17:03:00Z', 'cancelled', 1, 5.77, 6.99, 0.48, 13.24, 'USD', 'card', 'Quillmoor'),
('ORD-10236', 3, '2025-09-29T02:14:00Z', 'refunded', 3, 120.82, 0.0, 9.97, 130.79, 'USD', 'card', 'Alderport'),
('ORD-10237', 97, '2025-09-29T10:28:00Z', 'shipped', 1, 46.57, 4.99, 3.84, 55.4, 'USD', 'card', 'Alderport'),
('ORD-10238', 46, '2025-09-30T17:36:00Z', 'delivered', 5, 212.85, 0.0, 17.56, 230.41, 'USD', 'card', 'Glenhaven'),
('ORD-10239', 76, '2025-10-01T06:13:00Z', 'delivered', 5, 377.12, 0.0, 31.11, 408.23, 'USD', 'wallet', 'Dunmarrow'),
('ORD-10240', 9, '2025-10-01T15:28:00Z', 'paid', 2, 232.2, 0.0, 19.16, 251.36, 'USD', 'card', 'Oakenshade'),
('ORD-10241', 22, '2025-10-01T16:24:00Z', 'shipped', 3, 392.78, 0.0, 32.4, 425.18, 'USD', 'card', 'Stonebay'),
('ORD-10242', 14, '2025-10-03T07:10:00Z', 'delivered', 2, 88.22, 0.0, 7.28, 95.5, 'USD', 'gift-card', 'Fernbrook'),
('ORD-10243', 25, '2025-10-04T09:22:00Z', 'paid', 1, 12.99, 6.99, 1.07, 21.05, 'USD', 'wallet', 'Harrowgate'),
('ORD-10244', 83, '2025-10-04T19:36:00Z', 'delivered', 8, 559.56, 0.0, 46.16, 605.72, 'USD', 'card', 'Ironvale'),
('ORD-10245', 25, '2025-10-05T02:24:00Z', 'delivered', 3, 182.52, 0.0, 15.06, 197.58, 'USD', 'gift-card', 'Harrowgate'),
('ORD-10246', 101, '2025-10-06T05:48:00Z', 'delivered', 2, 211.22, 0.0, 17.43, 228.65, 'USD', 'wallet', 'Ironvale'),
('ORD-10247', 63, '2025-10-08T09:00:00Z', 'cancelled', 5, 466.0, 0.0, 38.44, 504.44, 'USD', 'card', 'Kelbridge'),
('ORD-10248', 50, '2025-10-09T01:38:00Z', 'delivered', 3, 467.78, 0.0, 38.59, 506.37, 'USD', 'bank-transfer', 'Glenhaven'),
('ORD-10249', 81, '2025-10-12T18:45:00Z', 'paid', 2, 58.06, 4.99, 4.79, 67.84, 'USD', 'card', 'Marrowfen'),
('ORD-10250', 7, '2025-10-14T22:19:00Z', 'paid', 4, 279.93, 0.0, 23.09, 303.02, 'USD', 'card', 'Ravensford');
INSERT INTO orders (order_id, user_id, ordered_at, status, items, subtotal, shipping, tax, total, currency, payment_method, shipping_city) VALUES
('ORD-10251', 81, '2025-10-16T11:29:00Z', 'pending', 2, 34.67, 6.99, 2.86, 44.52, 'USD', 'bank-transfer', 'Marrowfen'),
('ORD-10252', 52, '2025-10-17T05:30:00Z', 'paid', 4, 292.82, 0.0, 24.16, 316.98, 'USD', 'card', 'Eastvale'),
('ORD-10253', 73, '2025-10-17T23:32:00Z', 'refunded', 1, 99.99, 0.0, 8.25, 108.24, 'USD', 'wallet', 'Quillmoor'),
('ORD-10254', 32, '2025-10-21T02:46:00Z', 'delivered', 4, 402.27, 0.0, 33.19, 435.46, 'USD', 'card', 'Dunmarrow'),
('ORD-10255', 85, '2025-10-23T10:33:00Z', 'delivered', 1, 9.22, 6.99, 0.76, 16.97, 'USD', 'wallet', 'Alderport'),
('ORD-10256', 4, '2025-10-23T21:46:00Z', 'delivered', 2, 258.91, 0.0, 21.36, 280.27, 'USD', 'wallet', 'Umberfield'),
('ORD-10257', 91, '2025-10-26T16:56:00Z', 'delivered', 5, 398.36, 0.0, 32.86, 431.22, 'USD', 'gift-card', 'Westhollow'),
('ORD-10258', 2, '2025-10-28T16:49:00Z', 'shipped', 1, 185.05, 0.0, 15.27, 200.32, 'USD', 'card', 'Oakenshade'),
('ORD-10259', 3, '2025-10-29T03:07:00Z', 'paid', 2, 57.72, 6.99, 4.76, 69.47, 'USD', 'card', 'Alderport'),
('ORD-10260', 29, '2025-10-29T09:06:00Z', 'delivered', 8, 700.91, 0.0, 57.83, 758.74, 'USD', 'card', 'Eastvale'),
('ORD-10261', 17, '2025-10-29T18:26:00Z', 'delivered', 3, 154.68, 0.0, 12.76, 167.44, 'USD', 'card', 'Cinderhollow'),
('ORD-10262', 106, '2025-11-02T09:48:00Z', 'cancelled', 4, 223.74, 0.0, 18.46, 242.2, 'USD', 'gift-card', 'Vellmont'),
('ORD-10263', 44, '2025-11-02T20:17:00Z', 'paid', 4, 295.39, 0.0, 24.37, 319.76, 'USD', 'wallet', 'Stonebay'),
('ORD-10264', 43, '2025-11-02T21:04:00Z', 'cancelled', 2, 262.85, 0.0, 21.69, 284.54, 'USD', 'wallet', 'Northmere'),
('ORD-10265', 64, '2025-11-04T14:07:00Z', 'pending', 2, 195.69, 0.0, 16.14, 211.83, 'USD', 'invoice', 'Dunmarrow'),
('ORD-10266', 57, '2025-11-05T09:32:00Z', 'delivered', 1, 25.57, 9.99, 2.11, 37.67, 'USD', 'card', 'Pinecrest'),
('ORD-10267', 29, '2025-11-07T00:57:00Z', 'pending', 1, 249.72, 0.0, 20.6, 270.32, 'USD', 'card', 'Eastvale'),
('ORD-10268', 76, '2025-11-07T04:30:00Z', 'delivered', 1, 185.96, 0.0, 15.34, 201.3, 'USD', 'card', 'Dunmarrow'),
('ORD-10269', 71, '2025-11-08T02:20:00Z', 'delivered', 3, 278.32, 0.0, 22.96, 301.28, 'USD', 'card', 'Quillmoor'),
('ORD-10270', 84, '2025-11-12T13:20:00Z', 'delivered', 3, 61.59, 6.99, 5.08, 73.66, 'USD', 'card', 'Dunmarrow'),
('ORD-10271', 115, '2025-11-12T13:34:00Z', 'delivered', 1, 5.24, 9.99, 0.43, 15.66, 'USD', 'card', 'Alderport'),
('ORD-10272', 103, '2025-11-12T19:57:00Z', 'delivered', 3, 322.69, 0.0, 26.62, 349.31, 'USD', 'card', 'Umberfield'),
('ORD-10273', 67, '2025-11-13T15:24:00Z', 'paid', 2, 259.23, 0.0, 21.39, 280.62, 'USD', 'wallet', 'Alderport'),
('ORD-10274', 86, '2025-11-15T07:48:00Z', 'delivered', 5, 578.68, 0.0, 47.74, 626.42, 'USD', 'card', 'Kelbridge'),
('ORD-10275', 48, '2025-11-15T08:33:00Z', 'shipped', 2, 154.99, 0.0, 12.79, 167.78, 'USD', 'card', 'Ravensford'),
('ORD-10276', 53, '2025-11-15T15:20:00Z', 'delivered', 1, 46.02, 4.99, 3.8, 54.81, 'USD', 'card', 'Brightwater'),
('ORD-10277', 28, '2025-11-20T01:12:00Z', 'delivered', 2, 314.73, 0.0, 25.97, 340.7, 'USD', 'wallet', 'Dunmarrow'),
('ORD-10278', 49, '2025-11-20T08:29:00Z', 'delivered', 5, 449.01, 0.0, 37.04, 486.05, 'USD', 'card', 'Ravensford'),
('ORD-10279', 98, '2025-11-21T10:39:00Z', 'delivered', 2, 93.61, 0.0, 7.72, 101.33, 'USD', 'card', 'Oakenshade'),
('ORD-10280', 27, '2025-11-22T16:39:00Z', 'cancelled', 2, 68.34, 4.99, 5.64, 78.97, 'USD', 'gift-card', 'Harrowgate'),
('ORD-10281', 73, '2025-11-23T01:54:00Z', 'refunded', 7, 501.1, 0.0, 41.34, 542.44, 'USD', 'card', 'Quillmoor'),
('ORD-10282', 92, '2025-11-24T11:35:00Z', 'delivered', 1, 19.97, 6.99, 1.65, 28.61, 'USD', 'card', 'Yarrowend'),
('ORD-10283', 95, '2025-11-24T20:56:00Z', 'delivered', 1, 9.82, 4.99, 0.81, 15.62, 'USD', 'bank-transfer', 'Kelbridge'),
('ORD-10284', 90, '2025-11-25T18:15:00Z', 'delivered', 1, 9.43, 4.99, 0.78, 15.2, 'USD', 'card', 'Yarrowend'),
('ORD-10285', 74, '2025-11-28T10:15:00Z', 'paid', 4, 410.2, 0.0, 33.84, 444.04, 'USD', 'bank-transfer', 'Juniper Rest'),
('ORD-10286', 90, '2025-11-29T09:19:00Z', 'shipped', 2, 194.19, 0.0, 16.02, 210.21, 'USD', 'card', 'Yarrowend'),
('ORD-10287', 52, '2025-11-30T11:36:00Z', 'paid', 3, 333.98, 0.0, 27.55, 361.53, 'USD', 'gift-card', 'Eastvale'),
('ORD-10288', 65, '2025-12-01T14:50:00Z', 'pending', 1, 249.65, 0.0, 20.6, 270.25, 'USD', 'card', 'Vellmont'),
('ORD-10289', 74, '2025-12-06T09:03:00Z', 'delivered', 1, 25.18, 6.99, 2.08, 34.25, 'USD', 'card', 'Juniper Rest'),
('ORD-10290', 63, '2025-12-06T14:31:00Z', 'cancelled', 5, 371.5, 0.0, 30.65, 402.15, 'USD', 'card', 'Kelbridge'),
('ORD-10291', 114, '2025-12-08T06:11:00Z', 'delivered', 3, 154.93, 0.0, 12.78, 167.71, 'USD', 'wallet', 'Ravensford'),
('ORD-10292', 97, '2025-12-10T09:35:00Z', 'delivered', 4, 288.42, 0.0, 23.79, 312.21, 'USD', 'bank-transfer', 'Alderport'),
('ORD-10293', 116, '2025-12-10T16:26:00Z', 'cancelled', 2, 135.85, 0.0, 11.21, 147.06, 'USD', 'wallet', 'Marrowfen'),
('ORD-10294', 88, '2025-12-10T22:08:00Z', 'delivered', 1, 32.38, 9.99, 2.67, 45.04, 'USD', 'gift-card', 'Umberfield'),
('ORD-10295', 50, '2025-12-12T00:42:00Z', 'delivered', 3, 388.25, 0.0, 32.03, 420.28, 'USD', 'gift-card', 'Glenhaven'),
('ORD-10296', 28, '2025-12-12T04:16:00Z', 'delivered', 1, 12.74, 9.99, 1.05, 23.78, 'USD', 'gift-card', 'Dunmarrow'),
('ORD-10297', 22, '2025-12-12T17:54:00Z', 'delivered', 2, 150.47, 0.0, 12.41, 162.88, 'USD', 'bank-transfer', 'Stonebay'),
('ORD-10298', 39, '2025-12-14T12:18:00Z', 'delivered', 7, 491.78, 0.0, 40.57, 532.35, 'USD', 'wallet', 'Larkfield'),
('ORD-10299', 69, '2025-12-14T13:51:00Z', 'delivered', 1, 46.48, 4.99, 3.83, 55.3, 'USD', 'card', 'Alderport'),
('ORD-10300', 102, '2025-12-14T23:10:00Z', 'paid', 1, 25.06, 6.99, 2.07, 34.12, 'USD', 'gift-card', 'Westhollow');