create database Formula1_2025
go
use Formula1_2025

create table Kraje
(
Id_kr tinyint primary key,
Nazwa varchar(45)
);

create table Kalendarz
(
Id_kal smallint primary key,
Id_t tinyint,
Kiedy date
);

create table Tory
(
Id_t tinyint primary key,
Nazwa varchar(60),
Dlugosc float,
Miasto varchar(20),
Id_kr tinyint
);

create table Zespoły
(
Id_z tinyint primary key,
Nazwa varchar(20),
Id_kr tinyint
);

create table Kierowcy
(
Id_k tinyint primary key,
Imie varchar(20),
Nazwisko varchar(20),
Data_ur date,
Numer tinyint unique,
Id_kr tinyint,
Id_z tinyint
);


create table Wyniki
(
Id_w smallint primary key,
Id_k tinyint,
Id_kal smallint,
Czas time,
Okrazenia tinyint,
Vsr float,
Pkt tinyint
);


alter table Kalendarz add constraint kl foreign key (Id_t) references Tory (Id_t);
alter table Tory add constraint kll foreign key (Id_kr) references Kraje (Id_kr);
alter table Kierowcy add constraint klll foreign key (Id_kr) references Kraje (Id_kr);
alter table Zespoły add constraint kllll foreign key (Id_kr) references Kraje (Id_kr);
alter table Kierowcy add constraint klllll foreign key (Id_z) references Zespoły (Id_z);
alter table Wyniki add constraint k foreign key (Id_k) references Kierowcy (Id_k);
alter table Wyniki add constraint l foreign key (Id_kal) references Kalendarz (Id_kal);


insert into Kraje (Id_kr, Nazwa) 
values (1, 'Francja'), 
(2, 'Wielka Brytania'), 
(3, 'Włochy'), 
(4, 'Stany Zjednoczone'), 
(5, 'Niemcy'), 
(6, 'Austria'), 
(7, 'Szwajcaria'), 
(8, 'Bahrain'), 
(9, 'Arabia Saudyjska'), 
(10, 'Australia'), 
(11, 'Japonia'), 
(12, 'Chiny'), 
(13, 'Monako'), 
(14, 'Kanada'), 
(15, 'Hiszpania'), 
(16, 'Węgry'), 
(17, 'Belgia'), 
(18, 'Holandia'), 
(19, 'Azerbejdżan'), 
(20, 'Singapur'), 
(21, 'Meksyk'), 
(22, 'Brazylia'), 
(23, 'Dania'), 
(24, 'Tajlandia'), 
(25, 'Argentyna'), 
(26, 'Finlandia'), 
(27, 'Nowa Zelandia'),
(28, 'Katar'),
(29, 'Zjednoczone Emiraty Arabskie');



insert into Tory (Id_t, Nazwa, Dlugosc, Miasto, Id_kr) values 
(1, 'Bahrain International Circuit', 5.412, 'Sakhir', 8), 
(2, 'Jeddah Street Circuit', 6.175, 'Jeddah', 9), 
(3, 'Albert Park Grand Prix', 5.279, 'Melbourne',10),
(4, 'Suzuka International Racing Course', 5.807, 'Suzuka', 11),
(5, 'Shanghai International Circuit', 5.451, 'Shanghai', 12),
(6, 'Miami International Autodrome', 5.412, 'Miami Gardens', 4),
(7, 'Autodromo Internazionale Enzo e Dino Ferrari', 4.909, 'Imola', 3),
(8, 'Circuit de Monaco', 3.337, 'Monako', 13),
(9, 'Circuit Gilles-Villeneuve', 4.361, 'Montréal', 14),
(10, 'Circuit de Barcelona-Catalunya', 4.655, 'Barcelona', 15),
(11, 'Red Bull Ring', 4.318, 'Spielberg', 6),
(12, 'Silverstone Circuit', 5.891, 'Towcester', 2),
(13, 'Hungaroring', 4.381, 'Mogyoród', 16),
(14, 'Circuit de Spa-Francorchamps', 7.004, 'Stevelot', 17),
(15, 'Circuit Zandvoort', 4.259, 'Zandvoort', 18),
(16, 'Autodromo', 5.793, 'Monza', 3),
(17, 'Baku City Circuit', 6.003, 'Baku', 19),
(18, 'Singapore Street Circuit', 5.073, 'Marina Bay', 20),
(19, 'Circuit of The Americas', 5.513, 'Austin', 4),
(20, 'Autódromo Hermanos Rodríguez', 4.304, 'Iztacalco', 21),
(21, 'Autódromo José Carlos Pace', 4.309, 'São Paulo', 22),
(22, 'Streets of Las Vegas', 6.201, 'Las Vegas', 4),
(23, 'Losail International Circuit', 5.419, 'Lusail', 28),
(24, 'Yas Marina Circuit', 5.281, 'Abu Dahabi', 29);

insert into Zespoły (Id_z, Nazwa, Id_kr)
values (1, 'Alpine',1),
(2, 'Aston Martin',2),
(3, 'Ferrari',3),
(4, 'Haas', 4),
(5, 'McLaren',2),
(6, 'Mercedes',5),
(7, 'RB F1 Team',3),
(8, 'Red Bull Racing',6),
(9, 'Stake',7),
(10, 'Williams',2);

insert into Kierowcy (Id_k, Imie, Nazwisko, Data_ur, Numer, Id_kr, Id_z) values
(1, 'Max', 'Verstappen', '1997-09-30', 1, 18, 8),
(2, 'Daniel', 'Ricciardo', '1989-07-01', 3, 10, 7),
(3, 'Lando', 'Norris', '1999-11-13', 4, 2, 5),
(4, 'Pierre', 'Gasly', '1996-02-07', 10, 1, 1),
(5, 'Sergio', 'Pérez', '1990-01-26', 11, 21, 8),
(6, 'Fernando', 'Alonso', '1981-07-29', 14, 15, 2),
(7, 'Charles', 'Leclerc', '1997-10-16', 16, 13, 3),
(8, 'Lance', 'Stroll', '1998-10-29', 18, 14, 2),
(9, 'Kevin', 'Magnussen', '1992-10-05', 20, 23, 4),
(10, 'Yuki', 'Tsunoda', '2000-05-11', 22, 11, 7),
(11, 'Alexander', 'Albon', '1996-03-23', 23, 24, 10),
(12, 'Nico', 'Hülkenberg', '1987-08-19', 27, 5, 4),
(13, 'Liam', 'Lawson', '2002-02-11', 30, 29, 7),
(14, 'Esteban', 'Ocon', '1996-09-17', 31, 1, 1),
(15, 'Oliver', 'Bearman', '2005-05-08', 38, 2, 4),
(16, 'Franco', 'Colapinto', '2003-05-22', 43, 25, 10),
(17, 'Lewis', 'Hamilton', '1985-01-07', 44, 2, 6),
(18, 'Carlos', 'Sainz', '1994-09-01', 55, 15, 3),
(19, 'George', 'Russell', '1998-02-15', 63, 2, 6),
(20, 'Oscar', 'Piastri', '2001-04-06', 81, 10, 5),
(23, 'Guanyu', 'Zhou', '1999-05-30', 24, 12, 9),
(24, 'Valtteri', 'Bottas', '1989-08-28', 77, 26, 7),
(26, 'Logan', 'Sargeant', '2000-12-31', 2, 4, 10);



insert into Kalendarz (Id_kal, Id_t, Kiedy) values
(1, 1, '2024-03-02'),
(2, 2, '2024-03-09'),
(3, 3, '2024-03-24'),
(4, 4, '2024-04-07'),
(5, 5, '2024-04-21'),
(6, 6, '2024-05-05'),
(7, 7, '2024-05-19'),
(8, 8, '2024-05-26'),
(9, 9, '2024-06-09'),
(10, 10, '2024-06-23'),
(11, 11, '2024-06-30'),
(12, 12, '2024-07-07'),
(13, 13, '2024-07-21'),
(14, 14, '2024-07-28'),
(15, 15, '2024-08-25'),
(16, 16, '2024-09-01'),
(17, 17, '2024-09-15'),
(18, 18, '2024-09-22'),
(19, 19, '2024-10-20'),
(20, 20, '2024-10-27'),
(21, 21, '2024-11-03'),
(22, 22, '2024-11-24'),
(23, 23, '2024-12-01'),
(24, 24, '2024-12-08');

insert into Wyniki (Id_w, Id_k, Id_kal, Czas, Okrazenia, Vsr, Pkt) values
(1,1, 1, '1:31:44', 57, 201.581, 26),
(2,5, 1, '1:32:07', 57, 200.762, 18),
(3,18, 1, '1:32:09', 57, 200.666, 15),
(4,7, 1, '1:32:24', 57, 200.139, 12),
(5,19, 1, '1:32:31', 57, 199.883, 10),
(6,3, 1, '1:32:33', 57, 199.822, 8),
(7,17, 1, '1:32:35', 57, 199.755, 6),
(8,20, 1, '1:32:30', 57, 199.548, 4),
(9,6, 1, '1:32:59', 57, 198.876, 2),
(10,8, 1, '1:33:17', 57, 198.225, 1),
(11,23, 1, '1:31:51', 56, 197.799, NULL),
(12,9, 1, '1:31:53', 56, 197.743, NULL),
(13,2, 1, '1:31:53', 56, 197.720, NULL),
(14,10, 1, '1:31:54', 56, 197.702, NULL),
(15,11, 1, '1:31:56', 56, 197.615, NULL),
(16,12, 1, '1:32:02', 56, 197.410, NULL),
(17,14, 1, '1:32:16', 56, 196.917, NULL),
(18,4, 1, '1:32:17', 56, 196.883, NULL),
(19,24, 1, '1:33:07', 56, 195.092, NULL),
(20,26, 1, '1:32:05', 55, 193.771, NULL),
(21,1,2,'1:20:43', 50, 229.270, 25),
(22,5,2,'1:20:56', 50, 228.626, 18),
(23,7,2,'1:21:01', 50, 228.391, 16),
(24,20,2,'1:21:15', 50, 227.765, 12),
(25,6,2,'1:21:19', 50, 227.590, 10),
(26,19,2,'1:21:23',50, 227.395, 8),
(27,15,2,'1:21:25',50, 227.267, 6),
(28,3,2,'1:21:28',50,227.127,4),
(29,17,2,'1:21:30',50,227.048,2),
(30,12,2,'1:22:00',50,225.682,1),
(31,11,2,'1:22:11',50,225.163, NULL),
(32,9,2,'1:22:29', 50,224.372, NULL),
(33,14,2,'1:20:47',49,224.495, NULL),
(34,26,2,'1:20:50',49,224.367, NULL),
(35,10,2,'1:20:53',49,224.193, NULL),
(36,2,2,'1:21:03', 49, 223.724, NULL),
(37,24,2,'1:21:06',49, 223.614, NULL),
(38,23,2,'1:21:12',49,223.318, NULL),
(39,8,2,'00:08:05',5, 226.997, NULL),
(40,4,2,'00:02:01',1, 175.593, NULL),
(41, 18, 3, '1:20:26', 58, 228.316, 25),
(42, 7, 3, '1:20:29', 58, 228.204, 19),
(43, 3, 3, '1:20:32', 58, 228.037, 15),
(44, 20, 3, '1:21:02', 58, 226.636, 12),
(45, 5, 3, '1:21:23', 58, 225.683, 10),
(46, 8, 3, '1:22:00', 58, 223.990, 8),
(47, 10, 3, '1:22:02', 58, 223.881, 6),
(48, 6, 3, '1:22:07', 58, 223.637, 4),
(49, 12, 3, '1:22:11', 58, 223.475, 2),
(50, 9, 3, '1:20:30', 57, 224.190, 1),
(51, 11, 3, '1:20:31', 57, 224.147, NULL),
(52, 2, 3, '1:20:38', 57, 223.846, NULL),
(53, 4, 3, '1:21:07', 57, 222.491, NULL),
(54, 24, 3, '1:21:09', 57, 222.429, NULL),
(55, 23, 3, '1:21:11', 57, 222.339, NULL),
(56, 14, 3, '1:21:20', 57, 221.898, NULL),
(57, 19, 3, '1:18:04', 56, 227.130, NULL),
(58, 17, 3, '00:21:18', 15, 222.939, NULL),
(59, 1, 3, '00:04:14', 3, 223.826, NULL),
(60, 1, 4, '1:54:23', 53, 161.271, 26),
(61, 5, 4, '1:54:36', 53, 160.977, 18),
(62, 18, 4, '1:54:44', 53, 160.782, 15),
(63, 7, 4, '1:54:50', 53, 160.650, 12),
(64, 3, 4, '1:54:53', 53, 160.576, 10),
(65, 6, 4, '1:55:07', 53, 160.237, 8),
(66, 19, 4, '1:55:09', 53, 160.198, 6),
(67, 20, 4, '1:55:11', 53, 160.162, 4),
(68, 17, 4, '1:55:12', 53, 160.136, 2),
(69, 10, 4, '1:54:25', 52, 158.188, 1),
(70, 12, 4, '1:54:30', 52, 158.060, NULL),
(71, 8, 4, '1:54:34', 52, 157.966, NULL),
(72, 9, 4, '1:54:41', 52, 157.813, NULL),
(73, 24, 4, '1:54:42', 52, 157.791, NULL),
(74, 14, 4, '1:55:04', 52, 157.282, NULL),
(75, 4, 4, '1:55:18', 52, 156.966, NULL),
(76, 26, 4, '1:55:36', 52, 156.565, NULL),
(77, 23, 4, '00:49:29', 12, 84.129, NULL),
(78, 2, 4, '00:00:00', 0, NULL, NULL),
(79, 11, 4, '00:00:00', 0, NULL, NULL),
(80, 1, 5, '1:40:52', 56, 181.450, 25),
(81, 3, 5, '1:41:06', 56, 181.038, 18),
(82, 5, 5, '1:41:11', 56, 180.877, 15),
(83, 7, 5, '1:41:16', 56, 180.744, 12),
(84, 18, 5, '1:41:26', 56, 180.437, 10),
(85, 19, 5, '1:41:31', 56, 180.296, 8),
(86, 6, 5, '1:41:35', 56, 180.158, 7),
(87, 20, 5, '1:41:48', 56, 179.781, 4),
(88, 17, 5, '1:41:50', 56, 179.728, 2),
(89, 12, 5, '1:41:53', 56, 179.655, 1),
(90, 14, 5, '1:41:55', 56, 179.586, NULL),
(91, 11, 5, '1:41:58', 56, 179.507, NULL),
(92, 4, 5, '1:42:01', 56, 179.398, NULL),
(93, 23, 5, '1:42:04', 56, 179.326, NULL),
(94, 8, 5, '1:42:15', 56, 179.001, NULL),
(95, 9, 5, '1:42:20', 56, 178.863, NULL),
(96, 26, 5, '1:42:27', 56, 178.643, NULL),
(97, 2, 5, '1:03:17', 33, 170.366, NULL),
(98, 10, 5, '00:48:07', 26, 176.477, NULL),
(99, 24, 5, '00:32:58', 19, 188.102, NULL),
(100, 3, 6, '1:30:49', 57, 203.669, 25),  
(101, 1, 6, '1:30:57', 57, 203.385, 18),  
(102, 7, 6, '1:30:59', 57, 203.299, 15),  
(103, 5, 6, '1:31:04', 57, 203.123, 12),  
(104, 18, 6, '1:31:06', 57, 203.058, 10),  
(105, 17, 6, '1:31:06', 57, 203.051, 8),   
(106, 10, 6, '1:31:16', 57, 202.695, 6),   
(107, 19, 6, '1:31:24', 57, 202.377, 4),   
(108, 6, 6, '1:31:26', 57, 202.292, 2),    
(109, 14, 6, '1:31:29', 57, 202.194, 1),    
(110, 12, 6, '1:31:30', 57, 202.156, NULL), 
(111, 4, 6, '1:31:34', 57, 202.003, NULL),  
(112, 20, 6, '1:31:39', 57, 201.826, NULL), 
(113, 23, 6, '1:31:39', 57, 201.818, NULL), 
(114, 2, 6, '1:31:40', 57, 201.782, NULL),  
(115, 24, 6, '1:31:42', 57, 201.731, NULL), 
(116, 8, 6, '1:31:45', 57, 201.628, NULL),  
(117, 11, 6, '1:32:05', 57, 200.865, NULL), 
(118, 9, 6, '1:32:14', 57, 200.553, NULL),  
(119, 26, 6, '00:43:03', 27, 203.394, NULL), 
(120, 1, 7, '1:25:25', 63, 217.077, 25),   
(121, 3, 7, '1:25:25', 63, 217.046, 18),   
(122, 7, 7, '1:25:33', 63, 216.742, 15),   
(123, 20, 7, '1:25:39', 63, 216.480, 12),   
(124, 18, 7, '1:25:47', 63, 216.135, 10),   
(125, 17, 7, '1:26:00', 63, 215.600, 8),    
(126, 19, 7, '1:26:12', 63, 215.098, 7),    
(127, 5, 7, '1:26:20', 63, 214.781, 4),     
(128, 8, 7, '1:26:44', 63, 213.759, 2),     
(129, 10, 7, '1:25:43', 62, 212.887, 1),    
(130, 12, 7, '1:25:50', 62, 212.580, NULL), 
(131, 9, 7, '1:25:51', 62, 212.533, NULL),  
(132, 2, 7, '1:25:52', 62, 212.482, NULL),  
(133, 14, 7, '1:26:09', 62, 211.814, NULL), 
(134, 23, 7, '1:26:10', 62, 211.772, NULL), 
(135, 4, 7, '1:26:14', 62, 211.577, NULL), 
(136, 26, 7, '1:26:16', 62, 211.522, NULL), 
(137, 24, 7, '1:26:21', 62, 211.306, NULL), 
(138, 6, 7, '1:26:40', 62, 210.543, NULL), 
(139, 11, 7, '1:13:07', 51, 205.233, NULL), 
(140, 7, 8, '2:23:15', 78, 109.013, 25),   
(141, 20, 8, '2:23:22', 78, 108.922, 18),   
(142, 18, 8, '2:23:23', 78, 108.917, 15),   
(143, 3, 8, '2:23:24', 78, 108.903, 12),    
(144, 19, 8, '2:23:28', 78, 108.844, 10),   
(145, 1, 8, '2:23:29', 78, 108.837, 8),     
(146, 17, 8, '2:23:30', 78, 108.824, 7),    
(147, 10, 8, '2:23:55', 77, 107.123, 4),    
(148, 11, 8, '2:24:09', 77, 106.943, 2),    
(149, 4, 8, '2:24:15', 77, 106.866, 1),     
(150, 6, 8, '2:23:19', 76, 106.170, NULL),  
(151, 2, 8, '2:23:19', 76, 106.165, NULL),  
(152, 24, 8, '2:23:20', 76, 106.162, NULL), 
(153, 8, 8, '2:23:21', 76, 106.144, NULL),  
(154, 26, 8, '2:23:24', 76, 106.106, NULL), 
(155, 23, 8, '2:24:10', 76, 105.539, NULL), 
(156, 14, 8, '00:00:00', 0, NULL, NULL),     
(157, 5, 8, '00:00:00', 0, NULL, NULL),      
(158, 12, 8, '00:00:00', 0, NULL, NULL),     
(159, 9, 8, '00:00:00', 0, NULL, NULL),     
(160, 1, 9, '1:45:47', 70, 173.122, 25),  
(161, 3, 9, '1:45:51', 70, 173.017, 18),  
(162, 19, 9, '1:45:52', 70, 173.005, 15),  
(163, 17, 9, '1:45:52', 70, 172.989, 13),  
(164, 20, 9, '1:45:58', 70, 172.845, 10),  
(165, 6, 9, '1:46:05', 70, 172.646, 8),   
(166, 8, 9, '1:46:11', 70, 172.481, 6),   
(167, 2, 9, '1:46:16', 70, 172.344, 4),   
(168, 4, 9, '1:46:17', 70, 172.308, 2),   
(169, 14, 9, '1:46:18', 70, 172.300, 1),   
(170, 12, 9, '1:46:18', 70, 172.286, NULL), 
(171, 9, 9, '1:46:19', 70, 172.274, NULL), 
(172, 24, 9, '1:46:28', 70, 172.025, NULL), 
(173, 10, 9, '1:46:40', 70, 171.697, NULL), 
(174, 23, 9, '1:46:41', 69, 169.222, NULL), 
(175, 18, 9, '1:19:48', 52, 170.488, NULL), 
(176, 11, 9, '1:19:49', 52, 170.468, NULL), 
(177, 5, 9, '1:18:30', 51, 169.967, NULL), 
(178, 7, 9, '1:04:03', 40, 163.396, NULL),  
(179, 26, 9, '00:36:04', 23, 166.822, NULL),   
(180, 1, 10, '1:28:20', 66, 208.679, 25),  
(181, 3, 10, '1:28:22', 66, 208.592, 19),  
(182, 17, 10, '1:28:38', 66, 207.981, 15),  
(183, 19, 10, '1:28:42', 66, 207.804, 12),  
(184, 7, 10, '1:28:42', 66, 207.789, 10),   
(185, 18, 10, '1:28:51', 66, 207.465, 8),   
(186, 20, 10, '1:28:53', 66, 207.358, 6),   
(187, 5, 10, '1:29:19', 66, 206.362, 4),   
(188, 4, 10, '1:29:22', 66, 206.265, 2),   
(189, 14, 10, '1:29:32', 66, 205.887, 1),   
(190, 12, 10, '1:29:39', 66, 205.606, NULL), 
(191, 6, 10, '1:28:29', 65, 205.148, NULL),  
(192, 23, 10, '1:28:35', 65, 204.918, NULL), 
(193, 8, 10, '1:28:45', 65, 204.542, NULL),  
(194, 2, 10, '1:29:04', 65, 203.822, NULL),  
(195, 24, 10, '1:29:13', 65, 203.469, NULL), 
(196, 9, 10, '1:29:15', 65, 203.413, NULL),  
(197, 11, 10, '1:29:18', 65, 203.286, NULL), 
(198, 10, 10, '1:29:29', 65, 202.879, NULL), 
(199, 26, 10, '1:28:25', 64, 202.167, NULL), 
(200, 19, 11, '1:24:22', 71, 217.908, 25),  
(201, 20, 11, '1:24:24', 71, 217.826, 18),  
(202, 18, 11, '1:24:27', 71, 217.713, 15),  
(203, 17, 11, '1:24:45', 71, 216.917, 12),  
(204, 1, 11, '1:25:00', 71, 216.316, 10),   
(205, 12, 11, '1:25:16', 71, 215.605, 8),   
(206, 5, 11, '1:25:17', 71, 215.580, 6),    
(207, 9, 11, '1:25:23', 71, 215.341, 4),    
(208, 2, 11, '1:25:23', 71, 215.307, 2),    
(209, 4, 11, '1:25:24', 71, 215.282, 1),    
(210, 7, 11, '1:25:29', 71, 215.060, NULL),  
(211, 14, 11, '1:25:31', 71, 215.006, NULL), 
(212, 8, 11, '1:24:33', 70, 214.404, NULL),  
(213, 10, 11, '1:24:35', 70, 214.281, NULL), 
(214, 11, 11, '1:24:38', 70, 214.167, NULL), 
(215, 24, 11, '1:24:42', 70, 214.019, NULL), 
(216, 23, 11, '1:25:07', 70, 212.950, NULL), 
(217, 6, 11, '1:25:10', 70, 212.834, NULL),  
(218, 26, 11, '1:24:29', 69, 211.504, NULL), 
(219, 3, 11, '1:16:36', 64, 216.362, NULL),  
(220, 17, 12, '1:22:27', 52, 222.821, 25),  
(221, 1, 12, '1:22:28', 52, 222.755, 18),   
(222, 3, 12, '1:22:34', 52, 222.482, 15),   
(223, 20, 12, '1:22:39', 52, 222.263, 12),  
(224, 18, 12, '1:23:14', 52, 220.710, 11),  
(225, 12, 12, '1:23:22', 52, 220.340, 8),   
(226, 8, 12, '1:23:23', 52, 220.302, 6),    
(227, 6, 12, '1:23:30', 52, 219.994, 4),    
(228, 11, 12, '1:23:35', 52, 219.783, 2),   
(229, 10, 12, '1:23:46', 52, 219.306, 1),   
(230, 26, 12, '1:23:56', 52, 218.885, NULL), 
(231, 9, 12, '1:23:57', 52, 218.833, NULL), 
(232, 2, 12, '1:22:36', 51, 218.096, NULL), 
(233, 7, 12, '1:23:07', 51, 216.761, NULL), 
(234, 24, 12, '1:23:08', 51, 216.702, NULL), 
(235, 14, 12, '1:22:37', 50, 213.786, NULL), 
(236, 5, 12, '1:22:45', 50, 213.471, NULL),  
(237, 23, 12, '1:23:21', 50, 211.914, NULL), 
(238, 19, 12, '00:52:51', 33, 220.504, NULL),   
(239, 4, 12, '00:00:00', 0, NULL, NULL), 
(240, 20, 13, '1:38:01', 70, 187.669, 25),  
(241, 3, 13, '1:38:04', 70, 187.600, 18),   
(242, 17, 13, '1:38:16', 70, 187.195, 15),  
(243, 7, 13, '1:38:21', 70, 187.043, 12),   
(244, 1, 13, '1:38:23', 70, 186.990, 10),   
(245, 18, 13, '1:38:25', 70, 186.935, 8),    
(246, 5, 13, '1:38:41', 70, 186.408, 6),    
(247, 19, 13, '1:38:44', 70, 186.327, 5),    
(248, 10, 13, '1:39:19', 70, 185.236, 2),    
(249, 8, 13, '1:39:19', 70, 185.213, 1),     
(250, 6, 13, '1:39:24', 70, 185.074, NULL),  
(251, 2, 13, '1:38:19', 69, 184.425, NULL),  
(252, 12, 13, '1:38:35', 69, 183.950, NULL), 
(253, 11, 13, '1:38:38', 69, 183.838, NULL), 
(254, 9, 13, '1:38:47', 69, 183.573, NULL),  
(255, 24, 13, '1:38:47', 69, 183.570, NULL), 
(256, 26, 13, '1:38:54', 69, 183.348, NULL), 
(257, 14, 13, '1:39:02', 69, 183.091, NULL), 
(258, 23, 13, '1:39:05', 69, 183.009, NULL), 
(259, 4, 13, '00:47:39', 33, 181.977, NULL),   
(260, 19, 14, '1:19:57', 44, 231.181, NULL),    
(261, 17, 14, '1:19:57', 44, 231.156, 25),   
(262, 20, 14, '1:19:58', 44, 231.125, 18),   
(263, 7, 14, '1:20:05', 44, 230.770, 15),    
(264, 1, 14, '1:20:06', 44, 230.737, 12),    
(265, 3, 14, '1:20:06', 44, 230.707, 10),    
(266, 18, 14, '1:20:16', 44, 230.231, 8),     
(267, 5, 14, '1:20:40', 44, 229.118, 7),     
(268, 6, 14, '1:20:47', 44, 228.798, 4),     
(269, 14, 14, '1:20:49', 44, 228.676, 2),     
(270, 2, 14, '1:20:51', 44, 228.564, 1),     
(271, 8, 14, '1:21:00', 44, 228.184, NULL),  
(272, 11, 14, '1:21:00', 44, 228.154, NULL), 
(273, 4, 14, '1:21:01', 44, 228.120, NULL),  
(274, 9, 14, '1:21:03', 44, 228.014, NULL),  
(275, 24, 14, '1:21:07', 44, 227.826, NULL), 
(276, 10, 14, '1:21:13', 44, 227.541, NULL), 
(277, 26, 14, '1:21:23', 44, 227.107, NULL), 
(278, 12, 14, '1:21:25', 44, 226.978, NULL), 
(279, 23, 14, '00:11:00', 5, 190.240, NULL),    
(280, 3, 15, '1:30:45', 72, 202.682, 26),    
(281, 1, 15, '1:31:08', 72, 201.834, 18),    
(282, 7, 15, '1:31:10', 72, 201.740, 15),    
(283, 20, 15, '1:31:12', 72, 201.670, 12),   
(284, 18, 15, '1:31:17', 72, 201.493, 10),   
(285, 5, 15, '1:31:25', 72, 201.221, 8),     
(286, 19, 15, '1:31:30', 72, 201.035, 6),     
(287, 17, 15, '1:31:35', 72, 200.853, 4),     
(288, 4, 15, '1:30:54', 71, 199.551, 2),     
(289, 6, 15, '1:30:59', 71, 199.371, 1),     
(290, 12, 15, '1:31:04', 71, 199.164, NULL), 
(291, 2, 15, '1:31:06', 71, 199.096, NULL),  
(292, 8, 15, '1:31:11', 71, 198.927, NULL),  
(293, 11, 15, '1:31:26', 71, 198.384, NULL), 
(294, 14, 15, '1:31:32', 71, 198.161, NULL), 
(295, 26, 15, '1:31:50', 71, 197.526, NULL), 
(296, 10, 15, '1:31:50', 71, 197.504, NULL), 
(297, 9, 15, '1:31:51', 71, 197.484, NULL),  
(298, 24, 15, '1:30:48', 70, 196.934, NULL), 
(299, 23, 15, '1:31:21', 70, 195.756, NULL), 
(300, 7, 16, '1:14:40', 53, 246.431, 25),    
(301, 20, 16, '1:14:43', 53, 246.285, 18),   
(302, 3, 16, '1:14:46', 53, 246.093, 16),    
(303, 18, 16, '1:14:56', 53, 245.575, 12),  
(304, 17, 16, '1:15:03', 53, 245.182, 10),   
(305, 1, 16, '1:15:18', 53, 244.362, 8),     
(306, 19, 16, '1:15:20', 53, 244.266, 6),     
(307, 5, 16, '1:15:34', 53, 243.488, 4),     
(308, 11, 16, '1:15:48', 53, 242.776, 2),     
(309, 9, 16, '1:15:49', 53, 242.731, 1),     
(310, 6, 16, '1:15:49', 53, 242.721, NULL),  
(311, 16, 16, '1:16:02', 53, 242.039, NULL), 
(312, 2, 16, '1:16:14', 53, 241.396, NULL),  
(313, 14, 16, '1:14:53', 52, 241.095, NULL), 
(314, 4, 16, '1:14:59', 52, 240.791, NULL),  
(315, 24, 16, '1:15:07', 52, 240.317, NULL), 
(316, 12, 16, '1:15:11', 52, 240.122, NULL), 
(317, 23, 16, '1:15:20', 52, 239.634, NULL), 
(318, 8, 16, '1:15:24', 52, 239.452, NULL),  
(319, 10, 16, '00:10:36', 7, 227.545, NULL),    
(320, 20, 17, '1:32:58', 51, 197.521, 25),    
(321, 7, 17, '1:33:08', 51, 197.135, 18),     
(322, 19, 17, '1:33:29', 51, 196.418, 15),     
(323, 3, 17, '1:33:34', 51, 196.249, 13),     
(324, 1, 17, '1:34:15', 51, 194.828, 10),     
(325, 6, 17, '1:34:23', 51, 194.540, 8),      
(326, 11, 17, '1:34:25', 51, 194.474, 6),     
(327, 16, 17, '1:34:27', 51, 194.400, 4),     
(328, 17, 17, '1:34:30', 51, 194.302, 2),     
(329, 15, 17, '1:34:31', 51, 194.277, 1),     
(330, 12, 17, '1:34:31', 51, 194.266, NULL),  
(331, 4, 17, '1:34:55', 51, 193.457, NULL),   
(332, 2, 17, '1:35:24', 51, 192.452, NULL),   
(333, 23, 17, '1:35:26', 51, 192.387, NULL),   
(334, 14, 17, '1:33:19', 50, 192.909, NULL),   
(335, 24, 17, '1:33:23', 50, 192.769, NULL),   
(336, 5, 17, '1:28:41', 49, 198.931, NULL),    
(337, 18, 17, '1:28:41', 49, 198.910, NULL),   
(338, 8, 17, '1:23:21', 45, 194.380, NULL),    
(339, 10, 17, '00:27:02', 14, 186.224, NULL),    
(340, 3, 18, '1:40:52', 62, 182.090, 25),    
(341, 1, 18, '1:41:13', 62, 181.462, 18),    
(342, 20, 18, '1:41:34', 62, 180.840, 15),    
(343, 19, 18, '1:41:53', 62, 180.272, 12),    
(344, 7, 18, '1:41:55', 62, 180.231, 10),     
(345, 17, 18, '1:42:17', 62, 179.561, 8),     
(346, 18, 18, '1:42:28', 62, 179.246, 6),     
(347, 6, 18, '1:40:53', 61, 179.126, 4),      
(348, 12, 18, '1:40:55', 61, 179.059, 2),     
(349, 5, 18, '1:40:57', 61, 179.015, 1),      
(350, 16, 18, '1:40:58', 61, 178.966, NULL),  
(351, 10, 18, '1:41:01', 61, 178.892, NULL),  
(352, 14, 18, '1:41:36', 61, 177.858, NULL),  
(353, 8, 18, '1:41:40', 61, 177.755, NULL),   
(354, 23, 18, '1:41:49', 61, 177.474, NULL),  
(355, 24, 18, '1:41:50', 61, 177.456, NULL),  
(356, 4, 18, '1:41:51', 61, 177.420, NULL),   
(357, 2, 18, '1:42:22', 61, 176.533, NULL),      
(358, 9, 18, '1:36:51', 57, 174.330, NULL),      
(359, 11, 18, '00:26:00', 15, 170.606, NULL),      
(360, 7, 19, '1:35:09', 56, 194.453, 25),
(361, 18, 19, '1:35:18', 56, 194.162, 18),
(362, 1, 19, '1:35:29', 56, 193.794, 15),
(363, 3, 19, '1:35:29', 56, 193.762, 12),
(364, 20, 19, '1:35:31', 56, 193.709, 10),
(365, 19, 19, '1:36:05', 56, 192.554, 8),
(366, 5, 19, '1:36:08', 56, 192.462, 6),
(367, 12, 19, '1:36:12', 56, 192.332, 4),
(368, 13, 19, '1:36:20', 56, 192.079, 2),
(369, 16, 19, '1:36:21', 56, 192.032, 1),
(370, 9, 19, '1:36:29', 56, 191.773, NULL),
(371, 4, 19, '1:36:40', 56, 191.417, NULL),
(372, 6, 19, '1:35:11', 55, 190.919, NULL),
(373, 10, 19, '1:35:17', 55, 190.702, NULL),
(374, 8, 19, '1:35:26', 55, 190.410, NULL),
(375, 11, 19, '1:35:27', 55, 190.374, NULL),
(376, 24, 19, '1:35:43', 55, 189.835, NULL),
(377, 14, 19, '1:35:51', 55, 189.578, NULL),
(378, 23, 19, '1:35:58', 55, 189.344, NULL),
(379, 17, 19, '00:00:00', 0, NULL, NULL), 
(380, 18, 20, '1:40:55', 71, 181.524, 25),
(381, 3, 20, '1:41:00', 71, 181.383, 18),
(382, 7, 20, '1:41:30', 71, 180.499, 16),
(383, 17, 20, '1:41:40', 71, 180.191, 12),
(384, 19, 20, '1:41:44', 71, 180.080, 10),
(385, 1, 20, '1:41:55', 71, 179.756, 8),
(386, 9, 20, '1:41:59', 71, 179.636, 6),
(387, 20, 20, '1:42:00', 71, 179.598, 4),
(388, 12, 20, '1:40:58', 70, 178.885, 2),
(389, 4, 20, '1:41:14', 70, 178.418, 1),
(390, 8, 20, '1:41:20', 70, 178.227, NULL),
(391, 16, 20, '1:41:33', 70, 177.864, NULL),
(392, 14, 20, '1:41:35', 70, 177.801, NULL),
(393, 24, 20, '1:41:38', 70, 177.726, NULL),
(394, 23, 20, '1:41:57', 70, 177.159, NULL),
(395, 13, 20, '1:42:00', 70, 177.080, NULL),
(396, 5, 20, '1:42:09', 70, 176.825, NULL),
(397, 6, 20, '00:25:26', 15, 151.737, NULL), 
(398, 11, 20, '00:00:00', 0, NULL, NULL),            
(399, 10, 20, '00:00:00', 0, NULL, NULL),            
(400, 1, 21, '2:06:54', 69, 140.540, 26),
(401, 14, 21, '2:07:13', 69, 140.182, 18),
(402, 4, 21, '2:07:16', 69, 140.126, 15),
(403, 19, 21, '2:07:17', 69, 140.112, 12),
(404, 7, 21, '2:07:24', 69, 139.986, 10),
(405, 3, 21, '2:07:25', 69, 139.964, 8),
(406, 10, 21, '2:07:36', 69, 139.769, 6),
(407, 20, 21, '2:07:39', 69, 139.716, 4),
(408, 13, 21, '2:07:44', 69, 139.615, 2),
(409, 17, 21, '2:07:45', 69, 139.610, 1),
(410, 5, 21, '2:07:45', 69, 139.596, NULL),
(411, 15, 21, '2:07:51', 69, 139.495, NULL),
(412, 24, 21, '2:07:58', 69, 139.377, NULL),
(413, 6, 21, '2:08:12', 69, 139.115, NULL),
(414, 23, 21, '2:08:14', 69, 139.086, NULL),
(415, 18, 21, '1:22:24', 38, 119.181, NULL), 
(416, 16, 21, '00:45:08', 30, 171.754, NULL),   
(417, 12, 21, '00:49:17', 30, 157.260, NULL),   
(418, 11, 21, '00:00:00', 0, NULL, NULL),              
(419, 8, 21, '00:00:00', 0, NULL, NULL),              
(420, 19, 22, '1:22:05', 50, 226.523, 25),
(421, 17, 22, '1:22:13', 50, 226.187, 18),
(422, 18, 22, '1:22:17', 50, 225.977, 15),
(423, 7, 22, '1:22:20', 50, 225.868, 12),
(424, 1, 22, '1:22:22', 50, 225.763, 10),
(425, 3, 22, '1:22:49', 50, 224.546, 9),
(426, 20, 22, '1:22:57', 50, 224.186, 6),
(427, 12, 22, '1:23:05', 50, 223.806, 4),
(428, 10, 22, '1:23:08', 50, 223.671, 2),
(429, 5, 22, '1:23:09', 50, 223.658, 1),
(430, 6, 22, '1:23:15', 50, 223.385, NULL),
(431, 9, 22, '1:23:15', 50, 223.358, NULL),
(432, 23, 22, '1:23:20', 50, 223.167, NULL),
(433, 16, 22, '1:23:21', 50, 223.118, NULL),
(434, 8, 22, '1:23:30', 50, 222.721, NULL),
(435, 13, 22, '1:23:36', 50, 222.414, NULL),
(436, 14, 22, '1:22:08', 49, 221.899, NULL), 
(437, 24, 22, '1:22:17', 49, 221.484, NULL), 
(438, 11, 22, '00:42:12', 25, 220.282, NULL),   
(439, 4, 22, '00:25:36', 15, 217.650, NULL);  