-
Notifications
You must be signed in to change notification settings - Fork 130
/
postgrestakehomeexam.sql
235 lines (227 loc) · 41.8 KB
/
postgrestakehomeexam.sql
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
CREATE SEQUENCE customers_seq;
CREATE TABLE customers (customer_id int DEFAULT NEXTVAL ('customers_seq'), joined_at timestamp(0) NULL DEFAULT NULL, last_login_at timestamp(0) NULL DEFAULT NULL, state varchar(100) DEFAULT NULL, is_deactivated smallint DEFAULT NULL, name varchar(100) DEFAULT NULL, email varchar(100) DEFAULT NULL, PRIMARY KEY (customer_id));
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (1, '1993-11-21 03:44:42', '2013-05-25 22:21:50', 'MN', 1, 'Prof. Alf Trantow', 'malcolm.farrell@hotmail.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (2, '2013-11-01 07:19:24', '2014-02-23 04:11:17', 'AL', 1, 'Mr. Giuseppe Nicolas I', 'prosacco.eve@yahoo.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (3, '1995-03-18 12:24:22', '2004-02-04 20:03:25', 'IA', 1, 'Talia Christiansen I', 'iolson@gmail.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (4, '1999-07-04 06:34:24', '1971-06-03 16:28:44', 'AR', 0, 'Caleigh Sipes', 'una71@yahoo.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (5, '1981-11-30 01:43:45', '2016-07-02 02:44:07', 'SD', 1, 'Oran Sawayn', 'kirstin.haag@hotmail.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (6, '2010-06-10 03:56:19', '1985-02-24 11:01:25', 'NC', 1, 'Miss Claudie Ward III', 'hayes.andre@yahoo.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (7, '2005-07-21 05:56:14', '1995-10-15 06:50:52', 'WV', 1, 'Alfred Jacobs', 'keira10@gmail.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (8, '1998-04-25 10:23:21', '1987-08-24 19:40:34', 'MO', 1, 'Kelley Ortiz', 'tyrel19@hotmail.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (9, '1981-09-21 20:05:36', '1975-06-17 17:53:10', 'AR', 1, 'Krystina Carroll', 'kathryn19@hotmail.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (10, '2012-08-03 00:19:12', '2009-06-21 23:32:53', 'TX', 1, 'Cyrus Cole', 'weimann.emily@hotmail.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (11, '1975-02-05 03:49:47', '1994-05-21 00:24:10', 'TX', 1, 'Mrs. Elissa Schiller I', 'bradtke.burnice@hotmail.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (12, '1999-12-06 12:57:33', '2007-04-24 13:22:48', 'AL', 1, 'Rhoda Rolfson', 'rutherford.karina@gmail.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (13, '1996-12-27 02:43:22', '1977-07-09 17:16:48', 'SC', 1, 'Roma Hills II', 'mollie.ward@yahoo.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (14, '1981-08-09 20:26:32', '2007-10-12 18:10:48', 'NY', 1, 'Giovanni Hilll', 'sbins@yahoo.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (15, '2008-07-24 09:36:45', '1972-07-17 03:31:55', 'AK', 0, 'Gaston Cremin', 'claudia30@yahoo.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (16, '1996-05-31 07:02:51', '1998-11-18 18:33:29', 'OR', 1, 'Mrs. Greta Jones', 'gust10@yahoo.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (17, '1978-07-01 01:11:27', '1998-10-25 14:29:42', 'WA', 1, 'Ransom Greenholt', 'gerda56@gmail.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (18, '1970-01-23 02:50:00', '1998-12-13 22:46:38', 'TN', 1, 'Margarete Upton', 'hahn.olga@hotmail.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (19, '1979-11-28 09:55:37', '2002-02-05 08:12:42', 'FL', 1, 'Destany Torphy PhD', 'pbalistreri@hotmail.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (20, '1973-08-04 01:15:45', '1975-04-19 17:37:31', 'MD', 1, 'Nayeli Johnston', 'cruickshank.dewitt@gmail.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (21, '1985-07-18 11:29:44', '1990-10-21 02:54:40', 'ID', 0, 'Xavier Gutmann', 'uwatsica@hotmail.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (22, '2002-06-11 08:33:12', '1989-08-22 14:09:07', 'IN', 0, 'Prof. Carmelo Hodkiewicz', 'sabshire@yahoo.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (23, '2004-10-02 18:54:15', '2013-09-20 21:25:13', 'LA', 1, 'Mr. Arjun Hilll Sr.', 'adelia.jacobi@hotmail.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (24, '2001-12-08 11:41:00', '1976-03-25 08:01:36', 'VT', 1, 'Shayne Franecki', 'orion94@hotmail.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (25, '1974-05-21 02:07:45', '2000-10-19 03:05:23', 'DC', 1, 'Dr. Monique Ullrich', 'veum.eloisa@yahoo.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (26, '2000-11-21 09:23:16', '1978-12-07 23:57:43', 'AK', 0, 'Julian Jacobi', 'maximillian05@yahoo.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (27, '2011-11-01 09:22:46', '2006-11-30 21:21:58', 'VT', 1, 'Hilario Funk IV', 'wspencer@hotmail.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (28, '1995-10-27 00:55:57', '1995-07-27 17:13:24', 'OR', 1, 'Tavares Quitzon', 'rafael.brown@yahoo.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (29, '1976-06-08 19:06:32', '1978-08-23 21:42:24', 'VT', 0, 'Marley King', 'rbailey@yahoo.com');
INSERT INTO customers (customer_id, joined_at, last_login_at, state, is_deactivated, name, email) VALUES (30, '1991-05-31 09:02:14', '1973-01-14 00:42:01', 'VT', 1, 'Alyce Bartoletti Jr.', 'krystina.ratke@hotmail.com');
CREATE SEQUENCE products_seq;
CREATE TABLE products (product_id int DEFAULT NEXTVAL ('products_seq'), added_at timestamp(0) NULL DEFAULT NULL, product_cost decimal(15,2) DEFAULT NULL, product_name varchar(50) DEFAULT NULL, product_category varchar(50) DEFAULT NULL, PRIMARY KEY (product_id));
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (1, '1980-11-13 07:53:23', '259.07', ' Ear Blind', ' General Belongings');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (2, '1972-08-11 03:12:25', '24.25', ' Earthmark', ' General Belongings');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (3, '2004-12-19 19:36:16', '779.35', ' DyoRama', ' Random Group');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (4, '1979-03-07 04:57:39', '736.81', ' DyeNamo', ' General Belongings');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (5, '2015-07-22 08:28:21', '162.81', ' Airplex', 'Generic Things');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (6, '1996-12-18 21:51:38', '424.45', ' Captain Fennel', ' Common Items');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (7, '1976-02-03 14:04:17', '209.66', ' E. Vixen', ' Common Items');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (8, '1986-01-05 10:03:07', '681.25', ' E. Vixen', ' Some Stuff');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (9, '2014-12-05 20:08:30', '113.25', ' Affluex', ' Random Group');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (10, '1983-09-03 16:33:59', '787.30', ' CaptiVite', ' Random Group');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (11, '2014-09-24 11:36:51', '126.63', ' Captain Bamboo', ' General Belongings');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (12, '1994-07-11 09:17:17', '551.50', ' Aftertizer', 'Generic Things');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (13, '1993-06-19 11:02:48', '155.02', ' Earthmark', ' Some Stuff');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (14, '1999-09-10 14:44:37', '114.98', 'Aesthetic Bug Gloss', ' Some Stuff');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (15, '1980-03-17 12:57:05', '65.07', ' Air Bingo', ' Common Items');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (16, '1980-11-11 05:53:38', '196.22', ' Airborne Pickle', ' General Belongings');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (17, '1999-07-09 09:03:14', '866.01', ' CanvArt', ' Some Stuff');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (18, '2009-11-12 14:48:15', '360.65', ' E. Vixen', ' Some Stuff');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (19, '1990-08-22 01:58:06', '731.73', ' Earbang', ' General Belongings');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (20, '2015-06-28 16:15:12', '610.60', ' Air Bingo', ' General Belongings');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (21, '2005-09-28 23:02:35', '581.78', ' Earthmark', ' Common Items');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (22, '1970-06-05 20:12:31', '367.63', ' Candy Floss', ' Some Stuff');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (23, '2001-05-28 07:00:31', '940.23', ' AirHead', ' Common Items');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (24, '1998-04-12 15:54:19', '727.14', ' Candy Palanquin', ' Random Group');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (25, '2017-02-23 01:44:33', '781.98', ' Earth to Earth', 'Generic Things');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (26, '2010-05-17 18:07:07', '147.68', ' Capri-corndog', ' General Belongings');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (27, '1971-08-21 20:59:05', '14.47', ' Eargo', ' General Belongings');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (28, '1972-11-07 03:03:32', '47.35', ' Eargo', ' Some Stuff');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (29, '1999-10-18 05:22:24', '86.15', ' CaptiVite', ' Common Items');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (30, '2013-06-28 18:38:12', '110.01', ' Captain Zip', ' Random Group');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (31, '2017-03-31 00:39:10', '658.46', ' Canopoly', ' Some Stuff');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (32, '1974-01-24 09:40:13', '541.30', ' Air Fair', 'Generic Things');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (33, '2018-01-19 08:25:51', '350.42', ' Captain Fennel', 'Generic Things');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (34, '2006-02-07 17:46:41', '361.59', ' AirDock', ' Some Stuff');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (35, '1974-03-05 05:47:49', '634.69', ' Agriox', ' Common Items');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (36, '1999-03-28 15:19:06', '192.20', ' Air Fair', ' General Belongings');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (37, '1996-12-28 07:41:37', '26.74', ' CanvArt', 'Generic Things');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (38, '1998-10-07 23:35:25', '639.08', ' Air Bingo', ' Common Items');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (39, '1971-01-19 20:50:37', '146.08', ' Dyenamic', ' Some Stuff');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (40, '1975-11-12 15:36:40', '654.23', ' Captain Fennel', ' Some Stuff');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (41, '1995-03-12 03:38:55', '311.32', ' Earthscope', ' Some Stuff');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (42, '2000-05-01 14:07:36', '474.26', ' Aftertizer', 'Generic Things');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (43, '1971-06-29 08:22:29', '651.94', ' Eargo', ' Random Group');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (44, '1976-04-06 16:12:38', '135.37', ' Earthpure', ' Common Items');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (45, '1978-07-08 05:47:06', '131.67', ' Capri-corndog', ' Some Stuff');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (46, '2017-01-12 09:59:29', '933.55', ' Candy Palanquin', ' General Belongings');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (47, '1972-02-22 20:02:55', '229.22', ' Earthscope', ' Common Items');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (48, '1980-01-24 21:40:01', '606.66', ' Airborne Pickle', 'Generic Things');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (49, '1992-06-16 22:58:09', '511.86', ' DyoRama', ' Common Items');
INSERT INTO products (product_id, added_at, product_cost, product_name, product_category) VALUES (50, '1992-07-28 09:11:54', '488.59', ' Airplex', ' Some Stuff');
CREATE SEQUENCE transactions_seq;
CREATE TABLE transactions (transact_id int DEFAULT NEXTVAL ('transactions_seq'), customer_id int DEFAULT NULL, transact_at timestamp(0) NULL DEFAULT NULL, transact_amt decimal(15,2) DEFAULT NULL, product_id int DEFAULT NULL, payment_type varchar(100) NULL, payment_success smallint DEFAULT NULL, PRIMARY KEY (transact_id));
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (1, 24, '2013-01-08 00:24:02', '42.18', 29, ' cash', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (2, 17, '1973-01-25 00:07:25', '789.31', 11, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (3, 8, '2016-09-10 08:49:33', '171.83', 18, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (4, 20, '2000-01-15 01:51:47', '531.43', 9, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (5, 6, '1972-11-09 19:32:39', '736.21', 43, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (6, 19, '2000-01-09 14:16:57', '83.39', 37, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (7, 12, '2007-12-03 16:23:25', '218.85', 14, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (8, 3, '2000-01-27 21:46:23', '564.77', 38, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (9, 20, '2000-07-02 19:25:31', '371.33', 22, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (10, 13, '1974-11-23 07:51:47', '15.10', 50, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (11, 19, '1974-05-06 09:10:00', '581.26', 13, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (12, 18, '1977-04-14 03:38:13', '26.44', 12, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (13, 20, '1982-12-14 01:40:03', '89.39', 35, ' cash', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (14, 26, '1990-01-01 02:55:04', '553.87', 49, ' cash', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (15, 5, '1987-11-16 06:01:28', '481.11', 31, ' cash', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (16, 15, '1973-03-08 17:09:38', '904.83', 39, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (17, 30, '1989-09-05 06:01:25', '317.49', 49, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (18, 18, '2016-05-19 22:21:24', '602.47', 18, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (19, 29, '2017-03-14 14:00:01', '295.64', 3, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (20, 4, '2014-08-27 13:58:05', '230.87', 6, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (21, 6, '2014-01-15 15:39:14', '483.09', 10, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (22, 9, '2014-05-16 13:33:41', '998.03', 5, ' cash', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (23, 14, '2005-09-03 08:49:42', '978.57', 35, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (24, 4, '1973-12-14 02:05:20', '975.62', 25, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (25, 23, '1970-02-05 08:42:26', '129.26', 22, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (26, 27, '1982-03-07 16:10:06', '419.16', 25, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (27, 27, '1970-03-01 00:42:53', '121.89', 33, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (28, 21, '2012-02-12 17:24:04', '51.03', 21, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (29, 28, '2013-04-06 18:34:59', '379.97', 36, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (30, 13, '2016-09-18 14:35:51', '315.93', 2, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (31, 22, '1984-06-24 23:34:39', '735.23', 40, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (32, 16, '1975-04-17 16:20:38', '117.46', 2, ' cash', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (33, 23, '2002-08-21 15:14:45', '591.92', 35, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (34, 23, '2010-10-24 05:29:49', '382.52', 32, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (35, 24, '1971-12-06 03:44:19', '345.68', 30, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (36, 3, '1984-04-22 21:35:50', '117.36', 25, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (37, 17, '2015-11-24 21:21:29', '835.59', 20, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (38, 17, '2000-11-06 04:07:09', '605.39', 45, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (39, 18, '2008-01-18 19:06:22', '646.90', 27, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (40, 19, '2004-02-04 04:35:48', '557.34', 21, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (41, 10, '1978-07-02 08:40:47', '675.76', 15, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (42, 29, '2004-06-24 13:43:17', '141.64', 9, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (43, 11, '1992-08-24 10:56:32', '713.95', 50, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (44, 11, '1994-03-23 15:37:43', '527.20', 26, ' cash', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (45, 18, '1976-08-21 02:50:47', '695.68', 49, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (46, 4, '2004-01-10 08:49:36', '783.76', 29, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (47, 17, '1976-08-29 19:02:31', '995.04', 4, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (48, 3, '1973-07-30 15:33:13', '746.91', 47, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (49, 9, '1987-01-26 11:17:53', '15.95', 3, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (50, 10, '2014-10-10 04:27:17', '89.22', 10, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (51, 16, '1993-03-19 05:53:45', '95.29', 45, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (52, 10, '1985-02-17 04:12:50', '86.27', 18, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (53, 23, '1992-02-20 04:16:55', '690.60', 8, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (54, 22, '1979-10-22 10:23:48', '20.06', 47, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (55, 20, '1991-01-03 08:26:18', '812.76', 26, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (56, 1, '1976-05-10 13:13:47', '779.01', 38, ' cash', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (57, 25, '1992-07-18 15:53:21', '419.17', 7, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (58, 12, '1987-05-26 13:46:20', '265.42', 50, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (59, 27, '2007-06-10 09:51:23', '898.03', 2, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (60, 7, '2015-06-20 22:31:00', '849.93', 44, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (61, 3, '2002-09-13 08:39:45', '935.95', 44, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (62, 25, '1974-03-13 15:13:47', '197.44', 14, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (63, 2, '1995-12-22 20:23:44', '65.72', 39, ' cash', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (64, 2, '1991-08-28 00:52:29', '393.86', 27, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (65, 8, '2004-09-24 07:53:12', '903.52', 15, ' cash', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (66, 13, '1986-01-02 16:58:53', '855.03', 10, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (67, 4, '1986-05-01 17:14:03', '391.59', 16, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (68, 20, '1991-09-05 07:03:44', '886.54', 40, ' cash', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (69, 22, '1980-08-23 16:20:53', '208.70', 21, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (70, 27, '1981-02-28 10:07:41', '635.20', 4, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (71, 19, '2001-08-31 21:24:17', '999.17', 34, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (72, 8, '1992-07-27 19:45:57', '350.33', 49, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (73, 4, '2009-05-28 07:42:54', '295.79', 49, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (74, 15, '1975-12-19 07:02:14', '99.77', 15, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (75, 13, '1976-11-11 14:53:16', '813.94', 25, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (76, 9, '1998-11-14 11:44:33', '854.78', 49, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (77, 21, '1994-04-19 18:05:56', '128.01', 46, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (78, 25, '2015-09-26 15:59:06', '744.50', 30, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (79, 18, '1988-02-22 18:27:12', '138.43', 38, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (80, 6, '2010-09-04 05:37:40', '160.47', 1, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (81, 21, '2012-12-10 15:43:07', '354.57', 20, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (82, 6, '1992-07-03 01:27:56', '638.07', 18, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (83, 22, '1976-06-09 02:55:27', '961.95', 26, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (84, 8, '2001-12-20 07:04:32', '183.80', 14, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (85, 3, '1993-03-02 18:22:19', '549.95', 28, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (86, 6, '2016-03-27 22:05:12', '268.98', 15, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (87, 27, '1994-02-19 23:39:05', '878.58', 21, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (88, 17, '2015-03-01 21:25:50', '635.34', 7, ' cash', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (89, 6, '1997-08-07 17:50:48', '87.35', 14, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (90, 16, '1991-03-03 04:43:14', '714.62', 16, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (91, 26, '1974-07-22 13:50:30', '64.62', 11, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (92, 21, '2002-11-07 22:54:47', '638.64', 33, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (93, 18, '1997-09-08 12:35:45', '239.22', 11, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (94, 25, '1987-05-07 02:15:47', '268.10', 2, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (95, 3, '1976-04-06 09:18:03', '386.94', 8, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (96, 26, '1985-09-08 09:54:02', '177.72', 6, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (97, 9, '1973-02-11 15:47:07', '456.92', 14, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (98, 10, '2002-12-01 19:43:35', '644.33', 33, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (99, 26, '1995-03-08 01:56:20', '85.35', 25, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (100, 16, '2003-12-04 15:30:33', '129.56', 4, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (101, 8, '1975-03-20 18:17:46', '160.90', 40, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (102, 29, '1987-11-16 10:10:16', '627.60', 28, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (103, 28, '1990-05-25 14:55:01', '856.39', 22, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (104, 4, '2001-05-22 22:54:23', '287.31', 24, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (105, 7, '1976-09-21 12:38:43', '709.09', 14, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (106, 15, '2010-04-25 01:03:04', '441.68', 27, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (107, 3, '2002-09-14 20:58:18', '156.33', 26, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (108, 22, '1984-12-26 17:52:34', '402.95', 8, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (109, 6, '2017-04-13 21:02:17', '609.53', 20, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (110, 28, '1976-03-08 17:12:49', '415.70', 16, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (111, 5, '1997-06-30 07:31:08', '740.35', 27, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (112, 23, '1997-06-04 08:51:35', '933.50', 15, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (113, 21, '1981-03-11 09:30:00', '155.40', 40, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (114, 5, '1972-05-31 07:07:35', '422.73', 14, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (115, 3, '2005-12-05 21:27:24', '18.59', 21, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (116, 7, '1989-04-15 21:52:37', '505.89', 26, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (117, 26, '1974-03-30 16:32:35', '948.00', 48, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (118, 16, '1994-02-21 14:50:31', '596.08', 37, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (119, 20, '2008-10-12 16:13:47', '890.10', 42, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (120, 11, '1980-06-03 17:08:50', '671.05', 45, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (121, 19, '1990-12-01 13:54:07', '283.96', 30, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (122, 8, '2010-12-30 05:04:37', '976.09', 21, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (123, 12, '1994-04-30 12:33:04', '587.45', 5, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (124, 9, '2002-04-21 21:33:48', '420.96', 31, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (125, 2, '1992-04-01 07:06:15', '454.69', 35, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (126, 11, '1994-08-14 15:32:19', '943.03', 9, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (127, 9, '1973-02-07 23:32:21', '358.01', 3, 'credit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (128, 28, '2003-02-05 16:50:45', '23.82', 36, ' debit card', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (129, 15, '1987-10-14 14:26:43', '747.17', 28, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (130, 23, '1980-08-09 09:45:24', '987.08', 21, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (131, 5, '1997-08-31 18:18:46', '668.46', 34, ' cash', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (132, 11, '1985-03-29 12:45:43', '593.46', 9, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (133, 28, '1973-08-19 04:00:38', '561.89', 8, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (134, 11, '1982-03-08 09:17:42', '629.37', 15, ' cash', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (135, 25, '1979-10-11 05:46:31', '672.75', 1, ' cash', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (136, 28, '2011-04-28 19:07:20', '498.55', 42, ' cash', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (137, 14, '1987-03-17 03:58:48', '362.18', 16, ' cash', 1);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (138, 23, '2007-10-29 13:44:47', '890.51', 47, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (139, 13, '2002-02-05 01:02:25', '387.06', 15, ' debit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (140, 24, '2011-04-03 03:01:05', '66.47', 29, 'credit card', 0);
INSERT INTO transactions (transact_id, customer_id, transact_at, transact_amt, product_id, payment_type, payment_success) VALUES (141, 3, '1990-09-05 08:41:30', '961.42', 45, ' debit card', 1);