· 9 years ago · Nov 04, 2016, 02:06 AM
1-- -h localhost -d test
2
3DROP TABLE IF EXISTS customers;
4DROP TABLE IF EXISTS products;
5DROP TABLE IF EXISTS orders;
6
7CREATE TABLE customers (
8 id integer,
9 name text,
10 city text,
11 region text,
12 signup_date date
13);
14
15INSERT INTO customers (id, name, city, region, signup_date)
16(VALUES
17 (1,'Donovan Melton','Berlin','Berlin','2017-08-27'),
18 (2,'Jamal Tran','Pinneberg','Saarland','2017-03-27'),
19 (3,'Lani Bowen','Erlangen','Bavaria','2015-04-04'),
20 (4,'Carissa Scott','Berlin','Berlin','2017-02-10'),
21 (5,'Cyrus Crawford','Hamburg','Hamburg','2016-07-24'),
22 (6,'Burke Hendrix','Bremen','Bremen','2016-09-20'),
23 (7,'Elizabeth Reilly','Peine','Lower Saxony','2015-10-19'),
24 (8,'Nell Newman','Nordhorn','Lower Saxony','2016-11-26'),
25 (9,'Rama Floyd','Göppingen','Baden','2015-08-31'),
26 (10,'Galvin Wooten','Hamburg','Hamburg','2016-10-09'),
27 (11,'Hilda Cannon','Hamburg','Hamburg','2017-04-16'),
28 (12,'MacKensie Underwood','Offenburg','Baden','2015-09-04'),
29 (13,'Laurel Logan','Berlin','Berlin','2017-07-11'),
30 (14,'Lenore Grant','Berlin','Berlin','2016-01-13'),
31 (15,'Slade Acosta','Berlin','Berlin','2015-10-13'),
32 (16,'Martena Little','Passau','Bavaria','2017-11-14'),
33 (17,'Timon Carpenter','Hamburg','Hamburg','2017-05-19'),
34 (18,'Josiah Campos','Hamburg','Hamburg','2016-07-15'),
35 (19,'Justin Gutierrez','Fulda','Hesse','2016-07-18'),
36 (20,'Latifah Reid','Bremerhaven','Bremen','2016-07-17'),
37 (21,'Amethyst Barnett','Bremen','Bremen','2015-11-13'),
38 (22,'Kay Walsh','Leipzig','Saxony','2015-09-18'),
39 (23,'Erasmus Harris','Limburg a.d. Lahn','Hesse','2017-03-29'),
40 (24,'Nichole Bullock','Hamburg','Hamburg','2017-08-15'),
41 (25,'Serina Washington','Bremen','Bremen','2017-10-04'),
42 (26,'Colleen Kaufman','Eberswalde-Finow','Brandenburg','2015-04-30'),
43 (27,'Hilary Arnold','Schweinfurt','Bavaria','2015-04-14'),
44 (28,'Diana Workman','Berlin','Berlin','2017-05-01'),
45 (29,'Elizabeth Calhoun','Berlin','Berlin','2017-11-11'),
46 (30,'Darius William','Hamburg','Hamburg','2016-08-26'),
47 (31,'Latifah Clay','Bremerhaven','Bremen','2017-09-15'),
48 (32,'Chancellor Shaw','Hamburg','Hamburg','2016-03-15'),
49 (33,'Caldwell Newton','Berlin','Berlin','2015-04-21'),
50 (34,'Iona Keller','Hamburg','Hamburg','2017-11-25'),
51 (35,'Winter Brown','Hamburg','Hamburg','2015-09-12'),
52 (36,'Beck Leach','Berlin','Berlin','2015-02-25'),
53 (37,'Julian Bowen','Berlin','Berlin','2017-11-28'),
54 (38,'Owen Mcclain','Berlin','Berlin','2015-03-24'),
55 (39,'Jaquelyn Melendez','Hamburg','Hamburg','2015-10-01'),
56 (40,'Xandra Wilcox','Hamburg','Hamburg','2016-03-04'),
57 (41,'Igor Nolan','Berlin','Berlin','2015-08-16'),
58 (42,'Gil Brown','Völklingen','Saarland','2015-02-19'),
59 (43,'Brielle Bright','Berlin','Berlin','2016-07-18'),
60 (44,'Whilemina Bell','Berlin','Berlin','2017-09-16'),
61 (45,'Bell Barber','Berlin','Berlin','2015-09-04'),
62 (46,'Warren Skinner','Bremen','Bremen','2016-05-08'),
63 (47,'Alice Franklin','Berlin','Berlin','2015-06-29'),
64 (48,'Hillary Park','Bremen','Bremen','2015-10-05'),
65 (49,'Hilary Colon','Worms','Rhineland-Palatinate','2016-03-30'),
66 (50,'Graham Singleton','Hamburg','Hamburg','2015-03-31'),
67 (51,'Charity Pena','Aachen','North Rhine-Westphalia','2015-01-03'),
68 (52,'Judah Ochoa','Berlin','Berlin','2017-10-08'),
69 (53,'Medge Jackson','Hamburg','Hamburg','2017-07-25'),
70 (54,'Jermaine Holland','Sulzbach','Saarland','2015-03-26'),
71 (55,'Daria Lester','Bremen','Bremen','2016-12-02'),
72 (56,'Tamara Greene','Wuppertal','North Rhine-Westphalia','2016-08-01'),
73 (57,'Kellie Forbes','Berlin','Berlin','2015-04-13'),
74 (58,'Chava Galloway','Berlin','Berlin','2016-08-23'),
75 (59,'Graiden Barry','Taunusstein','Hesse','2015-05-05'),
76 (60,'Emery Coffey','Hamburg','Hamburg','2016-03-26'),
77 (61,'Malachi Holman','Quickborn','Saarland','2015-04-04'),
78 (62,'Cora Giles','Hamburg','Hamburg','2016-01-21'),
79 (63,'Libby Walsh','Bottrop','North Rhine-Westphalia','2017-01-14'),
80 (64,'Hamish Beck','Hamburg','Hamburg','2017-05-26'),
81 (65,'Halla Greer','Hamburg','Hamburg','2015-12-02'),
82 (66,'Imelda Blair','Hamburg','Hamburg','2016-05-07'),
83 (67,'Petra Wong','Berlin','Berlin','2015-11-12'),
84 (68,'Dara Weber','Solingen','North Rhine-Westphalia','2017-11-08'),
85 (69,'Jenna Petty','Bremerhaven','Bremen','2015-05-11'),
86 (70,'Georgia Schultz','Bremen','Bremen','2016-01-09'),
87 (71,'Camille Owen','Bad Kreuznach','Rhineland-Palatinate','2016-11-12'),
88 (72,'Burke Barlow','Flensburg','Saarland','2015-01-07'),
89 (73,'Rhona Hickman','Bremerhaven','Bremen','2017-08-04'),
90 (74,'Cedric Conway','Berlin','Berlin','2016-05-10'),
91 (75,'Josephine Rowland','Baden-Baden','Baden','2015-07-16'),
92 (76,'Vivien Dickerson','Völklingen','Saarland','2016-03-14'),
93 (77,'Cassady Brown','Hamburg','Hamburg','2015-04-29'),
94 (78,'Valentine Mills','Hamburg','Hamburg','2017-03-24'),
95 (79,'Lani Duncan','Geesthacht','Saarland','2016-09-08'),
96 (80,'Mark Trujillo','Berlin','Berlin','2016-12-02'),
97 (81,'Brennan Carroll','Bremerhaven','Bremen','2017-12-26'),
98 (82,'Irma Browning','Berlin','Berlin','2017-08-18'),
99 (83,'Tyrone Mays','Geesthacht','Saarland','2015-07-31'),
100 (84,'Candace Hines','Leipzig','Saxony','2015-11-30'),
101 (85,'Jason Fletcher','Berlin','Berlin','2015-11-06'),
102 (86,'Vanna Ferrell','Aalen','Baden','2016-06-07'),
103 (87,'Ava Griffin','Hamburg','Hamburg','2015-12-18'),
104 (88,'Jamalia Guerrero','Berlin','Berlin','2015-05-22'),
105 (89,'Donovan Dalton','Berlin','Berlin','2016-02-28'),
106 (90,'Perry Mcfarland','Freiburg','Baden','2016-06-05'),
107 (91,'Deacon Small','Konstanz','Baden','2015-02-16'),
108 (92,'Emerson Lane','Bremerhaven','Bremen','2015-08-08'),
109 (93,'Alec Joseph','Hamburg','Hamburg','2017-01-27'),
110 (94,'Ulysses Hoover','Berlin','Berlin','2017-11-05'),
111 (95,'Carl Beasley','Bremen','Bremen','2017-07-31'),
112 (96,'Tatyana Turner','Berlin','Berlin','2016-03-26'),
113 (97,'Jael Cervantes','Hamburg','Hamburg','2017-09-28'),
114 (98,'Remedios Taylor','Staßfurt','Saxony-Anhalt','2016-01-26'),
115 (99,'Erica Rocha','Hamburg','Hamburg','2016-11-25'),
116 (100,'Joelle Rodgers','Eckernförde','Saarland','2017-01-22')
117);
118
119CREATE TABLE IF NOT EXISTS products (
120 id integer,
121 name text,
122 price numeric
123);
124
125INSERT INTO products (id, name, price) (
126 VALUES
127 (1, 'watch', 55.55),
128 (2, 'book', 15.05),
129 (3, 'whiskey', 75.24)
130);
131
132SELECT * FROM products;
133
134CREATE TABLE IF NOT EXISTS orders (
135 id integer,
136 created_at date,
137 quantity integer,
138 customer_id integer,
139 product_id integer
140);
141
142INSERT INTO orders (id, customer_id, product_id, quantity, created_at) (
143 values
144 (1,85,3,1,'2015-05-04'),
145 (2,83,2,5,'2015-10-12'),
146 (3,30,2,3,'2015-06-27'),
147 (4,27,1,6,'2015-02-12'),
148 (5,62,3,9,'2015-12-05'),
149 (6,29,2,2,'2015-01-15'),
150 (7,3,1,2,'2015-06-14'),
151 (8,17,3,8,'2015-04-19'),
152 (9,57,1,5,'2015-09-27'),
153 (10,81,2,8,'2015-12-28'),
154 (11,44,1,7,'2015-09-30'),
155 (12,75,2,1,'2015-09-17'),
156 (13,73,2,8,'2015-03-23'),
157 (14,41,2,3,'2015-03-31'),
158 (15,9,2,8,'2015-07-24'),
159 (16,33,2,2,'2015-12-26'),
160 (17,20,3,6,'2015-12-13'),
161 (18,6,2,1,'2015-07-07'),
162 (19,35,2,9,'2015-12-29'),
163 (20,94,2,8,'2015-01-20'),
164 (21,98,3,2,'2015-11-23'),
165 (22,38,1,3,'2015-11-21'),
166 (23,95,2,7,'2015-08-22'),
167 (24,89,2,8,'2015-03-07'),
168 (25,74,1,8,'2015-04-14'),
169 (26,79,3,4,'2015-03-09'),
170 (27,30,2,7,'2015-11-12'),
171 (28,63,1,1,'2015-04-04'),
172 (29,89,2,8,'2015-10-21'),
173 (30,29,2,10,'2015-02-16'),
174 (31,52,2,8,'2015-03-20'),
175 (32,13,3,4,'2015-01-27'),
176 (33,41,2,9,'2015-01-21'),
177 (34,24,2,5,'2015-10-02'),
178 (35,59,2,3,'2015-07-06'),
179 (36,80,1,5,'2015-03-16'),
180 (37,66,2,2,'2015-03-14'),
181 (38,52,2,7,'2015-11-27'),
182 (39,72,1,8,'2015-05-19'),
183 (40,67,3,4,'2015-04-19'),
184 (41,39,1,1,'2015-10-06'),
185 (42,89,2,3,'2015-10-22'),
186 (43,33,1,7,'2015-05-23'),
187 (44,70,2,5,'2015-11-16'),
188 (45,9,2,8,'2015-07-16'),
189 (46,86,3,5,'2015-08-09'),
190 (47,90,2,10,'2015-08-09'),
191 (48,49,2,4,'2015-10-01'),
192 (49,79,1,9,'2015-11-21'),
193 (50,96,2,5,'2015-03-06'),
194 (51,96,2,7,'2015-12-06'),
195 (52,6,2,7,'2015-11-05'),
196 (53,60,3,10,'2015-11-13'),
197 (54,60,2,4,'2015-02-22'),
198 (55,28,1,8,'2015-09-18'),
199 (56,17,2,2,'2015-10-12'),
200 (57,83,2,4,'2015-12-14'),
201 (58,51,3,8,'2015-05-23'),
202 (59,1,1,5,'2015-08-15'),
203 (60,76,1,6,'2015-02-03'),
204 (61,45,2,4,'2015-10-29'),
205 (62,54,3,3,'2015-07-05'),
206 (63,50,3,10,'2015-03-03'),
207 (64,58,2,1,'2015-12-05'),
208 (65,27,1,6,'2015-12-06'),
209 (66,84,2,3,'2015-04-17'),
210 (67,36,2,6,'2015-12-21'),
211 (68,80,2,4,'2015-04-12'),
212 (69,5,2,2,'2015-05-07'),
213 (70,61,2,2,'2015-07-18'),
214 (71,43,2,6,'2015-10-03'),
215 (72,37,3,2,'2015-12-26'),
216 (73,66,2,2,'2015-09-01'),
217 (74,65,1,4,'2015-04-05'),
218 (75,55,1,1,'2015-01-25'),
219 (76,17,1,4,'2015-07-08'),
220 (77,42,1,2,'2015-07-09'),
221 (78,24,1,9,'2015-12-18'),
222 (79,5,1,8,'2015-12-26'),
223 (80,39,2,4,'2015-07-03'),
224 (81,34,1,2,'2015-09-07'),
225 (82,91,1,7,'2015-06-30'),
226 (83,43,2,6,'2015-09-12'),
227 (84,34,1,6,'2015-05-29'),
228 (85,6,2,2,'2015-04-19'),
229 (86,3,2,4,'2015-06-23'),
230 (87,74,1,7,'2015-11-01'),
231 (88,53,3,6,'2015-04-15'),
232 (89,33,1,3,'2015-04-24'),
233 (90,59,1,7,'2015-03-10'),
234 (91,70,2,10,'2015-07-03'),
235 (92,13,2,6,'2015-10-24'),
236 (93,100,1,6,'2015-02-06'),
237 (94,58,3,10,'2015-11-24'),
238 (95,78,2,6,'2015-12-04'),
239 (96,50,2,9,'2015-08-02'),
240 (97,37,2,2,'2015-08-12'),
241 (98,45,2,1,'2015-03-22'),
242 (99,24,2,5,'2015-07-10'),
243 (100,19,3,3,'2015-10-04'),
244 (101,8,1,2,'2015-03-29'),
245 (102,30,1,8,'2015-08-26'),
246 (103,15,1,7,'2015-03-03'),
247 (104,77,1,4,'2015-12-30'),
248 (105,25,3,8,'2015-11-25'),
249 (106,98,1,8,'2015-01-26'),
250 (107,35,2,7,'2015-09-11'),
251 (108,19,1,6,'2015-07-18'),
252 (109,60,2,10,'2015-10-16'),
253 (110,33,1,5,'2015-05-16'),
254 (111,37,3,5,'2015-10-31'),
255 (112,38,2,2,'2015-12-20'),
256 (113,59,1,8,'2015-08-09'),
257 (114,28,2,2,'2015-07-05'),
258 (115,92,3,2,'2015-06-22'),
259 (116,37,1,9,'2015-03-22'),
260 (117,40,1,2,'2015-05-26'),
261 (118,4,3,7,'2015-12-19'),
262 (119,45,1,6,'2015-09-14'),
263 (120,84,1,5,'2015-07-03'),
264 (121,4,2,5,'2015-07-16'),
265 (122,66,1,5,'2015-09-10'),
266 (123,10,1,3,'2015-12-10'),
267 (124,18,2,9,'2015-04-05'),
268 (125,84,2,4,'2015-12-25'),
269 (126,71,2,6,'2015-05-10'),
270 (127,85,3,1,'2015-05-04'),
271 (128,30,1,9,'2015-02-05'),
272 (129,50,1,5,'2015-08-11'),
273 (130,73,2,1,'2015-08-29'),
274 (131,78,2,2,'2015-06-27'),
275 (132,5,2,6,'2015-06-21'),
276 (133,75,3,8,'2015-04-24'),
277 (134,15,1,8,'2015-11-05'),
278 (135,33,2,7,'2015-04-16'),
279 (136,53,2,1,'2015-03-23'),
280 (137,81,2,5,'2015-12-30'),
281 (138,8,1,4,'2015-12-22'),
282 (139,6,2,2,'2015-06-28'),
283 (140,10,3,3,'2015-04-11'),
284 (141,35,2,4,'2015-08-31'),
285 (142,66,2,5,'2015-01-25'),
286 (143,4,2,6,'2015-09-14'),
287 (144,16,3,9,'2015-04-21'),
288 (145,74,3,2,'2015-05-19'),
289 (146,44,2,1,'2015-02-02'),
290 (147,99,2,5,'2015-06-14'),
291 (148,14,3,6,'2015-06-24'),
292 (149,65,1,4,'2015-12-15'),
293 (150,19,2,6,'2015-08-11'),
294 (151,96,1,8,'2015-06-22'),
295 (152,5,1,4,'2015-03-14'),
296 (153,30,2,2,'2015-07-16'),
297 (154,86,1,7,'2015-05-15'),
298 (155,60,1,6,'2015-07-03'),
299 (156,59,3,6,'2015-10-02'),
300 (157,33,3,4,'2015-11-21'),
301 (158,15,2,2,'2015-02-27'),
302 (159,88,3,2,'2015-11-07'),
303 (160,72,2,1,'2015-03-22'),
304 (161,40,3,4,'2015-10-01'),
305 (162,21,2,1,'2015-09-02'),
306 (163,10,1,6,'2015-03-16'),
307 (164,74,1,7,'2015-07-08'),
308 (165,49,2,6,'2015-07-09'),
309 (166,36,1,10,'2015-09-14'),
310 (167,62,2,3,'2015-09-08'),
311 (168,60,1,2,'2015-03-18'),
312 (169,83,1,1,'2015-09-11'),
313 (170,35,1,9,'2015-09-03'),
314 (171,68,2,7,'2015-02-28'),
315 (172,76,1,8,'2015-09-19'),
316 (173,30,2,3,'2015-03-17'),
317 (174,10,2,2,'2015-02-25'),
318 (175,80,2,2,'2015-07-18'),
319 (176,23,1,7,'2015-02-03'),
320 (177,25,1,4,'2015-07-22'),
321 (178,40,2,5,'2015-04-14'),
322 (179,41,1,9,'2015-10-07'),
323 (180,81,3,10,'2015-12-11'),
324 (181,22,1,4,'2015-03-16'),
325 (182,22,1,3,'2015-12-17'),
326 (183,95,2,7,'2015-01-28'),
327 (184,87,3,1,'2015-06-03'),
328 (185,65,2,6,'2015-07-27'),
329 (186,58,2,5,'2015-08-07'),
330 (187,15,1,9,'2015-05-22'),
331 (188,40,2,2,'2015-05-15'),
332 (189,20,2,4,'2015-07-05'),
333 (190,83,1,4,'2015-10-07'),
334 (191,43,3,6,'2015-08-05'),
335 (192,70,2,2,'2015-11-05'),
336 (193,69,1,10,'2015-08-15'),
337 (194,11,2,4,'2015-05-21'),
338 (195,47,1,6,'2015-07-26'),
339 (196,69,2,6,'2015-05-14'),
340 (197,14,2,4,'2015-11-08'),
341 (198,36,1,10,'2015-06-15'),
342 (199,49,1,7,'2015-10-14'),
343 (200,91,2,9,'2015-04-30'),
344 (201,9,2,1,'2015-04-25'),
345 (202,61,3,5,'2015-10-23'),
346 (203,95,2,2,'2015-09-24'),
347 (204,90,3,1,'2015-11-13'),
348 (205,11,2,3,'2015-07-28'),
349 (206,11,1,4,'2015-07-23'),
350 (207,68,2,9,'2015-10-03'),
351 (208,52,1,1,'2015-09-23'),
352 (209,26,2,1,'2015-07-15'),
353 (210,59,2,9,'2015-05-26'),
354 (211,40,2,8,'2015-02-25'),
355 (212,60,3,9,'2015-10-18'),
356 (213,27,3,2,'2015-07-21'),
357 (214,43,2,9,'2015-10-09'),
358 (215,98,1,6,'2015-03-03'),
359 (216,67,2,2,'2015-08-20'),
360 (217,42,3,7,'2015-11-01'),
361 (218,32,2,2,'2015-10-22'),
362 (219,14,1,8,'2015-05-03'),
363 (220,23,2,3,'2015-07-09'),
364 (221,83,1,2,'2015-12-10'),
365 (222,77,2,4,'2015-10-30'),
366 (223,79,1,1,'2015-04-25'),
367 (224,83,2,10,'2015-08-30'),
368 (225,72,3,1,'2015-02-23'),
369 (226,53,2,8,'2015-09-18'),
370 (227,35,2,2,'2015-06-03'),
371 (228,95,2,3,'2015-05-11'),
372 (229,61,2,6,'2015-04-30'),
373 (230,52,2,3,'2015-05-24'),
374 (231,55,2,6,'2015-10-26'),
375 (232,32,2,1,'2015-08-06'),
376 (233,2,3,5,'2015-02-08'),
377 (234,11,2,6,'2015-05-25'),
378 (235,44,2,1,'2015-02-23'),
379 (236,65,2,2,'2015-12-08'),
380 (237,72,2,6,'2015-03-09'),
381 (238,65,3,5,'2015-09-12'),
382 (239,76,3,9,'2015-04-18'),
383 (240,44,2,6,'2015-04-08'),
384 (241,93,2,6,'2015-06-19'),
385 (242,51,1,4,'2015-09-24'),
386 (243,82,2,3,'2015-06-10'),
387 (244,58,2,4,'2015-10-03'),
388 (245,80,1,8,'2015-07-28'),
389 (246,41,2,8,'2015-08-24'),
390 (247,29,2,5,'2015-04-07'),
391 (248,37,2,6,'2015-10-19'),
392 (249,82,2,6,'2015-10-04'),
393 (250,7,1,3,'2015-09-01')
394 )