-
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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.', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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', '[email protected]');
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.', '[email protected]');
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);