-- Ensure the table does not already exist to allow a clean creation
IF OBJECT_ID('dbo.CyclistRecords', 'U') IS NOT NULL
    DROP TABLE dbo.CyclistRecords;
GO

CREATE TABLE dbo.CyclistRecords (
    RecordID INT IDENTITY(1,1) PRIMARY KEY,       -- Unique identifier for each record
    CyclistName VARCHAR(100) NOT NULL,             -- Name of the cyclist
    BibNumber INT NOT NULL,                        -- Race bib number for identification
    LapNumber INT NOT NULL,                        -- Lap number (1 through 5)
    LapTime DECIMAL(6,3) NOT NULL,                 -- Lap time in seconds (precision to milliseconds)
    BikeKit VARCHAR(100) NOT NULL,                 -- Description of the bike kit (brand, model, color, etc.)
    CrossingTimestamp DATETIME NOT NULL,           -- Timestamp marking when the cyclist crossed the critical bend
    Comments VARCHAR(255) NULL                     -- Optional field for any additional observations
);
GO




-- Insert 40 imaginative records into CyclistRecords

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('John Doe', 101, 1, 62.123, 'Specialized S-Works', '2025-03-09 09:00:00', 'Focuses on interval training and speed bursts.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Jane Smith', 102, 1, 64.456, 'Cannondale SuperSix', '2025-03-09 09:00:30', 'Loves long endurance rides to build stamina.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Robert Brown', 103, 1, 63.789, 'Trek Emonda', '2025-03-09 09:01:00', 'Mixes interval training with recovery rides.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Emily Davis', 104, 2, 61.234, 'Giant TCR', '2025-03-09 09:01:30', 'Focuses on consistent performance with targeted training.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Michael Johnson', 105, 2, 60.987, 'Bianchi Oltre', '2025-03-09 09:02:00', 'Adopts structured training routines for big races.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Sarah Wilson', 106, 2, 62.500, 'Scott Addict', '2025-03-09 09:02:30', 'Prepares with mixed intensity sessions and hill repeats.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('David Lee', 107, 3, 59.875, 'Cervelo R5', '2025-03-09 09:03:00', 'Integrates sprint intervals into daily training.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Anna Martin', 108, 3, 65.432, 'Pinarello Dogma', '2025-03-09 09:03:30', 'Focuses on endurance and recovery techniques.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Peter Clark', 109, 3, 63.210, 'Specialized S-Works', '2025-03-09 09:04:00', 'Believes in comprehensive training for optimal performance.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Lucy Taylor', 110, 4, 61.678, 'Cannondale SuperSix', '2025-03-09 09:04:30', 'Practices interval and endurance rides equally.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Mark Harris', 111, 4, 60.345, 'Trek Emonda', '2025-03-09 09:05:00', 'Emphasizes speed training with targeted sprints.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Olivia Thompson', 112, 4, 62.987, 'Giant TCR', '2025-03-09 09:05:30', 'Engages in structured training sessions before races.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Daniel Lewis', 113, 5, 59.999, 'Bianchi Oltre', '2025-03-09 09:06:00', 'Focuses on high-intensity interval training routines.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Sophia Walker', 114, 5, 64.111, 'Scott Addict', '2025-03-09 09:06:30', 'Incorporates both endurance and sprint training in her routine.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('James Young', 115, 1, 63.456, 'Cervelo R5', '2025-03-09 09:07:00', 'Believes rigorous sprint sessions are key to success.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Grace Hall', 116, 1, 61.234, 'Pinarello Dogma', '2025-03-09 09:07:30', 'Pre-race training is centered on endurance and recovery.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Andrew King', 117, 2, 62.345, 'Specialized S-Works', '2025-03-09 09:08:00', 'Combines strength and interval training effectively.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Chloe Wright', 118, 2, 60.789, 'Cannondale SuperSix', '2025-03-09 09:08:30', 'Pursues rigorous hill climbs and sprint workouts.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Matthew Scott', 119, 2, 63.567, 'Trek Emonda', '2025-03-09 09:09:00', 'Believes in structured and consistent training sessions.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Megan Adams', 120, 3, 61.234, 'Giant TCR', '2025-03-09 09:09:30', 'Focuses on endurance rides and interval training.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Christopher Allen', 121, 3, 64.999, 'Bianchi Oltre', '2025-03-09 09:10:00', 'Loves to combine technical training with endurance.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Samantha Turner', 122, 3, 62.345, 'Scott Addict', '2025-03-09 09:10:30', 'Prepares with high-intensity intervals and recovery runs.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Kevin Roberts', 123, 4, 60.111, 'Cervelo R5', '2025-03-09 09:11:00', 'Incorporates sprint training and endurance rides in his regimen.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Victoria Parker', 124, 4, 63.222, 'Pinarello Dogma', '2025-03-09 09:11:30', 'Works hard on interval training and hill repeats.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Brian Campbell', 125, 4, 61.567, 'Specialized S-Works', '2025-03-09 09:12:00', 'Combines steady endurance rides with high-speed sprints.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Natalie Mitchell', 126, 5, 62.890, 'Cannondale SuperSix', '2025-03-09 09:12:30', 'Prepares for races with rigorous interval and recovery training.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Stephen Moore', 127, 5, 60.456, 'Trek Emonda', '2025-03-09 09:13:00', 'Focuses on precision and speed during his training sessions.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Laura Hill', 128, 5, 64.001, 'Giant TCR', '2025-03-09 09:13:30', 'Loves combining long rides with high-intensity intervals.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Paul Evans', 129, 1, 61.789, 'Bianchi Oltre', '2025-03-09 09:14:00', 'Structures his training around endurance and sprint drills.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Hannah Collins', 130, 1, 63.333, 'Scott Addict', '2025-03-09 09:14:30', 'Incorporates mixed training sessions with a focus on recovery.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Jason Stewart', 131, 2, 60.777, 'Cervelo R5', '2025-03-09 09:15:00', 'Emphasizes high-speed intervals and endurance practices.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Rebecca Carter', 132, 2, 62.890, 'Pinarello Dogma', '2025-03-09 09:15:30', 'Focuses on interval training to improve race times.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Timothy Richardson', 133, 3, 61.234, 'Specialized S-Works', '2025-03-09 09:16:00', 'Trains with a mix of hill climbs and sprint intervals.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Amber Bailey', 134, 3, 63.876, 'Cannondale SuperSix', '2025-03-09 09:16:30', 'Believes consistent interval training is key to performance.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Patrick Cooper', 135, 3, 60.999, 'Trek Emonda', '2025-03-09 09:17:00', 'Loves high-intensity workouts to prepare for big races.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Zoe Richardson', 136, 4, 62.345, 'Giant TCR', '2025-03-09 09:17:30', 'Focuses on a blend of speed work and endurance rides.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Gary Morris', 137, 4, 61.112, 'Bianchi Oltre', '2025-03-09 09:18:00', 'Combines structured interval training with endurance workouts.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Stella Reed', 138, 4, 63.456, 'Scott Addict', '2025-03-09 09:18:30', 'Prepares for races with a mix of intervals and recovery rides.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Derek Morgan', 139, 5, 60.888, 'Cervelo R5', '2025-03-09 09:19:00', 'Utilizes high-intensity training and precise interval sessions.');

INSERT INTO dbo.CyclistRecords (CyclistName, BibNumber, LapNumber, LapTime, BikeKit, CrossingTimestamp, Comments) VALUES 
('Fiona Gallagher', 140, 5, 62.555, 'Pinarello Dogma', '2025-03-09 09:19:30', 'Focuses on targeted interval training and endurance drills.');
