-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathinsert_sales.sql
More file actions
200 lines (200 loc) · 48.9 KB
/
insert_sales.sql
File metadata and controls
200 lines (200 loc) · 48.9 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
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0001', 'C041', 'Laptop', 'Electronics', 1, 350, STR_TO_DATE('12-03-2025', '%d-%m-%Y'), 'March', 'South', 350, 175);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0002', 'C015', 'Smartphone', 'Electronics', 1, 350, STR_TO_DATE('09-07-2025', '%d-%m-%Y'), 'July', 'North', 350, 56);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0003', 'C038', 'Camera', 'Electronics', 1, 500, STR_TO_DATE('24-01-2025', '%d-%m-%Y'), 'January', 'South', 500, 222);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0004', 'C015', 'Smartwatch', 'Electronics', 5, 500, STR_TO_DATE('24-05-2025', '%d-%m-%Y'), 'May', 'South', 2500, 102);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0005', 'C046', 'Tablet', 'Electronics', 5, 400, STR_TO_DATE('26-02-2025', '%d-%m-%Y'), 'February', 'West', 2000, 189);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0006', 'C038', 'Headphones', 'Electronics', 1, 150, STR_TO_DATE('26-07-2025', '%d-%m-%Y'), 'July', 'South', 150, 39);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0007', 'C045', 'Camera', 'Electronics', 3, 300, STR_TO_DATE('09-02-2025', '%d-%m-%Y'), 'February', 'South', 900, 206);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0008', 'C049', 'Headphones', 'Electronics', 1, 500, STR_TO_DATE('08-04-2025', '%d-%m-%Y'), 'April', 'North', 500, 148);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0009', 'C023', 'Printer', 'Electronics', 3, 200, STR_TO_DATE('09-03-2025', '%d-%m-%Y'), 'March', 'North', 600, 178);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0010', 'C047', 'Camera', 'Electronics', 5, 500, STR_TO_DATE('07-04-2025', '%d-%m-%Y'), 'April', 'North', 2500, 149);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0011', 'C036', 'Headphones', 'Electronics', 5, 150, STR_TO_DATE('03-04-2025', '%d-%m-%Y'), 'April', 'South', 750, 153);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0012', 'C046', 'Laptop', 'Electronics', 1, 350, STR_TO_DATE('28-02-2025', '%d-%m-%Y'), 'February', 'East', 350, 187);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0013', 'C006', 'Printer', 'Electronics', 2, 150, STR_TO_DATE('26-01-2025', '%d-%m-%Y'), 'January', 'West', 300, 220);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0014', 'C018', 'Camera', 'Electronics', 3, 700, STR_TO_DATE('05-04-2025', '%d-%m-%Y'), 'April', 'East', 2100, 151);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0015', 'C014', 'Tablet', 'Electronics', 3, 350, STR_TO_DATE('24-06-2025', '%d-%m-%Y'), 'June', 'North', 1050, 71);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0016', 'C039', 'Tablet', 'Electronics', 2, 200, STR_TO_DATE('06-07-2025', '%d-%m-%Y'), 'July', 'South', 400, 59);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0017', 'C011', 'Camera', 'Electronics', 4, 300, STR_TO_DATE('13-06-2025', '%d-%m-%Y'), 'June', 'South', 1200, 82);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0018', 'C044', 'Headphones', 'Electronics', 1, 700, STR_TO_DATE('30-07-2025', '%d-%m-%Y'), 'July', 'North', 700, 35);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0019', 'C021', 'Camera', 'Electronics', 3, 500, STR_TO_DATE('24-02-2025', '%d-%m-%Y'), 'February', 'East', 1500, 191);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0020', 'C014', 'Tablet', 'Electronics', 4, 400, STR_TO_DATE('14-06-2025', '%d-%m-%Y'), 'June', 'West', 1600, 81);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0021', 'C010', 'Headphones', 'Electronics', 2, 700, STR_TO_DATE('10-07-2025', '%d-%m-%Y'), 'July', 'East', 1400, 55);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0022', 'C048', 'Smartwatch', 'Electronics', 4, 200, STR_TO_DATE('13-04-2025', '%d-%m-%Y'), 'April', 'East', 800, 143);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0023', 'C015', 'Smartphone', 'Electronics', 5, 400, STR_TO_DATE('24-01-2025', '%d-%m-%Y'), 'January', 'North', 2000, 222);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0024', 'C008', 'Smartphone', 'Electronics', 2, 150, STR_TO_DATE('24-06-2025', '%d-%m-%Y'), 'June', 'West', 300, 71);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0025', 'C039', 'Laptop', 'Electronics', 4, 400, STR_TO_DATE('02-06-2025', '%d-%m-%Y'), 'June', 'West', 1600, 93);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0026', 'C034', 'Headphones', 'Electronics', 5, 150, STR_TO_DATE('03-01-2025', '%d-%m-%Y'), 'January', 'North', 750, 243);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0027', 'C044', 'Smartwatch', 'Electronics', 3, 150, STR_TO_DATE('14-06-2025', '%d-%m-%Y'), 'June', 'East', 450, 81);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0028', 'C008', 'Headphones', 'Electronics', 4, 700, STR_TO_DATE('27-04-2025', '%d-%m-%Y'), 'April', 'North', 2800, 129);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0029', 'C047', 'Tablet', 'Electronics', 3, 200, STR_TO_DATE('15-07-2025', '%d-%m-%Y'), 'July', 'South', 600, 50);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0030', 'C033', 'Laptop', 'Electronics', 3, 150, STR_TO_DATE('13-06-2025', '%d-%m-%Y'), 'June', 'South', 450, 82);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0031', 'C010', 'Headphones', 'Electronics', 2, 200, STR_TO_DATE('19-07-2025', '%d-%m-%Y'), 'July', 'North', 400, 46);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0032', 'C039', 'Headphones', 'Electronics', 4, 500, STR_TO_DATE('29-01-2025', '%d-%m-%Y'), 'January', 'East', 2000, 217);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0033', 'C020', 'Smartphone', 'Electronics', 1, 700, STR_TO_DATE('26-05-2025', '%d-%m-%Y'), 'May', 'North', 700, 100);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0034', 'C006', 'Tablet', 'Electronics', 4, 150, STR_TO_DATE('18-01-2025', '%d-%m-%Y'), 'January', 'South', 600, 228);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0035', 'C009', 'Tablet', 'Electronics', 4, 200, STR_TO_DATE('12-02-2025', '%d-%m-%Y'), 'February', 'East', 800, 203);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0036', 'C034', 'Printer', 'Electronics', 5, 400, STR_TO_DATE('24-02-2025', '%d-%m-%Y'), 'February', 'South', 2000, 191);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0037', 'C046', 'Headphones', 'Electronics', 4, 350, STR_TO_DATE('16-06-2025', '%d-%m-%Y'), 'June', 'East', 1400, 79);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0038', 'C029', 'Smartwatch', 'Electronics', 4, 500, STR_TO_DATE('05-03-2025', '%d-%m-%Y'), 'March', 'South', 2000, 182);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0039', 'C005', 'Headphones', 'Electronics', 1, 200, STR_TO_DATE('22-05-2025', '%d-%m-%Y'), 'May', 'South', 200, 104);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0040', 'C038', 'Smartphone', 'Electronics', 1, 500, STR_TO_DATE('01-07-2025', '%d-%m-%Y'), 'July', 'North', 500, 64);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0041', 'C015', 'Laptop', 'Electronics', 1, 150, STR_TO_DATE('26-03-2025', '%d-%m-%Y'), 'March', 'North', 150, 161);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0042', 'C033', 'Smartphone', 'Electronics', 3, 350, STR_TO_DATE('05-05-2025', '%d-%m-%Y'), 'May', 'South', 1050, 121);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0043', 'C035', 'Smartphone', 'Electronics', 5, 200, STR_TO_DATE('02-05-2025', '%d-%m-%Y'), 'May', 'South', 1000, 124);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0044', 'C031', 'Printer', 'Electronics', 4, 700, STR_TO_DATE('25-01-2025', '%d-%m-%Y'), 'January', 'North', 2800, 221);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0045', 'C043', 'Camera', 'Electronics', 3, 400, STR_TO_DATE('16-04-2025', '%d-%m-%Y'), 'April', 'West', 1200, 140);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0046', 'C047', 'Laptop', 'Electronics', 1, 500, STR_TO_DATE('14-04-2025', '%d-%m-%Y'), 'April', 'East', 500, 142);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0047', 'C007', 'Smartphone', 'Electronics', 2, 700, STR_TO_DATE('18-05-2025', '%d-%m-%Y'), 'May', 'West', 1400, 108);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0048', 'C009', 'Camera', 'Electronics', 2, 300, STR_TO_DATE('29-04-2025', '%d-%m-%Y'), 'April', 'South', 600, 127);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0049', 'C005', 'Camera', 'Electronics', 5, 500, STR_TO_DATE('13-01-2025', '%d-%m-%Y'), 'January', 'North', 2500, 233);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0050', 'C006', 'Printer', 'Electronics', 2, 700, STR_TO_DATE('15-04-2025', '%d-%m-%Y'), 'April', 'West', 1400, 141);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0051', 'C031', 'Smartphone', 'Electronics', 4, 500, STR_TO_DATE('12-02-2025', '%d-%m-%Y'), 'February', 'West', 2000, 203);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0052', 'C001', 'Camera', 'Electronics', 3, 150, STR_TO_DATE('20-07-2025', '%d-%m-%Y'), 'July', 'West', 450, 45);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0053', 'C019', 'Camera', 'Electronics', 5, 350, STR_TO_DATE('03-07-2025', '%d-%m-%Y'), 'July', 'West', 1750, 62);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0054', 'C010', 'Smartphone', 'Electronics', 3, 700, STR_TO_DATE('15-01-2025', '%d-%m-%Y'), 'January', 'North', 2100, 231);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0055', 'C048', 'Headphones', 'Electronics', 1, 500, STR_TO_DATE('30-05-2025', '%d-%m-%Y'), 'May', 'West', 500, 96);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0056', 'C033', 'Printer', 'Electronics', 5, 700, STR_TO_DATE('15-01-2025', '%d-%m-%Y'), 'January', 'North', 3500, 231);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0057', 'C012', 'Laptop', 'Electronics', 5, 500, STR_TO_DATE('22-06-2025', '%d-%m-%Y'), 'June', 'South', 2500, 73);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0058', 'C026', 'Laptop', 'Electronics', 5, 700, STR_TO_DATE('29-05-2025', '%d-%m-%Y'), 'May', 'North', 3500, 97);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0059', 'C040', 'Laptop', 'Electronics', 4, 350, STR_TO_DATE('30-05-2025', '%d-%m-%Y'), 'May', 'East', 1400, 96);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0060', 'C017', 'Smartphone', 'Electronics', 3, 700, STR_TO_DATE('09-03-2025', '%d-%m-%Y'), 'March', 'West', 2100, 178);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0061', 'C009', 'Tablet', 'Electronics', 3, 400, STR_TO_DATE('22-03-2025', '%d-%m-%Y'), 'March', 'North', 1200, 165);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0062', 'C001', 'Camera', 'Electronics', 5, 200, STR_TO_DATE('26-01-2025', '%d-%m-%Y'), 'January', 'North', 1000, 220);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0063', 'C035', 'Smartphone', 'Electronics', 5, 300, STR_TO_DATE('03-02-2025', '%d-%m-%Y'), 'February', 'East', 1500, 212);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0064', 'C005', 'Smartphone', 'Electronics', 3, 300, STR_TO_DATE('10-02-2025', '%d-%m-%Y'), 'February', 'West', 900, 205);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0065', 'C035', 'Tablet', 'Electronics', 3, 200, STR_TO_DATE('26-07-2025', '%d-%m-%Y'), 'July', 'North', 600, 39);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0066', 'C043', 'Printer', 'Electronics', 5, 300, STR_TO_DATE('19-06-2025', '%d-%m-%Y'), 'June', 'North', 1500, 76);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0067', 'C009', 'Headphones', 'Electronics', 1, 500, STR_TO_DATE('10-07-2025', '%d-%m-%Y'), 'July', 'South', 500, 55);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0068', 'C018', 'Headphones', 'Electronics', 5, 700, STR_TO_DATE('03-07-2025', '%d-%m-%Y'), 'July', 'East', 3500, 62);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0069', 'C014', 'Tablet', 'Electronics', 3, 200, STR_TO_DATE('06-05-2025', '%d-%m-%Y'), 'May', 'East', 600, 120);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0070', 'C004', 'Laptop', 'Electronics', 4, 150, STR_TO_DATE('12-03-2025', '%d-%m-%Y'), 'March', 'North', 600, 175);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0071', 'C001', 'Headphones', 'Electronics', 2, 350, STR_TO_DATE('09-03-2025', '%d-%m-%Y'), 'March', 'South', 700, 178);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0072', 'C048', 'Camera', 'Electronics', 5, 350, STR_TO_DATE('20-04-2025', '%d-%m-%Y'), 'April', 'North', 1750, 136);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0073', 'C008', 'Laptop', 'Electronics', 2, 200, STR_TO_DATE('10-01-2025', '%d-%m-%Y'), 'January', 'East', 400, 236);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0074', 'C038', 'Smartwatch', 'Electronics', 2, 400, STR_TO_DATE('02-02-2025', '%d-%m-%Y'), 'February', 'North', 800, 213);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0075', 'C020', 'Headphones', 'Electronics', 1, 300, STR_TO_DATE('23-02-2025', '%d-%m-%Y'), 'February', 'South', 300, 192);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0076', 'C043', 'Laptop', 'Electronics', 3, 150, STR_TO_DATE('24-05-2025', '%d-%m-%Y'), 'May', 'West', 450, 102);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0077', 'C040', 'Tablet', 'Electronics', 2, 700, STR_TO_DATE('11-02-2025', '%d-%m-%Y'), 'February', 'South', 1400, 204);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0078', 'C027', 'Laptop', 'Electronics', 2, 350, STR_TO_DATE('27-03-2025', '%d-%m-%Y'), 'March', 'West', 700, 160);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0079', 'C043', 'Printer', 'Electronics', 2, 300, STR_TO_DATE('10-02-2025', '%d-%m-%Y'), 'February', 'North', 600, 205);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0080', 'C025', 'Printer', 'Electronics', 1, 150, STR_TO_DATE('01-05-2025', '%d-%m-%Y'), 'May', 'South', 150, 125);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0081', 'C013', 'Printer', 'Electronics', 4, 300, STR_TO_DATE('20-03-2025', '%d-%m-%Y'), 'March', 'South', 1200, 167);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0082', 'C015', 'Laptop', 'Electronics', 2, 400, STR_TO_DATE('26-03-2025', '%d-%m-%Y'), 'March', 'East', 800, 161);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0083', 'C005', 'Printer', 'Electronics', 3, 300, STR_TO_DATE('14-06-2025', '%d-%m-%Y'), 'June', 'West', 900, 81);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0084', 'C044', 'Printer', 'Electronics', 5, 300, STR_TO_DATE('08-01-2025', '%d-%m-%Y'), 'January', 'North', 1500, 238);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0085', 'C017', 'Smartphone', 'Electronics', 5, 300, STR_TO_DATE('10-01-2025', '%d-%m-%Y'), 'January', 'North', 1500, 236);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0086', 'C039', 'Camera', 'Electronics', 3, 350, STR_TO_DATE('21-07-2025', '%d-%m-%Y'), 'July', 'East', 1050, 44);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0087', 'C028', 'Smartwatch', 'Electronics', 5, 500, STR_TO_DATE('09-04-2025', '%d-%m-%Y'), 'April', 'South', 2500, 147);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0088', 'C017', 'Laptop', 'Electronics', 4, 500, STR_TO_DATE('14-05-2025', '%d-%m-%Y'), 'May', 'South', 2000, 112);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0089', 'C024', 'Camera', 'Electronics', 1, 350, STR_TO_DATE('26-03-2025', '%d-%m-%Y'), 'March', 'East', 350, 161);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0090', 'C043', 'Printer', 'Electronics', 1, 350, STR_TO_DATE('18-03-2025', '%d-%m-%Y'), 'March', 'East', 350, 169);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0091', 'C043', 'Camera', 'Electronics', 3, 400, STR_TO_DATE('28-06-2025', '%d-%m-%Y'), 'June', 'East', 1200, 67);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0092', 'C036', 'Smartphone', 'Electronics', 2, 400, STR_TO_DATE('20-06-2025', '%d-%m-%Y'), 'June', 'West', 800, 75);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0093', 'C044', 'Tablet', 'Electronics', 2, 200, STR_TO_DATE('26-05-2025', '%d-%m-%Y'), 'May', 'East', 400, 100);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0094', 'C026', 'Smartwatch', 'Electronics', 1, 300, STR_TO_DATE('15-03-2025', '%d-%m-%Y'), 'March', 'South', 300, 172);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0095', 'C028', 'Printer', 'Electronics', 5, 200, STR_TO_DATE('17-06-2025', '%d-%m-%Y'), 'June', 'East', 1000, 78);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0096', 'C030', 'Camera', 'Electronics', 4, 350, STR_TO_DATE('24-02-2025', '%d-%m-%Y'), 'February', 'West', 1400, 191);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0097', 'C048', 'Smartphone', 'Electronics', 1, 300, STR_TO_DATE('12-05-2025', '%d-%m-%Y'), 'May', 'East', 300, 114);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0098', 'C006', 'Printer', 'Electronics', 2, 350, STR_TO_DATE('21-03-2025', '%d-%m-%Y'), 'March', 'South', 700, 166);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0099', 'C013', 'Smartphone', 'Electronics', 1, 500, STR_TO_DATE('04-03-2025', '%d-%m-%Y'), 'March', 'West', 500, 183);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0100', 'C040', 'Printer', 'Electronics', 1, 400, STR_TO_DATE('17-04-2025', '%d-%m-%Y'), 'April', 'South', 400, 139);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0101', 'C046', 'Tablet', 'Electronics', 4, 400, STR_TO_DATE('13-04-2025', '%d-%m-%Y'), 'April', 'South', 1600, 143);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0102', 'C010', 'Tablet', 'Electronics', 1, 150, STR_TO_DATE('17-07-2025', '%d-%m-%Y'), 'July', 'North', 150, 48);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0103', 'C050', 'Camera', 'Electronics', 2, 700, STR_TO_DATE('25-07-2025', '%d-%m-%Y'), 'July', 'West', 1400, 40);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0104', 'C004', 'Smartwatch', 'Electronics', 2, 150, STR_TO_DATE('01-02-2025', '%d-%m-%Y'), 'February', 'West', 300, 214);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0105', 'C009', 'Printer', 'Electronics', 4, 350, STR_TO_DATE('16-05-2025', '%d-%m-%Y'), 'May', 'East', 1400, 110);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0106', 'C049', 'Camera', 'Electronics', 5, 150, STR_TO_DATE('04-07-2025', '%d-%m-%Y'), 'July', 'West', 750, 61);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0107', 'C036', 'Camera', 'Electronics', 2, 350, STR_TO_DATE('02-05-2025', '%d-%m-%Y'), 'May', 'West', 700, 124);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0108', 'C017', 'Printer', 'Electronics', 2, 150, STR_TO_DATE('13-06-2025', '%d-%m-%Y'), 'June', 'East', 300, 82);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0109', 'C050', 'Printer', 'Electronics', 5, 400, STR_TO_DATE('10-06-2025', '%d-%m-%Y'), 'June', 'South', 2000, 85);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0110', 'C018', 'Camera', 'Electronics', 1, 350, STR_TO_DATE('15-03-2025', '%d-%m-%Y'), 'March', 'South', 350, 172);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0111', 'C018', 'Headphones', 'Electronics', 3, 200, STR_TO_DATE('21-01-2025', '%d-%m-%Y'), 'January', 'South', 600, 225);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0112', 'C010', 'Smartphone', 'Electronics', 4, 350, STR_TO_DATE('09-02-2025', '%d-%m-%Y'), 'February', 'South', 1400, 206);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0113', 'C005', 'Camera', 'Electronics', 4, 300, STR_TO_DATE('19-05-2025', '%d-%m-%Y'), 'May', 'West', 1200, 107);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0114', 'C027', 'Laptop', 'Electronics', 2, 150, STR_TO_DATE('18-04-2025', '%d-%m-%Y'), 'April', 'West', 300, 138);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0115', 'C050', 'Smartwatch', 'Electronics', 1, 150, STR_TO_DATE('15-07-2025', '%d-%m-%Y'), 'July', 'West', 150, 50);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0116', 'C031', 'Laptop', 'Electronics', 3, 300, STR_TO_DATE('12-07-2025', '%d-%m-%Y'), 'July', 'West', 900, 53);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0117', 'C027', 'Smartwatch', 'Electronics', 5, 150, STR_TO_DATE('04-06-2025', '%d-%m-%Y'), 'June', 'South', 750, 91);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0118', 'C032', 'Smartphone', 'Electronics', 3, 400, STR_TO_DATE('05-05-2025', '%d-%m-%Y'), 'May', 'North', 1200, 121);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0119', 'C025', 'Headphones', 'Electronics', 4, 350, STR_TO_DATE('12-02-2025', '%d-%m-%Y'), 'February', 'West', 1400, 203);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0120', 'C009', 'Smartwatch', 'Electronics', 5, 500, STR_TO_DATE('11-04-2025', '%d-%m-%Y'), 'April', 'North', 2500, 145);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0121', 'C006', 'Tablet', 'Electronics', 4, 700, STR_TO_DATE('29-04-2025', '%d-%m-%Y'), 'April', 'South', 2800, 127);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0122', 'C004', 'Headphones', 'Electronics', 4, 300, STR_TO_DATE('24-02-2025', '%d-%m-%Y'), 'February', 'West', 1200, 191);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0123', 'C021', 'Headphones', 'Electronics', 4, 300, STR_TO_DATE('12-07-2025', '%d-%m-%Y'), 'July', 'West', 1200, 53);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0124', 'C017', 'Printer', 'Electronics', 1, 400, STR_TO_DATE('05-01-2025', '%d-%m-%Y'), 'January', 'North', 400, 241);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0125', 'C023', 'Smartphone', 'Electronics', 1, 150, STR_TO_DATE('16-06-2025', '%d-%m-%Y'), 'June', 'North', 150, 79);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0126', 'C049', 'Laptop', 'Electronics', 2, 700, STR_TO_DATE('06-01-2025', '%d-%m-%Y'), 'January', 'South', 1400, 240);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0127', 'C016', 'Smartphone', 'Electronics', 4, 350, STR_TO_DATE('30-01-2025', '%d-%m-%Y'), 'January', 'South', 1400, 216);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0128', 'C030', 'Tablet', 'Electronics', 3, 150, STR_TO_DATE('05-04-2025', '%d-%m-%Y'), 'April', 'South', 450, 151);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0129', 'C039', 'Smartwatch', 'Electronics', 1, 150, STR_TO_DATE('29-07-2025', '%d-%m-%Y'), 'July', 'South', 150, 36);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0130', 'C020', 'Laptop', 'Electronics', 5, 500, STR_TO_DATE('21-03-2025', '%d-%m-%Y'), 'March', 'West', 2500, 166);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0131', 'C026', 'Tablet', 'Electronics', 2, 500, STR_TO_DATE('01-06-2025', '%d-%m-%Y'), 'June', 'South', 1000, 94);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0132', 'C007', 'Tablet', 'Electronics', 3, 150, STR_TO_DATE('25-06-2025', '%d-%m-%Y'), 'June', 'North', 450, 70);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0133', 'C037', 'Printer', 'Electronics', 1, 300, STR_TO_DATE('17-05-2025', '%d-%m-%Y'), 'May', 'West', 300, 109);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0134', 'C043', 'Headphones', 'Electronics', 1, 200, STR_TO_DATE('15-06-2025', '%d-%m-%Y'), 'June', 'East', 200, 80);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0135', 'C001', 'Printer', 'Electronics', 4, 150, STR_TO_DATE('06-05-2025', '%d-%m-%Y'), 'May', 'North', 600, 120);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0136', 'C028', 'Headphones', 'Electronics', 4, 350, STR_TO_DATE('09-02-2025', '%d-%m-%Y'), 'February', 'West', 1400, 206);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0137', 'C012', 'Tablet', 'Electronics', 5, 350, STR_TO_DATE('11-03-2025', '%d-%m-%Y'), 'March', 'West', 1750, 176);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0138', 'C030', 'Camera', 'Electronics', 5, 300, STR_TO_DATE('24-03-2025', '%d-%m-%Y'), 'March', 'South', 1500, 163);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0139', 'C006', 'Headphones', 'Electronics', 4, 700, STR_TO_DATE('12-07-2025', '%d-%m-%Y'), 'July', 'West', 2800, 53);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0140', 'C037', 'Smartwatch', 'Electronics', 4, 300, STR_TO_DATE('08-01-2025', '%d-%m-%Y'), 'January', 'West', 1200, 238);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0141', 'C021', 'Smartphone', 'Electronics', 4, 700, STR_TO_DATE('01-04-2025', '%d-%m-%Y'), 'April', 'East', 2800, 155);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0142', 'C022', 'Headphones', 'Electronics', 5, 350, STR_TO_DATE('12-03-2025', '%d-%m-%Y'), 'March', 'North', 1750, 175);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0143', 'C034', 'Smartphone', 'Electronics', 1, 700, STR_TO_DATE('04-07-2025', '%d-%m-%Y'), 'July', 'West', 700, 61);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0144', 'C032', 'Smartwatch', 'Electronics', 2, 350, STR_TO_DATE('02-05-2025', '%d-%m-%Y'), 'May', 'West', 700, 124);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0145', 'C029', 'Printer', 'Electronics', 1, 500, STR_TO_DATE('17-03-2025', '%d-%m-%Y'), 'March', 'South', 500, 170);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0146', 'C026', 'Tablet', 'Electronics', 2, 300, STR_TO_DATE('19-06-2025', '%d-%m-%Y'), 'June', 'East', 600, 76);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0147', 'C031', 'Smartwatch', 'Electronics', 5, 300, STR_TO_DATE('19-04-2025', '%d-%m-%Y'), 'April', 'East', 1500, 137);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0148', 'C023', 'Tablet', 'Electronics', 4, 300, STR_TO_DATE('20-03-2025', '%d-%m-%Y'), 'March', 'East', 1200, 167);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0149', 'C015', 'Laptop', 'Electronics', 2, 300, STR_TO_DATE('31-01-2025', '%d-%m-%Y'), 'January', 'South', 600, 215);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0150', 'C013', 'Smartphone', 'Electronics', 4, 300, STR_TO_DATE('05-07-2025', '%d-%m-%Y'), 'July', 'East', 1200, 60);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0151', 'C007', 'Printer', 'Electronics', 2, 300, STR_TO_DATE('28-02-2025', '%d-%m-%Y'), 'February', 'East', 600, 187);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0152', 'C012', 'Headphones', 'Electronics', 1, 350, STR_TO_DATE('17-05-2025', '%d-%m-%Y'), 'May', 'South', 350, 109);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0153', 'C018', 'Laptop', 'Electronics', 1, 200, STR_TO_DATE('16-03-2025', '%d-%m-%Y'), 'March', 'South', 200, 171);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0154', 'C041', 'Printer', 'Electronics', 4, 500, STR_TO_DATE('04-01-2025', '%d-%m-%Y'), 'January', 'East', 2000, 242);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0155', 'C031', 'Camera', 'Electronics', 4, 300, STR_TO_DATE('17-02-2025', '%d-%m-%Y'), 'February', 'North', 1200, 198);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0156', 'C017', 'Printer', 'Electronics', 4, 500, STR_TO_DATE('30-07-2025', '%d-%m-%Y'), 'July', 'North', 2000, 35);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0157', 'C026', 'Camera', 'Electronics', 1, 200, STR_TO_DATE('11-06-2025', '%d-%m-%Y'), 'June', 'North', 200, 84);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0158', 'C010', 'Smartphone', 'Electronics', 5, 300, STR_TO_DATE('22-01-2025', '%d-%m-%Y'), 'January', 'South', 1500, 224);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0159', 'C008', 'Smartwatch', 'Electronics', 4, 200, STR_TO_DATE('02-06-2025', '%d-%m-%Y'), 'June', 'South', 800, 93);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0160', 'C050', 'Smartwatch', 'Electronics', 4, 400, STR_TO_DATE('24-04-2025', '%d-%m-%Y'), 'April', 'East', 1600, 132);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0161', 'C038', 'Camera', 'Electronics', 3, 200, STR_TO_DATE('08-06-2025', '%d-%m-%Y'), 'June', 'North', 600, 87);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0162', 'C040', 'Tablet', 'Electronics', 1, 150, STR_TO_DATE('23-02-2025', '%d-%m-%Y'), 'February', 'South', 150, 192);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0163', 'C017', 'Tablet', 'Electronics', 1, 700, STR_TO_DATE('03-03-2025', '%d-%m-%Y'), 'March', 'South', 700, 184);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0164', 'C036', 'Laptop', 'Electronics', 2, 500, STR_TO_DATE('15-04-2025', '%d-%m-%Y'), 'April', 'West', 1000, 141);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0165', 'C045', 'Smartwatch', 'Electronics', 4, 300, STR_TO_DATE('09-01-2025', '%d-%m-%Y'), 'January', 'South', 1200, 237);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0166', 'C019', 'Tablet', 'Electronics', 3, 350, STR_TO_DATE('27-04-2025', '%d-%m-%Y'), 'April', 'North', 1050, 129);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0167', 'C044', 'Smartphone', 'Electronics', 3, 150, STR_TO_DATE('22-07-2025', '%d-%m-%Y'), 'July', 'South', 450, 43);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0168', 'C028', 'Laptop', 'Electronics', 5, 700, STR_TO_DATE('15-06-2025', '%d-%m-%Y'), 'June', 'South', 3500, 80);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0169', 'C018', 'Printer', 'Electronics', 2, 500, STR_TO_DATE('16-01-2025', '%d-%m-%Y'), 'January', 'South', 1000, 230);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0170', 'C020', 'Smartwatch', 'Electronics', 5, 300, STR_TO_DATE('23-04-2025', '%d-%m-%Y'), 'April', 'North', 1500, 133);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0171', 'C030', 'Tablet', 'Electronics', 3, 350, STR_TO_DATE('14-04-2025', '%d-%m-%Y'), 'April', 'East', 1050, 142);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0172', 'C033', 'Smartwatch', 'Electronics', 4, 400, STR_TO_DATE('21-01-2025', '%d-%m-%Y'), 'January', 'North', 1600, 225);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0173', 'C028', 'Tablet', 'Electronics', 3, 200, STR_TO_DATE('06-03-2025', '%d-%m-%Y'), 'March', 'North', 600, 181);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0174', 'C006', 'Smartphone', 'Electronics', 5, 200, STR_TO_DATE('06-01-2025', '%d-%m-%Y'), 'January', 'East', 1000, 240);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0175', 'C037', 'Laptop', 'Electronics', 2, 400, STR_TO_DATE('13-05-2025', '%d-%m-%Y'), 'May', 'West', 800, 113);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0176', 'C018', 'Smartphone', 'Electronics', 5, 400, STR_TO_DATE('12-06-2025', '%d-%m-%Y'), 'June', 'West', 2000, 83);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0177', 'C006', 'Camera', 'Electronics', 3, 400, STR_TO_DATE('27-03-2025', '%d-%m-%Y'), 'March', 'East', 1200, 160);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0178', 'C043', 'Laptop', 'Electronics', 2, 300, STR_TO_DATE('16-04-2025', '%d-%m-%Y'), 'April', 'West', 600, 140);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0179', 'C019', 'Tablet', 'Electronics', 4, 150, STR_TO_DATE('14-07-2025', '%d-%m-%Y'), 'July', 'North', 600, 51);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0180', 'C030', 'Laptop', 'Electronics', 3, 300, STR_TO_DATE('24-03-2025', '%d-%m-%Y'), 'March', 'North', 900, 163);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0181', 'C050', 'Camera', 'Electronics', 5, 150, STR_TO_DATE('01-01-2025', '%d-%m-%Y'), 'January', 'West', 750, 245);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0182', 'C027', 'Laptop', 'Electronics', 2, 200, STR_TO_DATE('03-04-2025', '%d-%m-%Y'), 'April', 'West', 400, 153);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0183', 'C041', 'Camera', 'Electronics', 1, 700, STR_TO_DATE('10-03-2025', '%d-%m-%Y'), 'March', 'South', 700, 177);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0184', 'C019', 'Camera', 'Electronics', 4, 500, STR_TO_DATE('08-01-2025', '%d-%m-%Y'), 'January', 'South', 2000, 238);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0185', 'C046', 'Smartphone', 'Electronics', 3, 200, STR_TO_DATE('04-01-2025', '%d-%m-%Y'), 'January', 'West', 600, 242);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0186', 'C006', 'Smartphone', 'Electronics', 1, 400, STR_TO_DATE('31-01-2025', '%d-%m-%Y'), 'January', 'South', 400, 215);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0187', 'C032', 'Tablet', 'Electronics', 3, 200, STR_TO_DATE('30-06-2025', '%d-%m-%Y'), 'June', 'East', 600, 65);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0188', 'C027', 'Printer', 'Electronics', 4, 400, STR_TO_DATE('04-03-2025', '%d-%m-%Y'), 'March', 'West', 1600, 183);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0189', 'C036', 'Smartphone', 'Electronics', 4, 700, STR_TO_DATE('03-06-2025', '%d-%m-%Y'), 'June', 'South', 2800, 92);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0190', 'C005', 'Headphones', 'Electronics', 4, 300, STR_TO_DATE('21-07-2025', '%d-%m-%Y'), 'July', 'East', 1200, 44);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0191', 'C001', 'Headphones', 'Electronics', 3, 150, STR_TO_DATE('31-05-2025', '%d-%m-%Y'), 'May', 'West', 450, 95);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0192', 'C010', 'Camera', 'Electronics', 5, 400, STR_TO_DATE('30-03-2025', '%d-%m-%Y'), 'March', 'East', 2000, 157);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0193', 'C036', 'Printer', 'Electronics', 5, 400, STR_TO_DATE('27-04-2025', '%d-%m-%Y'), 'April', 'East', 2000, 129);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0194', 'C013', 'Tablet', 'Electronics', 2, 200, STR_TO_DATE('09-04-2025', '%d-%m-%Y'), 'April', 'South', 400, 147);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0195', 'C050', 'Camera', 'Electronics', 1, 300, STR_TO_DATE('10-07-2025', '%d-%m-%Y'), 'July', 'West', 300, 55);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0196', 'C046', 'Printer', 'Electronics', 4, 400, STR_TO_DATE('19-06-2025', '%d-%m-%Y'), 'June', 'South', 1600, 76);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0197', 'C032', 'Laptop', 'Electronics', 2, 200, STR_TO_DATE('01-06-2025', '%d-%m-%Y'), 'June', 'East', 400, 94);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0198', 'C007', 'Printer', 'Electronics', 4, 500, STR_TO_DATE('15-05-2025', '%d-%m-%Y'), 'May', 'West', 2000, 111);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0199', 'C001', 'Tablet', 'Electronics', 2, 400, STR_TO_DATE('17-06-2025', '%d-%m-%Y'), 'June', 'South', 800, 78);
INSERT INTO sales (order_id, customer_id, product, category, quantity, price, order_date, month, region, revenue, recency) VALUES ('O0200', 'C005', 'Camera', 'Electronics', 3, 300, STR_TO_DATE('09-06-2025', '%d-%m-%Y'), 'June', 'West', 900, 86);