· 7 years ago · Feb 16, 2019, 04:18 PM
1BEGIN TRANSACTION;
2CREATE TABLE IF NOT EXISTS "titles" (
3 "ID" INTEGER,
4 "title" TEXT,
5 "authorID" INTEGER
6);
7CREATE TABLE IF NOT EXISTS "books" (
8 "ID" INTEGER,
9 "titleID" INTEGER,
10 "registration_date" TEXT
11);
12CREATE TABLE IF NOT EXISTS "authors" (
13 "ID" INTEGER,
14 "surname" TEXT,
15 "name" TEXT
16);
17INSERT INTO "titles" ("ID","title","authorID") VALUES (1,'Solaris',1),
18 (2,'Cyberiada',1),
19 (3,'Katar',1),
20 (4,'Bajki robotów',1),
21 (5,'Opowieści o Pilocie Pirxie',1),
22 (6,'Rękopis znaleziony w wannie',1),
23 (7,'Dzienniki gwiazdowe',1),
24 (8,'Eden',1),
25 (9,'Åšledztwo',1),
26 (10,'Powrót z gwiazd',1),
27 (11,'Niezwyciężony',1),
28 (12,'Wysoki zamek',1),
29 (13,'Głos Pana',1),
30 (14,'Pożytek ze smoka',1),
31 (15,'Sknocony kryminał',1),
32 (16,'Mars',2),
33 (17,'Kameleon',2),
34 (18,'Vertical',2),
35 (19,'Różaniec',2),
36 (20,'Obywatel który się zawiesił',2),
37 (21,'Pamiętniki z okresu dojrzewania',3),
38 (22,'Ferdydurke',3),
39 (23,'Trans-Atlantyk',3),
40 (24,'Iwona księżniczka Burgunda',3),
41 (25,'Åšlub',3),
42 (26,'Operetka',3),
43 (27,'Bakakaj',3),
44 (28,'Tango',4),
45 (29,'Emigranci',4),
46 (30,'Kynolog w rozterce',4),
47 (31,'Miłość na Krymie',4),
48 (32,'Wesele w Atomicach',4),
49 (33,'Lód',5),
50 (34,'Wrociec',5),
51 (35,'Perfekcyjna niedoskonałość',5),
52 (36,'Katedra',5),
53 (37,'Narrenturm',6),
54 (38,'Boży wojownicy',6),
55 (39,'Lux perpetua',6),
56 (40,'Rękopis znaleziony w smoczej jaskini',6);
57INSERT INTO "books" ("ID","titleID","registration_date") VALUES (1,1,'2002-01-30'),
58 (2,1,'1986-03-26'),
59 (3,1,'2017-03-02'),
60 (4,1,'2006-05-01'),
61 (5,1,'2018-08-04'),
62 (6,1,'1995-10-06'),
63 (7,1,'1972-06-30'),
64 (8,1,'2006-05-27'),
65 (9,1,'1973-06-16'),
66 (10,1,'1988-05-20'),
67 (11,1,'1996-10-16'),
68 (12,1,'1986-03-20'),
69 (13,1,'2004-11-01'),
70 (14,1,'2002-11-18'),
71 (15,1,'1979-06-17'),
72 (16,1,'1980-04-18'),
73 (17,1,'1987-01-13'),
74 (18,1,'1986-02-01'),
75 (19,1,'1981-02-21'),
76 (20,2,'2007-04-29'),
77 (21,3,'2001-12-24'),
78 (22,3,'2005-10-17'),
79 (23,3,'2003-10-08'),
80 (24,4,'2011-07-19'),
81 (25,4,'1994-07-07'),
82 (26,4,'1998-12-12'),
83 (27,4,'2003-09-05'),
84 (28,4,'1997-10-19'),
85 (29,4,'2016-02-23'),
86 (30,4,'1994-11-04'),
87 (31,4,'2014-04-02'),
88 (32,4,'2000-05-08'),
89 (33,4,'1979-02-21'),
90 (34,4,'2012-09-01'),
91 (35,5,'1989-04-24'),
92 (36,5,'2004-07-27'),
93 (37,5,'1980-05-19'),
94 (38,5,'1970-03-29'),
95 (39,5,'2015-11-11'),
96 (40,5,'1984-08-28'),
97 (41,6,'1982-12-13'),
98 (42,6,'1972-04-10'),
99 (43,6,'1973-10-22'),
100 (44,6,'2018-07-19'),
101 (45,6,'1999-02-13'),
102 (46,6,'1997-03-14'),
103 (47,6,'1998-12-05'),
104 (48,7,'2013-06-30'),
105 (49,7,'1980-10-16'),
106 (50,7,'1979-02-16'),
107 (51,7,'1977-10-15'),
108 (52,7,'2012-05-01'),
109 (53,7,'1980-11-05'),
110 (54,7,'1995-05-04'),
111 (55,7,'2009-06-11'),
112 (56,7,'2001-06-28'),
113 (57,7,'1994-05-05'),
114 (58,7,'2015-12-13'),
115 (59,7,'1990-09-19'),
116 (60,7,'1984-03-10'),
117 (61,7,'1980-10-24'),
118 (62,7,'1984-10-31'),
119 (63,7,'1976-06-12'),
120 (64,7,'2010-07-19'),
121 (65,7,'1986-08-08'),
122 (66,7,'2000-09-22'),
123 (67,7,'1990-01-05'),
124 (68,7,'1990-12-11'),
125 (69,7,'2013-09-16'),
126 (70,7,'1986-11-11'),
127 (71,7,'1976-09-05'),
128 (72,7,'2018-10-12'),
129 (73,7,'2007-01-25'),
130 (74,8,'2001-05-19'),
131 (75,8,'1991-12-21'),
132 (76,8,'1985-12-31'),
133 (77,9,'1983-07-13'),
134 (78,9,'2006-11-22'),
135 (79,9,'1983-10-19'),
136 (80,9,'1989-06-19'),
137 (81,9,'2009-07-06'),
138 (82,9,'1971-11-21'),
139 (83,9,'1993-07-04'),
140 (84,9,'1979-07-15'),
141 (85,9,'1991-01-29'),
142 (86,9,'1981-12-11'),
143 (87,9,'1989-05-16'),
144 (88,9,'2007-01-21'),
145 (89,9,'1997-10-22'),
146 (90,9,'2015-12-07'),
147 (91,9,'1975-04-26'),
148 (92,9,'2017-11-20'),
149 (93,9,'1972-10-18'),
150 (94,9,'2012-08-23'),
151 (95,9,'1972-01-27'),
152 (96,9,'1991-07-20'),
153 (97,9,'1996-05-10'),
154 (98,9,'1988-05-19'),
155 (99,9,'2006-10-22'),
156 (100,9,'1970-10-10'),
157 (101,9,'1987-05-16'),
158 (102,9,'1981-09-15'),
159 (103,9,'1977-06-16'),
160 (104,9,'1985-02-03'),
161 (105,10,'1992-03-08'),
162 (106,10,'1995-10-23'),
163 (107,10,'1991-08-05'),
164 (108,10,'2005-02-26'),
165 (109,10,'1998-11-25'),
166 (110,10,'1973-07-18'),
167 (111,10,'1996-11-16'),
168 (112,10,'2008-11-11'),
169 (113,10,'1974-09-04'),
170 (114,10,'1974-08-08'),
171 (115,10,'2000-10-08'),
172 (116,10,'1977-01-21'),
173 (117,10,'1976-04-01'),
174 (118,10,'1986-01-27'),
175 (119,10,'2008-02-20'),
176 (120,10,'1982-05-24'),
177 (121,10,'1999-05-19'),
178 (122,10,'2018-04-22'),
179 (123,10,'1999-02-03'),
180 (124,10,'1996-04-02'),
181 (125,10,'1996-09-20'),
182 (126,10,'2015-02-17'),
183 (127,10,'1998-11-22'),
184 (128,10,'1989-10-28'),
185 (129,10,'2003-10-02'),
186 (130,10,'1979-06-02'),
187 (131,11,'1972-03-11'),
188 (132,11,'1974-01-04'),
189 (133,11,'2017-06-10'),
190 (134,11,'1998-02-14'),
191 (135,11,'2015-07-03'),
192 (136,11,'1979-04-03'),
193 (137,11,'1980-02-05'),
194 (138,11,'1995-08-26'),
195 (139,11,'1982-04-04'),
196 (140,11,'2007-08-28'),
197 (141,11,'2017-11-06'),
198 (142,11,'1991-11-26'),
199 (143,11,'1991-11-23'),
200 (144,11,'1991-06-18'),
201 (145,11,'1983-08-10'),
202 (146,11,'1995-12-11'),
203 (147,11,'2000-02-29'),
204 (148,11,'2001-05-28'),
205 (149,11,'2002-01-03'),
206 (150,11,'1999-04-23'),
207 (151,12,'2014-02-14'),
208 (152,12,'1983-07-28'),
209 (153,12,'2006-07-19'),
210 (154,12,'2018-04-30'),
211 (155,12,'1976-06-08'),
212 (156,12,'2008-10-25'),
213 (157,12,'2011-05-09'),
214 (158,12,'1973-06-24'),
215 (159,12,'2014-10-08'),
216 (160,12,'1979-11-16'),
217 (161,12,'1970-03-09'),
218 (162,12,'1980-08-03'),
219 (163,12,'2017-09-08'),
220 (164,12,'1991-11-11'),
221 (165,12,'2004-06-13'),
222 (166,12,'1973-12-04'),
223 (167,13,'1970-05-10'),
224 (168,13,'1985-04-01'),
225 (169,13,'2017-04-02'),
226 (170,13,'1970-09-11'),
227 (171,13,'2012-12-25'),
228 (172,13,'1999-10-21'),
229 (173,13,'1994-03-24'),
230 (174,13,'1978-08-24'),
231 (175,13,'2014-07-17'),
232 (176,13,'1975-11-17'),
233 (177,13,'1977-11-23'),
234 (178,13,'1985-11-22'),
235 (179,13,'2015-11-21'),
236 (180,13,'1988-04-21'),
237 (181,13,'2016-01-26'),
238 (182,13,'2018-02-03'),
239 (183,13,'1971-06-24'),
240 (184,13,'1980-05-22'),
241 (185,13,'1985-03-25'),
242 (186,13,'2015-09-11'),
243 (187,13,'1980-09-02'),
244 (188,13,'1973-06-22'),
245 (189,13,'1992-12-25'),
246 (190,13,'2008-05-25'),
247 (191,14,'1975-05-07'),
248 (192,14,'2018-02-08'),
249 (193,14,'2006-10-21'),
250 (194,14,'2000-11-03'),
251 (195,14,'2013-09-11'),
252 (196,14,'1978-02-09'),
253 (197,14,'1979-05-19'),
254 (198,14,'2004-05-10'),
255 (199,14,'2004-03-05'),
256 (200,14,'1980-02-18'),
257 (201,14,'1979-08-14'),
258 (202,14,'2018-11-22'),
259 (203,14,'2017-12-24'),
260 (204,14,'1996-06-07'),
261 (205,14,'1995-07-12'),
262 (206,14,'1977-08-01'),
263 (207,14,'1997-05-08'),
264 (208,14,'1980-06-23'),
265 (209,14,'2017-09-14'),
266 (210,14,'2001-02-27'),
267 (211,14,'1995-05-18'),
268 (212,14,'1975-06-03'),
269 (213,14,'1988-03-25'),
270 (214,15,'2015-11-19'),
271 (215,15,'1979-08-16'),
272 (216,15,'1974-02-17'),
273 (217,15,'2008-09-17'),
274 (218,15,'1994-09-30'),
275 (219,15,'2016-10-16'),
276 (220,15,'1980-03-21'),
277 (221,15,'1978-04-16'),
278 (222,15,'2017-08-24'),
279 (223,15,'1974-12-28'),
280 (224,15,'1993-01-24'),
281 (225,15,'2006-09-17'),
282 (226,15,'1976-08-06'),
283 (227,15,'2010-03-11'),
284 (228,15,'2014-06-24'),
285 (229,15,'1976-09-29'),
286 (230,15,'1996-08-18'),
287 (231,15,'2014-11-25'),
288 (232,15,'2012-01-24'),
289 (233,15,'2003-07-13'),
290 (234,15,'1980-02-18'),
291 (235,15,'1982-02-14'),
292 (236,16,'2004-05-23'),
293 (237,16,'2014-05-01'),
294 (238,16,'1984-09-09'),
295 (239,16,'2001-07-09'),
296 (240,16,'1975-05-18'),
297 (241,16,'1974-01-19'),
298 (242,16,'2000-06-21'),
299 (243,16,'1992-01-30'),
300 (244,16,'2010-04-05'),
301 (245,16,'2002-09-28'),
302 (246,16,'2018-06-07'),
303 (247,16,'1982-09-10'),
304 (248,16,'1991-04-11'),
305 (249,16,'2003-03-11'),
306 (250,16,'2009-06-10'),
307 (251,16,'1996-09-30'),
308 (252,17,'1991-11-15'),
309 (253,17,'1992-02-22'),
310 (254,17,'2011-03-07'),
311 (255,17,'1978-06-27'),
312 (256,17,'2018-06-23'),
313 (257,18,'2001-06-27'),
314 (258,18,'1993-04-15'),
315 (259,18,'2012-12-30'),
316 (260,18,'2016-09-05'),
317 (261,18,'1975-02-12'),
318 (262,18,'2002-06-07'),
319 (263,18,'1978-01-18'),
320 (264,18,'1989-07-19'),
321 (265,18,'1980-06-18'),
322 (266,18,'2017-10-09'),
323 (267,18,'2012-09-13'),
324 (268,18,'1979-12-28'),
325 (269,18,'1970-09-20'),
326 (270,18,'1992-01-26'),
327 (271,18,'1983-08-20'),
328 (272,18,'1994-07-24'),
329 (273,18,'1972-11-21'),
330 (274,18,'1992-02-10'),
331 (275,18,'2004-09-06'),
332 (276,18,'1995-07-02'),
333 (277,19,'2017-02-22'),
334 (278,19,'1996-02-16'),
335 (279,19,'1997-10-25'),
336 (280,19,'2013-09-20'),
337 (281,19,'2001-11-17'),
338 (282,19,'2001-07-08'),
339 (283,19,'2017-05-19'),
340 (284,19,'1977-10-02'),
341 (285,20,'2003-09-10'),
342 (286,20,'2016-06-03'),
343 (287,20,'2004-12-19'),
344 (288,20,'2000-08-11'),
345 (289,20,'1991-05-22'),
346 (290,20,'1978-04-11'),
347 (291,20,'1988-01-25'),
348 (292,20,'2004-01-20'),
349 (293,20,'2000-02-14'),
350 (294,20,'2009-02-21'),
351 (295,20,'1988-04-03'),
352 (296,20,'1995-08-15'),
353 (297,20,'2013-02-28'),
354 (298,20,'1975-03-23'),
355 (299,20,'1982-04-04'),
356 (300,20,'2000-11-24'),
357 (301,20,'1974-06-28'),
358 (302,20,'2018-08-01'),
359 (303,21,'1999-11-03'),
360 (304,21,'1975-04-09'),
361 (305,21,'1996-09-14'),
362 (306,21,'1977-09-23'),
363 (307,21,'2012-09-26'),
364 (308,21,'2018-07-02'),
365 (309,21,'1988-03-01'),
366 (310,21,'1987-01-16'),
367 (311,21,'2002-11-29'),
368 (312,21,'1979-06-05'),
369 (313,21,'2011-10-17'),
370 (314,22,'1980-08-19'),
371 (315,22,'1980-08-30'),
372 (316,22,'1995-06-29'),
373 (317,22,'1999-05-31'),
374 (318,22,'1991-02-14'),
375 (319,22,'1993-10-08'),
376 (320,22,'2001-06-01'),
377 (321,22,'1988-07-10'),
378 (322,22,'1982-04-20'),
379 (323,22,'1979-01-10'),
380 (324,22,'1972-04-07'),
381 (325,22,'2013-03-11'),
382 (326,22,'1985-08-05'),
383 (327,22,'1987-12-08'),
384 (328,22,'1997-06-25'),
385 (329,22,'2000-06-15'),
386 (330,22,'1980-09-28'),
387 (331,22,'1997-09-06'),
388 (332,22,'1977-11-09'),
389 (333,22,'1974-04-06'),
390 (334,22,'2013-05-09'),
391 (335,22,'2003-08-01'),
392 (336,22,'1994-10-27'),
393 (337,22,'1976-10-18'),
394 (338,22,'2018-04-23'),
395 (339,22,'1994-08-27'),
396 (340,22,'2017-05-01'),
397 (341,22,'1990-11-24'),
398 (342,22,'1990-12-30'),
399 (343,23,'1977-07-12'),
400 (344,23,'1989-10-17'),
401 (345,23,'2005-07-26'),
402 (346,23,'1983-01-13'),
403 (347,23,'2013-07-31'),
404 (348,23,'2003-09-24'),
405 (349,23,'1993-06-29'),
406 (350,23,'2003-10-09'),
407 (351,23,'2004-07-11'),
408 (352,23,'2008-11-26'),
409 (353,23,'2000-05-13'),
410 (354,23,'2006-04-12'),
411 (355,23,'1985-05-31'),
412 (356,23,'1998-06-26'),
413 (357,23,'1979-05-29'),
414 (358,23,'1988-09-30'),
415 (359,23,'1992-05-31'),
416 (360,23,'1977-06-07'),
417 (361,23,'1982-08-12'),
418 (362,23,'1990-10-21'),
419 (363,23,'2012-11-05'),
420 (364,24,'1988-02-13'),
421 (365,24,'2003-07-24'),
422 (366,24,'2002-05-25'),
423 (367,24,'1996-09-25'),
424 (368,24,'1971-10-11'),
425 (369,24,'1980-08-23'),
426 (370,24,'1991-07-27'),
427 (371,24,'2010-02-27'),
428 (372,24,'2015-09-25'),
429 (373,24,'1992-02-05'),
430 (374,24,'1997-11-29'),
431 (375,24,'1975-04-13'),
432 (376,24,'1996-10-27'),
433 (377,24,'1982-01-25'),
434 (378,25,'1982-09-19'),
435 (379,25,'2002-04-29'),
436 (380,25,'1987-12-03'),
437 (381,25,'1979-11-15'),
438 (382,26,'1974-08-12'),
439 (383,26,'2014-01-22'),
440 (384,26,'1988-09-13'),
441 (385,26,'1986-12-20'),
442 (386,26,'2003-03-04'),
443 (387,26,'1986-12-22'),
444 (388,26,'1982-05-21'),
445 (389,26,'1973-11-30'),
446 (390,26,'1977-04-04'),
447 (391,26,'1984-02-04'),
448 (392,26,'2012-06-29'),
449 (393,26,'1976-07-10'),
450 (394,26,'1993-12-09'),
451 (395,26,'1974-05-26'),
452 (396,26,'1994-06-14'),
453 (397,26,'2014-08-14'),
454 (398,26,'1981-07-07'),
455 (399,26,'1999-04-29'),
456 (400,26,'1990-01-31'),
457 (401,26,'1983-04-01'),
458 (402,27,'1972-05-05'),
459 (403,27,'1978-07-12'),
460 (404,27,'2002-12-04'),
461 (405,27,'1970-10-27'),
462 (406,27,'2008-10-03'),
463 (407,27,'2013-01-24'),
464 (408,27,'2015-04-15'),
465 (409,27,'1987-02-02'),
466 (410,27,'1994-10-29'),
467 (411,27,'2001-01-18'),
468 (412,27,'1990-01-05'),
469 (413,27,'1972-10-03'),
470 (414,27,'1995-01-30'),
471 (415,28,'1992-12-01'),
472 (416,28,'1983-12-12'),
473 (417,28,'2006-01-12'),
474 (418,28,'1985-11-23'),
475 (419,28,'1976-12-14'),
476 (420,28,'2013-05-11'),
477 (421,28,'1989-07-29'),
478 (422,28,'1987-01-08'),
479 (423,28,'1982-10-01'),
480 (424,28,'2005-03-03'),
481 (425,28,'2009-12-31'),
482 (426,28,'1981-06-10'),
483 (427,28,'1972-09-22'),
484 (428,28,'1971-08-10'),
485 (429,28,'1979-05-18'),
486 (430,28,'1976-03-06'),
487 (431,28,'1989-07-15'),
488 (432,28,'1996-03-13'),
489 (433,28,'1985-02-26'),
490 (434,28,'2017-03-29'),
491 (435,28,'1976-08-19'),
492 (436,28,'1970-01-28'),
493 (437,29,'2006-01-13'),
494 (438,29,'1970-12-20'),
495 (439,29,'1992-05-22'),
496 (440,29,'1975-11-02'),
497 (441,29,'1991-03-06'),
498 (442,29,'1987-07-06'),
499 (443,29,'1975-06-10'),
500 (444,29,'1995-10-10'),
501 (445,29,'1981-10-16'),
502 (446,29,'1971-03-29'),
503 (447,29,'1987-08-04'),
504 (448,29,'2015-11-06'),
505 (449,30,'1973-03-29'),
506 (450,30,'2009-09-27'),
507 (451,30,'1971-08-15'),
508 (452,30,'1986-09-02'),
509 (453,30,'1974-02-19'),
510 (454,31,'1979-04-23'),
511 (455,31,'2012-09-24'),
512 (456,31,'1972-07-27'),
513 (457,31,'2016-09-15'),
514 (458,31,'1983-07-07'),
515 (459,31,'2001-06-19'),
516 (460,31,'1979-09-07'),
517 (461,31,'1976-04-14'),
518 (462,31,'1988-12-19'),
519 (463,31,'1981-12-09'),
520 (464,31,'2006-02-08'),
521 (465,31,'1983-04-25'),
522 (466,32,'1987-03-16'),
523 (467,32,'1983-04-10'),
524 (468,32,'1991-07-16'),
525 (469,32,'1982-03-14'),
526 (470,32,'1977-11-08'),
527 (471,32,'1999-09-05'),
528 (472,32,'1980-04-16'),
529 (473,32,'1988-03-21'),
530 (474,32,'1972-06-21'),
531 (475,32,'2012-12-10'),
532 (476,33,'1988-12-18'),
533 (477,33,'1994-10-23'),
534 (478,33,'1996-02-20'),
535 (479,33,'1986-12-22'),
536 (480,33,'1987-07-20'),
537 (481,33,'1978-01-13'),
538 (482,33,'1979-12-01'),
539 (483,33,'2006-06-25'),
540 (484,33,'1976-08-09'),
541 (485,33,'2017-10-05'),
542 (486,33,'2003-11-07'),
543 (487,33,'1977-10-09'),
544 (488,33,'2009-07-16'),
545 (489,33,'1978-10-11'),
546 (490,33,'1988-05-28'),
547 (491,33,'1990-12-21'),
548 (492,33,'1999-04-20'),
549 (493,33,'2014-02-08'),
550 (494,34,'1994-11-10'),
551 (495,34,'2014-01-31'),
552 (496,34,'2007-12-31'),
553 (497,34,'2017-12-30'),
554 (498,34,'2007-01-12'),
555 (499,34,'2003-04-28'),
556 (500,34,'2003-12-27'),
557 (501,34,'2012-04-16'),
558 (502,35,'1995-12-09'),
559 (503,35,'1975-12-10'),
560 (504,35,'2002-08-25'),
561 (505,35,'1993-09-08'),
562 (506,35,'1978-05-01'),
563 (507,35,'1995-11-01'),
564 (508,35,'1986-01-04'),
565 (509,35,'1988-03-23'),
566 (510,35,'1981-10-13'),
567 (511,35,'1993-04-01'),
568 (512,35,'1978-09-06'),
569 (513,35,'1974-08-22'),
570 (514,35,'2004-07-02'),
571 (515,35,'1974-05-12'),
572 (516,35,'2006-06-16'),
573 (517,35,'2007-08-08'),
574 (518,35,'1993-07-18'),
575 (519,35,'1984-12-03'),
576 (520,35,'2001-01-07'),
577 (521,35,'2006-05-22'),
578 (522,35,'1984-07-25'),
579 (523,35,'2015-06-12'),
580 (524,35,'1992-09-15'),
581 (525,35,'1994-01-03'),
582 (526,35,'1985-06-09'),
583 (527,35,'2010-12-07'),
584 (528,36,'1996-12-27'),
585 (529,36,'1981-02-04'),
586 (530,36,'1988-10-07'),
587 (531,36,'1971-05-17'),
588 (532,36,'2006-02-01'),
589 (533,36,'2000-12-09'),
590 (534,36,'1979-01-01'),
591 (535,36,'1986-01-14'),
592 (536,36,'1988-07-16'),
593 (537,36,'1974-10-07'),
594 (538,36,'1997-01-24'),
595 (539,36,'2007-06-15'),
596 (540,36,'1972-03-28'),
597 (541,36,'1979-02-07'),
598 (542,36,'1994-07-09'),
599 (543,36,'2015-11-09'),
600 (544,36,'1970-05-17'),
601 (545,36,'1976-05-04'),
602 (546,36,'1984-09-14'),
603 (547,36,'1975-07-24'),
604 (548,36,'1991-09-18'),
605 (549,36,'2006-06-30'),
606 (550,36,'1988-02-12'),
607 (551,36,'2006-10-09'),
608 (552,36,'1979-02-23'),
609 (553,37,'1980-01-22'),
610 (554,37,'1973-12-27'),
611 (555,37,'2015-10-05'),
612 (556,37,'1983-05-19'),
613 (557,37,'1986-03-25'),
614 (558,37,'2013-03-09'),
615 (559,37,'1970-04-12'),
616 (560,37,'2011-01-30'),
617 (561,37,'1971-08-20'),
618 (562,38,'1984-12-14'),
619 (563,38,'2016-12-12'),
620 (564,38,'1986-02-08'),
621 (565,38,'1984-10-09'),
622 (566,38,'2012-11-25'),
623 (567,38,'1992-04-28'),
624 (568,38,'2009-10-09'),
625 (569,38,'2002-02-15'),
626 (570,38,'1980-07-23'),
627 (571,38,'1982-06-09'),
628 (572,38,'2002-07-25'),
629 (573,38,'1972-11-27'),
630 (574,38,'1998-09-02'),
631 (575,38,'1988-03-05'),
632 (576,38,'1989-06-22'),
633 (577,38,'1987-11-20'),
634 (578,38,'2001-08-27'),
635 (579,38,'1984-12-13'),
636 (580,38,'2009-10-08'),
637 (581,38,'1971-04-19'),
638 (582,38,'2009-10-29'),
639 (583,38,'1986-04-19'),
640 (584,38,'1989-10-29'),
641 (585,38,'1988-05-30'),
642 (586,38,'2004-09-02'),
643 (587,38,'1971-10-07'),
644 (588,38,'2010-10-26'),
645 (589,39,'2002-04-11'),
646 (590,39,'1972-10-18'),
647 (591,39,'2008-07-03'),
648 (592,39,'1988-05-12'),
649 (593,39,'1982-11-14'),
650 (594,39,'1972-11-28'),
651 (595,39,'2011-05-07'),
652 (596,39,'1991-05-23'),
653 (597,39,'2007-08-07'),
654 (598,39,'1993-04-19'),
655 (599,39,'1994-05-12'),
656 (600,39,'1976-01-24'),
657 (601,39,'1998-10-16'),
658 (602,39,'1974-06-29'),
659 (603,39,'2008-06-27'),
660 (604,39,'2011-11-27'),
661 (605,39,'2004-06-03'),
662 (606,39,'1971-10-08'),
663 (607,39,'2006-01-06'),
664 (608,39,'1979-08-24'),
665 (609,39,'1999-07-26'),
666 (610,39,'1981-12-01'),
667 (611,39,'2008-11-06'),
668 (612,39,'2011-04-18'),
669 (613,40,'1992-09-28'),
670 (614,40,'1997-05-18'),
671 (615,40,'1996-10-08'),
672 (616,40,'2000-04-21'),
673 (617,40,'1970-08-31'),
674 (618,40,'1982-03-01'),
675 (619,40,'2017-06-19'),
676 (620,40,'1978-06-07'),
677 (621,40,'2015-12-15'),
678 (622,40,'2014-06-15'),
679 (623,40,'1990-03-12'),
680 (624,40,'2011-12-08'),
681 (625,40,'2003-11-11'),
682 (626,40,'1987-03-27'),
683 (627,40,'2009-06-05'),
684 (628,40,'2009-10-23'),
685 (629,40,'1996-03-14'),
686 (630,40,'1979-10-25'),
687 (631,40,'1975-09-10'),
688 (632,40,'1986-11-27'),
689 (633,40,'1986-10-15'),
690 (634,40,'2015-11-13'),
691 (635,40,'1999-09-28'),
692 (636,40,'1986-09-15');
693INSERT INTO "authors" ("ID","surname","name") VALUES (1,'Lem','Stanisław'),
694 (2,'Kosik','Rafał'),
695 (3,'Gombrowicz','Witold'),
696 (4,'Mrożek','Sławomir'),
697 (5,'Dukaj','Jacek'),
698 (6,'Sapkowki','Andrzej');
699COMMIT;