2021okt_erettsegi-sql

CREATE TABLE csapat (
  id int NOT NULL,
  csapatNev varchar(30) NOT NULL UNIQUE,
  CONSTRAINT pk_csapat
    PRIMARY KEY (id)
);

CREATE TABLE versenyzo (
  id int NOT NULL,
  nev varchar(30) NOT NULL UNIQUE,
  csapatId int NOT NULL,
  nemzetiseg varchar(3) NOT NULL,
  CONSTRAINT pk_versenyzo
    PRIMARY KEY (id),
  CONSTRAINT fk_csapat
    FOREIGN KEY (csapatId) REFERENCES csapat(id)
);

CREATE TABLE eredmeny (
  id int NOT NULL,
  versenyzoId int NOT NULL,
  szakasz int NOT NULL,
  ido time NOT NULL,
  CONSTRAINT pk_eredmeny
    PRIMARY KEY (id),
  CONSTRAINT fk_versenyzo
    FOREIGN KEY (versenyzoId) REFERENCES versenyzo(id)
);

INSERT INTO csapat VALUES
(1, 'ADRIA MOBIL'),
(2, 'ALPECIN - FENIX'),
(3, 'ANDRONI GIOCATTOLI - SIDERMEC'),
(4, 'BINGOAL WB'),
(5, 'CAJA RURAL - SEGUROS RGA'),
(6, 'CCC TEAM'),
(7, 'ELKOV - KASPER'),
(8, 'GIOTTI VICTORIA'),
(9, 'ISRAEL START - UP NATION'),
(10, 'JUMBO - VISMA'),
(11, 'KOMETA XSTRA CYCLING TEAM'),
(12, 'MITCHELTON - SCOTT'),
(13, 'NATIONAL TEAM OF HUNGARY'),
(14, 'SPORT VLAANDEREN - BALOISE'),
(15, 'TEAM NOVAK'),
(16, 'TEAM NOVO NORDISK'),
(17, 'TEAM VORARLBERG SANTIC'),
(18, 'TREK - SEGAFREDO'),
(19, 'UNO - X PRO CYCLING TEAM'),
(20, 'VINI ZABU KTM'),
(21, 'DECATHLON');

INSERT INTO versenyzo VALUES
(1, 'Badilatti Matteo', 9, 'SUI'),
(2, 'Barbier Rudy', 9, 'FRA'),
(3, 'Einhorn Itamar', 9, 'ISR'),
(4, 'Goldstein Omer', 9, 'ISR'),
(5, 'Piccoli James', 9, 'CAN'),
(6, 'Sutherland Rory', 9, 'AUS'),
(11, 'Gradek Kamil', 6, 'POL'),
(12, 'Malecki Kamil', 6, 'POL'),
(13, 'Mareczko Jakub', 6, 'ITA'),
(14, 'Valter Attila', 6, 'HUN'),
(15, 'Paluta Michal', 6, 'POL'),
(16, 'Wisniowski Lukasz', 6, 'POL'),
(21, 'Dina Márton', 11, 'HUN'),
(22, 'Verza Riccardo', 11, 'ITA'),
(23, 'Garavaglia Giacomo', 11, 'ITA'),
(24, 'Larsen Mathias Alexander E.', 11, 'DEN'),
(25, 'Gravalos Lopez Arturo', 11, 'ESP'),
(26, 'Sevilla Lopez Diego Pablo', 11, 'ESP'),
(31, 'Karl Ádám', 13, 'HUN'),
(32, 'Dina Dániel', 13, 'HUN'),
(33, 'Orosz Gergo', 13, 'HUN'),
(34, 'Istlstekker Zsolt', 13, 'HUN'),
(35, 'Szatmáry András', 13, 'HUN'),
(36, 'Palumby Zsombor', 13, 'HUN'),
(41, 'Groves Kaden', 12, 'AUS'),
(42, 'Edmondson Alexander', 12, 'AUS'),
(43, 'Durbridge Luke', 12, 'AUS'),
(44, 'Peák Barnabás', 12, 'HUN'),
(45, 'Howson Damien', 12, 'AUS'),
(46, 'Konychev Alexander', 12, 'ITA'),
(51, 'Clarke William', 18, 'AUS'),
(52, 'Kirsch Alex', 18, 'LUX'),
(53, 'Liepins Emils', 18, 'LAT'),
(54, 'Moschetti Matteo', 18, 'ITA'),
(55, 'Mullen Ryan', 18, 'IRL'),
(56, 'Simmons Quinn', 18, 'USA'),
(61, 'Bouwman Koen', 10, 'NED'),
(62, 'Foss Tobias S.', 10, 'NOR'),
(63, 'Hofstede Lennard', 10, 'NED'),
(64, 'Harper Chris', 10, 'AUS'),
(65, 'Lindeman Bert-Jan', 10, 'NED'),
(66, 'Tolhoek Antwan', 10, 'NED'),
(71, 'Kusztor Péter', 16, 'HUN'),
(72, 'Planet Charles', 16, 'FRA'),
(73, 'Peron Andrea', 16, 'ITA'),
(74, 'Henttala Joonas', 16, 'FIN'),
(75, 'Brand Sam', 16, 'GBR'),
(76, 'Lozano Riba David', 16, 'ESP'),
(81, 'Stacchiotti Riccardo', 20, 'ITA'),
(82, 'Mitri James', 20, 'NZL'),
(83, 'Gonzalez Roberto', 20, 'PAN'),
(84, 'Tortomasi Leonardo', 20, 'ITA'),
(85, 'Stojnic Veljko', 20, 'SRB'),
(86, 'Bongiorno Francesco Manuel', 20, 'ITA'),
(91, 'Pelikán János Zsombor', 3, 'HUN'),
(92, 'Bisolti Alessandro', 3, 'ITA'),
(93, 'Pacioni Luca', 3, 'ITA'),
(94, 'Rumac Josip', 3, 'CRO'),
(95, 'Rivera Serrano Kevin', 3, 'CRC'),
(96, 'Viel Mattia', 3, 'ITA'),
(101, 'Vandeputte Niels', 2, 'BEL'),
(102, 'Benoist Antoine', 2, 'FRA'),
(103, 'Meisen Marcel', 2, 'GER'),
(104, 'Rouiller Loris', 2, 'SUI'),
(105, 'Van Der Poel David', 2, 'NED'),
(106, 'Sweeck Diether', 2, 'BEL'),
(111, 'Hoelgaard Markus', 19, 'NOR'),
(112, 'Træen Torstein', 19, 'NOR'),
(113, 'Kulset Kristian', 19, 'NOR'),
(114, 'Sleen Torjus', 19, 'NOR'),
(115, 'Abrahamsen Jonas', 19, 'NOR'),
(116, 'Blikra Erlend', 19, 'NOR'),
(121, 'Huys Laurens', 4, 'BEL'),
(122, 'Mortier Julien', 4, 'BEL'),
(123, 'Nõmmela Aksel', 4, 'EST'),
(124, 'Rex Laurenz', 4, 'BEL'),
(125, 'Six Franklin', 4, 'BEL'),
(126, 'Vallee Boris', 4, 'BEL'),
(131, 'De Pestel Sander', 14, 'BEL'),
(132, 'De Wilde Gilles', 14, 'BEL'),
(133, 'Mertens Julian', 14, 'BEL'),
(134, 'Planckaert Emiel', 14, 'BEL'),
(135, 'Van Den Bossche Fabio', 14, 'BEL'),
(136, 'Weemaes Sasha', 14, 'BEL'),
(141, 'Aberasturi Izaga Jon', 5, 'ESP'),
(142, 'Garcia Susa Jhojan Orlando', 5, 'COL'),
(143, 'Osorio Carvajal Alejandro', 5, 'COL'),
(144, 'Rodriguez Martin Cristian', 5, 'ESP'),
(145, 'Urbano Fontiveros Carmelo', 5, 'ESP'),
(146, 'Cañellas Sanchez Xavier', 5, 'ESP');

INSERT INTO versenyzo VALUES
(151, 'Novak Carol-Eduard', 15, 'ROU'),
(152, 'Wermeser Zsombor', 15, 'HUN'),
(153, 'Dementyev Yehor', 15, 'UKR'),
(154, 'Sanò Simone', 15, 'ITA'),
(155, 'Rózsa Balázs', 15, 'HUN'),
(156, 'Szentpéteri András', 15, 'HUN'),
(161, 'Brajkovic Janez', 1, 'SLO'),
(162, 'Kump Marko', 1, 'SLO'),
(163, 'Hocevar Kristjan', 1, 'SLO'),
(164, 'Katrašnik Gašper', 1, 'SLO'),
(165, 'Per David', 1, 'SLO'),
(166, 'Horvat Žiga', 1, 'SLO'),
(171, 'Filutás Viktor', 8, 'HUN'),
(172, 'Szarka Gergely', 8, 'HUN'),
(173, 'Guardini Andrea', 8, 'ITA'),
(174, 'Dima Emil', 8, 'ROU'),
(175, 'Jitaru Ciprian Ioan', 8, 'ROU'),
(181, 'Thalmann Roland', 17, 'SUI'),
(182, 'Stüssi Colin Chris', 17, 'SUI'),
(183, 'Guerin Alexis', 17, 'FRA'),
(184, 'Meiler Lukas', 17, 'GER'),
(185, 'Kuen Maximilian', 17, 'AUT'),
(186, 'Meiler Martin', 17, 'GER'),
(191, 'Zahálka Matej', 7, 'CZE'),
(192, 'Hník Karel', 7, 'CZE'),
(193, 'Kankovský Alois', 7, 'CZE'),
(194, 'Kukrle Michael', 7, 'CZE'),
(195, 'Schlegel Michal', 7, 'CZE'),
(196, 'Toupalík Adam', 7, 'CZE');

INSERT INTO eredmeny VALUES
(1, 141, 1, '02:48:04'),
(2, 41, 1, '02:48:04'),
(3, 196, 1, '02:48:04'),
(4, 11, 1, '02:48:04'),
(5, 105, 1, '02:48:04'),
(6, 3, 1, '02:48:04'),
(7, 26, 1, '02:48:04'),
(8, 123, 1, '02:48:04'),
(9, 81, 1, '02:48:04'),
(10, 111, 1, '02:48:04'),
(11, 72, 1, '02:48:04'),
(12, 182, 1, '02:48:04'),
(13, 135, 1, '02:48:04'),
(14, 61, 1, '02:48:04'),
(15, 62, 1, '02:48:04'),
(16, 56, 1, '02:48:04'),
(17, 45, 1, '02:48:04'),
(18, 16, 1, '02:48:04'),
(19, 21, 1, '02:48:04'),
(20, 112, 1, '02:48:04'),
(21, 66, 1, '02:48:04'),
(22, 125, 1, '02:48:04'),
(23, 4, 1, '02:48:04'),
(24, 83, 1, '02:48:04'),
(25, 86, 1, '02:48:04'),
(26, 55, 1, '02:48:04'),
(27, 94, 1, '02:48:04'),
(28, 14, 1, '02:48:04'),
(29, 76, 1, '02:48:04'),
(30, 121, 1, '02:48:04'),
(31, 131, 1, '02:48:04'),
(32, 181, 1, '02:48:04'),
(33, 192, 1, '02:48:04'),
(34, 1, 1, '02:48:04'),
(35, 103, 1, '02:48:04'),
(36, 144, 1, '02:48:04'),
(37, 5, 1, '02:48:04'),
(38, 165, 1, '02:48:04'),
(39, 73, 1, '02:48:04'),
(40, 133, 1, '02:48:04'),
(41, 195, 1, '02:48:04'),
(42, 194, 1, '02:48:04'),
(43, 132, 1, '02:48:04'),
(44, 115, 1, '02:48:04'),
(45, 113, 1, '02:48:04'),
(46, 46, 1, '02:48:04'),
(47, 183, 1, '02:48:04'),
(48, 25, 1, '02:48:04'),
(49, 75, 1, '02:48:04'),
(50, 71, 1, '02:48:04'),
(51, 161, 1, '02:48:04'),
(52, 166, 1, '02:48:04'),
(53, 84, 1, '02:48:04'),
(54, 92, 1, '02:48:04'),
(55, 163, 1, '02:48:04'),
(56, 142, 1, '02:48:04'),
(57, 35, 1, '02:48:04'),
(58, 43, 1, '02:48:04'),
(59, 114, 1, '02:48:04'),
(60, 65, 1, '02:48:04'),
(61, 6, 1, '02:49:38'),
(62, 104, 1, '02:49:41'),
(63, 23, 1, '02:49:48'),
(64, 64, 1, '02:48:04'),
(65, 51, 1, '02:50:08'),
(66, 171, 1, '02:50:12'),
(67, 15, 1, '02:48:04'),
(68, 102, 1, '02:50:21'),
(69, 63, 1, '02:48:04');
INSERT INTO eredmeny VALUES
(70, 134, 1, '02:48:04'),
(71, 31, 1, '02:50:37'),
(72, 95, 1, '02:50:40'),
(73, 2, 1, '02:50:58'),
(74, 101, 1, '02:53:28'),
(75, 164, 1, '02:53:28'),
(76, 146, 1, '02:53:28'),
(77, 44, 1, '02:53:28'),
(78, 22, 1, '02:53:28'),
(79, 85, 1, '02:53:28'),
(80, 42, 1, '02:53:28'),
(81, 52, 1, '02:53:28'),
(82, 122, 1, '02:55:08'),
(83, 156, 1, '02:55:08'),
(84, 153, 1, '02:55:08'),
(85, 173, 1, '02:55:08'),
(86, 91, 1, '02:55:08'),
(87, 93, 1, '02:55:08'),
(88, 185, 1, '02:55:08'),
(89, 82, 1, '02:56:07'),
(90, 96, 1, '02:56:08'),
(91, 172, 1, '02:56:08'),
(92, 155, 1, '02:56:08'),
(93, 174, 1, '02:56:08'),
(94, 184, 1, '02:56:08'),
(95, 191, 1, '02:57:33'),
(96, 136, 1, '02:57:33'),
(97, 74, 1, '02:57:33'),
(98, 145, 1, '02:57:33'),
(99, 162, 1, '02:57:33'),
(100, 24, 1, '02:57:33'),
(101, 36, 1, '02:58:40'),
(102, 53, 1, '02:58:43'),
(103, 186, 1, '02:58:43'),
(104, 106, 1, '02:58:43'),
(105, 154, 1, '03:00:59'),
(106, 33, 1, '03:01:18'),
(107, 13, 1, '03:01:19'),
(108, 54, 1, '03:01:19'),
(109, 143, 1, '03:01:19'),
(110, 193, 1, '03:01:19'),
(111, 126, 1, '03:01:19'),
(112, 124, 1, '03:01:19'),
(113, 116, 1, '03:01:47'),
(114, 12, 1, '02:48:04');
INSERT INTO eredmeny VALUES
(115, 13, 2, '03:38:20'),
(116, 54, 2, '03:38:20'),
(117, 93, 2, '03:38:20'),
(118, 173, 2, '03:38:20'),
(119, 3, 2, '03:38:20'),
(120, 46, 2, '03:38:20'),
(121, 193, 2, '03:38:20'),
(122, 53, 2, '03:38:20'),
(123, 2, 2, '03:38:20'),
(124, 116, 2, '03:38:20'),
(125, 105, 2, '03:38:20'),
(126, 136, 2, '03:38:20'),
(127, 123, 2, '03:38:20'),
(128, 31, 2, '03:38:20'),
(129, 73, 2, '03:38:20'),
(130, 146, 2, '03:38:20'),
(131, 23, 2, '03:38:20'),
(132, 124, 2, '03:38:20'),
(133, 33, 2, '03:38:20'),
(134, 81, 2, '03:38:20'),
(135, 131, 2, '03:38:20'),
(136, 71, 2, '03:38:20'),
(137, 21, 2, '03:38:20'),
(138, 41, 2, '03:38:20'),
(139, 111, 2, '03:38:20'),
(140, 16, 2, '03:38:20'),
(141, 52, 2, '03:38:20'),
(142, 55, 2, '03:38:20'),
(143, 14, 2, '03:38:20'),
(144, 4, 2, '03:38:20'),
(145, 11, 2, '03:38:20'),
(146, 104, 2, '03:38:20'),
(147, 94, 2, '03:38:20'),
(148, 134, 2, '03:38:20'),
(149, 196, 2, '03:38:20'),
(150, 65, 2, '03:38:20'),
(151, 45, 2, '03:38:20'),
(152, 183, 2, '03:38:20'),
(153, 181, 2, '03:38:20'),
(154, 62, 2, '03:38:20'),
(155, 56, 2, '03:38:20'),
(156, 133, 2, '03:38:20'),
(157, 63, 2, '03:38:20'),
(158, 66, 2, '03:38:20'),
(159, 82, 2, '03:38:20'),
(160, 83, 2, '03:38:20'),
(161, 1, 2, '03:38:20'),
(162, 112, 2, '03:38:20'),
(163, 86, 2, '03:38:20'),
(164, 85, 2, '03:38:20'),
(165, 142, 2, '03:38:20'),
(166, 194, 2, '03:38:20'),
(167, 96, 2, '03:38:20'),
(168, 95, 2, '03:38:20'),
(169, 72, 2, '03:38:20'),
(170, 76, 2, '03:38:20'),
(171, 164, 2, '03:38:20'),
(172, 102, 2, '03:38:20'),
(173, 61, 2, '03:38:20'),
(174, 84, 2, '03:38:20'),
(175, 113, 2, '03:38:20'),
(176, 75, 2, '03:38:20'),
(177, 74, 2, '03:38:20'),
(178, 143, 2, '03:38:20'),
(179, 144, 2, '03:38:20'),
(180, 114, 2, '03:38:20'),
(181, 174, 2, '03:38:20'),
(182, 92, 2, '03:38:20'),
(183, 25, 2, '03:38:20');
INSERT INTO eredmeny VALUES
(184, 195, 2, '03:38:20'),
(185, 192, 2, '03:38:20'),
(186, 191, 2, '03:38:20'),
(187, 156, 2, '03:38:20'),
(188, 103, 2, '03:38:20'),
(189, 101, 2, '03:38:20'),
(190, 106, 2, '03:38:20'),
(191, 15, 2, '03:38:20'),
(192, 64, 2, '03:38:20'),
(193, 22, 2, '03:38:20'),
(194, 154, 2, '03:38:20'),
(195, 121, 2, '03:38:20'),
(196, 91, 2, '03:38:20'),
(197, 5, 2, '03:38:20'),
(198, 161, 2, '03:38:20'),
(199, 165, 2, '03:38:20'),
(200, 162, 2, '03:38:20'),
(201, 36, 2, '03:38:20'),
(202, 35, 2, '03:38:20'),
(203, 155, 2, '03:38:20'),
(204, 6, 2, '03:38:20'),
(205, 163, 2, '03:38:20'),
(206, 24, 2, '03:38:20'),
(207, 185, 2, '03:38:20'),
(208, 115, 2, '03:38:20'),
(209, 51, 2, '03:38:20'),
(210, 43, 2, '03:38:20'),
(211, 44, 2, '03:38:20'),
(212, 166, 2, '03:38:20'),
(213, 153, 2, '03:38:20'),
(214, 26, 2, '03:38:20'),
(215, 141, 2, '03:38:20'),
(216, 145, 2, '03:38:20'),
(217, 172, 2, '03:38:20'),
(218, 171, 2, '03:38:20'),
(219, 122, 2, '03:38:20'),
(220, 132, 2, '03:38:20'),
(221, 135, 2, '03:38:20'),
(222, 125, 2, '03:38:20'),
(223, 42, 2, '03:38:20'),
(224, 184, 2, '03:38:20'),
(225, 182, 2, '03:38:20'),
(226, 186, 2, '03:38:20'),
(227, 126, 2, '03:38:20');
INSERT INTO eredmeny VALUES
(228, 13, 3, '03:48:33'),
(229, 41, 3, '03:48:33'),
(230, 116, 3, '03:48:33'),
(231, 54, 3, '03:48:33'),
(232, 105, 3, '03:48:33'),
(233, 3, 3, '03:48:33'),
(234, 173, 3, '03:48:33'),
(235, 2, 3, '03:48:33'),
(236, 93, 3, '03:48:33'),
(237, 53, 3, '03:48:33'),
(238, 136, 3, '03:48:33'),
(239, 146, 3, '03:48:33'),
(240, 81, 3, '03:48:33'),
(241, 124, 3, '03:48:33'),
(242, 31, 3, '03:48:33'),
(243, 73, 3, '03:48:33'),
(244, 33, 3, '03:48:33'),
(245, 123, 3, '03:48:33'),
(246, 84, 3, '03:48:33'),
(247, 85, 3, '03:48:33'),
(248, 153, 3, '03:48:33'),
(249, 162, 3, '03:48:33'),
(250, 56, 3, '03:48:33'),
(251, 21, 3, '03:48:33'),
(252, 94, 3, '03:48:33'),
(253, 196, 3, '03:48:33'),
(254, 71, 3, '03:48:33'),
(255, 141, 3, '03:48:33'),
(256, 193, 3, '03:48:33'),
(257, 45, 3, '03:48:33'),
(258, 62, 3, '03:48:33'),
(259, 154, 3, '03:48:33'),
(260, 102, 3, '03:48:33'),
(261, 14, 3, '03:48:33'),
(262, 75, 3, '03:48:33'),
(263, 64, 3, '03:48:33'),
(264, 171, 3, '03:48:33'),
(265, 101, 3, '03:48:33'),
(266, 133, 3, '03:48:33'),
(267, 132, 3, '03:48:33'),
(268, 23, 3, '03:48:33'),
(269, 155, 3, '03:48:33'),
(270, 72, 3, '03:48:33'),
(271, 76, 3, '03:48:33'),
(272, 183, 3, '03:48:33'),
(273, 86, 3, '03:48:33'),
(274, 36, 3, '03:48:33'),
(275, 35, 3, '03:48:33'),
(276, 4, 3, '03:48:33'),
(277, 61, 3, '03:48:33'),
(278, 83, 3, '03:48:33'),
(279, 25, 3, '03:48:33'),
(280, 24, 3, '03:48:33'),
(281, 115, 3, '03:48:33'),
(282, 135, 3, '03:48:33'),
(283, 122, 3, '03:48:33'),
(284, 172, 3, '03:48:33'),
(285, 113, 3, '03:48:33'),
(286, 145, 3, '03:48:33'),
(287, 194, 3, '03:48:33'),
(288, 111, 3, '03:48:33'),
(289, 184, 3, '03:48:33'),
(290, 114, 3, '03:48:33'),
(291, 134, 3, '03:48:33'),
(292, 103, 3, '03:48:33'),
(293, 106, 3, '03:48:33'),
(294, 181, 3, '03:48:33'),
(295, 66, 3, '03:48:33'),
(296, 112, 3, '03:48:33');
INSERT INTO eredmeny VALUES
(297, 131, 3, '03:48:33'),
(298, 192, 3, '03:48:33'),
(299, 43, 3, '03:48:33'),
(300, 52, 3, '03:48:33'),
(301, 65, 3, '03:48:33'),
(302, 82, 3, '03:48:33'),
(303, 1, 3, '03:48:33'),
(304, 144, 3, '03:48:33'),
(305, 63, 3, '03:48:33'),
(306, 143, 3, '03:48:33'),
(307, 5, 3, '03:48:33'),
(308, 182, 3, '03:48:33'),
(309, 104, 3, '03:48:33'),
(310, 142, 3, '03:48:33'),
(311, 161, 3, '03:48:33'),
(312, 11, 3, '03:48:33'),
(313, 92, 3, '03:48:33'),
(314, 74, 3, '03:48:33'),
(315, 96, 3, '03:48:33'),
(316, 51, 3, '03:48:33'),
(317, 163, 3, '03:48:33'),
(318, 156, 3, '03:48:33'),
(319, 16, 3, '03:48:33'),
(320, 15, 3, '03:48:33'),
(321, 195, 3, '03:48:33'),
(322, 164, 3, '03:48:33'),
(323, 121, 3, '03:48:33'),
(324, 166, 3, '03:48:33'),
(325, 91, 3, '03:48:33'),
(326, 174, 3, '03:48:33'),
(327, 191, 3, '03:48:33'),
(328, 165, 3, '03:48:33'),
(329, 26, 3, '03:48:33'),
(330, 55, 3, '03:48:33'),
(331, 95, 3, '03:48:33'),
(332, 46, 3, '03:48:33'),
(333, 185, 3, '03:48:53'),
(334, 44, 3, '03:48:59'),
(335, 186, 3, '03:49:00'),
(336, 6, 3, '03:49:10'),
(337, 42, 3, '03:49:13'),
(338, 22, 3, '03:49:29');
INSERT INTO eredmeny VALUES
(339, 13, 4, '03:55:53'),
(340, 53, 4, '03:55:53'),
(341, 105, 4, '03:55:53'),
(342, 136, 4, '03:55:53'),
(343, 173, 4, '03:55:53'),
(344, 141, 4, '03:55:53'),
(345, 93, 4, '03:55:53'),
(346, 122, 4, '03:55:53'),
(347, 46, 4, '03:55:53'),
(348, 31, 4, '03:55:53'),
(349, 196, 4, '03:55:53'),
(350, 115, 4, '03:55:53'),
(351, 164, 4, '03:55:53'),
(352, 54, 4, '03:55:53'),
(353, 193, 4, '03:55:53'),
(354, 182, 4, '03:55:53'),
(355, 2, 4, '03:55:53'),
(356, 181, 4, '03:55:53'),
(357, 21, 4, '03:55:53'),
(358, 114, 4, '03:55:53'),
(359, 104, 4, '03:55:53'),
(360, 16, 4, '03:55:53'),
(361, 94, 4, '03:55:53'),
(362, 14, 4, '03:55:53'),
(363, 62, 4, '03:55:53'),
(364, 103, 4, '03:55:53'),
(365, 72, 4, '03:55:53'),
(366, 52, 4, '03:55:53'),
(367, 3, 4, '03:55:53'),
(368, 71, 4, '03:55:53'),
(369, 33, 4, '03:55:53'),
(370, 4, 4, '03:55:53'),
(371, 55, 4, '03:55:53'),
(372, 171, 4, '03:55:53'),
(373, 1, 4, '03:55:53'),
(374, 154, 4, '03:55:53'),
(375, 153, 4, '03:55:53'),
(376, 75, 4, '03:55:53'),
(377, 35, 4, '03:55:53'),
(378, 82, 4, '03:55:53'),
(379, 84, 4, '03:55:53'),
(380, 25, 4, '03:55:53'),
(381, 45, 4, '03:55:53'),
(382, 86, 4, '03:55:53'),
(383, 185, 4, '03:55:53'),
(384, 144, 4, '03:55:53'),
(385, 66, 4, '03:55:53'),
(386, 83, 4, '03:55:53'),
(387, 74, 4, '03:55:53'),
(388, 133, 4, '03:55:53'),
(389, 36, 4, '03:55:53'),
(390, 135, 4, '03:55:53'),
(391, 134, 4, '03:55:53'),
(392, 174, 4, '03:55:53'),
(393, 73, 4, '03:55:53'),
(394, 22, 4, '03:55:53'),
(395, 194, 4, '03:55:53'),
(396, 76, 4, '03:55:53'),
(397, 96, 4, '03:55:53'),
(398, 111, 4, '03:55:53'),
(399, 112, 4, '03:55:53'),
(400, 113, 4, '03:55:53'),
(401, 195, 4, '03:55:53'),
(402, 102, 4, '03:55:53'),
(403, 192, 4, '03:55:53'),
(404, 146, 4, '03:55:53'),
(405, 142, 4, '03:55:53'),
(406, 121, 4, '03:55:53'),
(407, 63, 4, '03:55:53');
INSERT INTO eredmeny VALUES
(408, 64, 4, '03:55:53'),
(409, 132, 4, '03:55:53'),
(410, 61, 4, '03:55:53'),
(411, 123, 4, '03:55:53'),
(412, 56, 4, '03:55:53'),
(413, 43, 4, '03:55:53'),
(414, 23, 4, '03:55:53'),
(415, 5, 4, '03:55:53'),
(416, 131, 4, '03:55:53'),
(417, 191, 4, '03:55:53'),
(418, 95, 4, '03:55:53'),
(419, 165, 4, '03:56:33'),
(420, 24, 4, '03:55:53'),
(421, 65, 4, '03:55:53'),
(422, 11, 4, '03:57:06'),
(423, 183, 4, '03:55:53'),
(424, 51, 4, '03:57:18'),
(425, 106, 4, '03:57:34'),
(426, 101, 4, '03:57:57'),
(427, 116, 4, '03:55:53'),
(428, 42, 4, '03:55:53'),
(429, 161, 4, '03:55:53'),
(430, 163, 4, '03:55:53'),
(431, 166, 4, '03:55:53'),
(432, 41, 4, '03:55:53'),
(433, 81, 4, '03:55:53'),
(434, 85, 4, '03:55:53'),
(435, 124, 4, '03:55:53'),
(436, 162, 4, '03:55:53'),
(437, 172, 4, '04:02:05'),
(438, 91, 4, '04:02:05'),
(439, 6, 4, '04:02:05'),
(440, 156, 4, '04:02:05'),
(441, 15, 4, '04:02:05'),
(442, 186, 4, '04:02:12'),
(443, 145, 4, '04:02:41'),
(444, 184, 4, '04:02:41'),
(445, 26, 4, '04:02:41'),
(446, 44, 4, '04:06:42'),
(447, 155, 4, '04:08:31');
INSERT INTO eredmeny VALUES
(448, 13, 5, '03:55:53'),
(449, 53, 5, '03:55:53'),
(450, 105, 5, '03:55:53'),
(451, 136, 5, '03:55:53'),
(452, 173, 5, '03:55:53'),
(453, 141, 5, '03:55:53'),
(454, 93, 5, '03:55:53'),
(455, 122, 5, '03:55:53'),
(456, 46, 5, '03:55:53'),
(457, 31, 5, '03:55:53'),
(458, 196, 5, '03:55:53'),
(459, 115, 5, '03:55:53'),
(460, 164, 5, '03:55:53'),
(461, 54, 5, '03:55:53'),
(462, 193, 5, '03:55:53'),
(463, 182, 5, '03:55:53'),
(464, 2, 5, '03:55:53'),
(465, 181, 5, '03:55:53'),
(466, 21, 5, '03:55:53'),
(467, 114, 5, '03:55:53'),
(468, 104, 5, '03:55:53'),
(469, 16, 5, '03:55:53'),
(470, 94, 5, '03:55:53'),
(471, 14, 5, '03:55:53'),
(472, 62, 5, '03:55:53'),
(473, 103, 5, '03:55:53'),
(474, 72, 5, '03:55:53'),
(475, 52, 5, '03:55:53'),
(476, 3, 5, '03:55:53'),
(477, 71, 5, '03:55:53'),
(478, 33, 5, '03:55:53'),
(479, 4, 5, '03:55:53'),
(480, 55, 5, '03:55:53'),
(481, 171, 5, '03:55:53'),
(482, 1, 5, '03:55:53'),
(483, 154, 5, '03:55:53'),
(484, 153, 5, '03:55:53'),
(485, 75, 5, '03:55:53'),
(486, 35, 5, '03:55:53'),
(487, 82, 5, '03:55:53'),
(488, 84, 5, '03:55:53'),
(489, 25, 5, '03:55:53'),
(490, 45, 5, '03:55:53'),
(491, 86, 5, '03:55:53'),
(492, 185, 5, '03:55:53'),
(493, 144, 5, '03:55:53'),
(494, 66, 5, '03:55:53'),
(495, 83, 5, '03:55:53'),
(496, 74, 5, '03:55:53'),
(497, 133, 5, '03:55:53'),
(498, 36, 5, '03:55:53'),
(499, 135, 5, '03:55:53'),
(500, 134, 5, '03:55:53'),
(501, 174, 5, '03:55:53'),
(502, 73, 5, '03:55:53'),
(503, 22, 5, '03:55:53'),
(504, 194, 5, '03:55:53'),
(505, 76, 5, '03:55:53'),
(506, 96, 5, '03:55:53'),
(507, 111, 5, '03:55:53'),
(508, 112, 5, '03:55:53'),
(509, 113, 5, '03:55:53'),
(510, 195, 5, '03:55:53'),
(511, 102, 5, '03:55:53'),
(512, 192, 5, '03:55:53'),
(513, 146, 5, '03:55:53'),
(514, 142, 5, '03:55:53'),
(515, 121, 5, '03:55:53'),
(516, 63, 5, '03:55:53');
INSERT INTO eredmeny VALUES
(517, 64, 5, '03:55:53'),
(518, 132, 5, '03:55:53'),
(519, 61, 5, '03:55:53'),
(520, 123, 5, '03:55:53'),
(521, 56, 5, '03:55:53'),
(522, 43, 5, '03:55:53'),
(523, 23, 5, '03:55:53'),
(524, 5, 5, '03:55:53'),
(525, 131, 5, '03:55:53'),
(526, 191, 5, '03:55:53'),
(527, 95, 5, '03:55:53'),
(528, 165, 5, '03:56:33'),
(529, 24, 5, '03:55:53'),
(530, 65, 5, '03:55:53'),
(531, 11, 5, '03:57:06'),
(532, 183, 5, '03:55:53'),
(533, 51, 5, '03:57:18'),
(534, 106, 5, '03:57:34'),
(535, 101, 5, '03:57:57'),
(536, 116, 5, '03:55:53'),
(537, 42, 5, '03:55:53'),
(538, 161, 5, '03:55:53'),
(539, 163, 5, '03:55:53'),
(540, 166, 5, '03:55:53'),
(541, 41, 5, '03:55:53'),
(542, 81, 5, '03:55:53'),
(543, 85, 5, '03:55:53'),
(544, 124, 5, '03:55:53'),
(545, 162, 5, '03:55:53'),
(546, 172, 5, '04:02:05'),
(547, 91, 5, '04:02:05'),
(548, 6, 5, '04:02:05'),
(549, 156, 5, '04:02:05'),
(550, 15, 5, '04:02:05'),
(551, 186, 5, '04:02:12'),
(552, 145, 5, '04:02:41'),
(553, 184, 5, '04:02:41'),
(554, 26, 5, '04:02:41'),
(555, 44, 5, '04:06:42'),
(556, 155, 5, '04:08:31');

--MEGOLDÁS--
-- A feladatok megoldására elkészített SQL parancsokat illessze be a feladat sorszáma után!

-- 9. feladat:
CREATE DATABASE tdhongrie DEFAULT charset utf8 COLLATE utf8_hungarian_ci;

-- 11. feladat:
DELETE FROM csapat WHERE id=21;

-- 12. feladat:
SSELECT versenyzo.nev FROM versenyzo WHERE versenyzo.nemzetiseg="HUN" ORDER BY nev ASC;

-- 13. feladat:
SELECT DISTINCT versenyzo.nemzetiseg as nemzetiseg, COUNT(versenyzo.csapatId) as indulokSzama
FROM versenyzo GROUP BY nemzetiseg ORDER by COUNT(versenyzo.csapatId) DESC;

-- 14. feladat:
SELECT eredmeny.szakasz, eredmeny.ido
FROM versenyzo INNER JOIN eredmeny ON versenyzo.id=eredmeny.versenyzoId WHERE versenyzo.nev="Valter Attila" ORDER BY eredmeny.szakasz;

-- 15. feladat:
SELECT csapat.csapatNev, COUNT(versenyzo.csapatId) as magyarokSzama
FROM csapat INNER JOIN versenyzo ON csapat.id=versenyzo.csapatId
WHERE versenyzo.nemzetiseg="HUN" GROUP BY csapat.csapatNev HAVING COUNT(versenyzo.csapatId)>1;