CREATE TABLE Manufacturers (
    ManufacturerID INT PRIMARY KEY,
    Name VARCHAR(255),
    Country VARCHAR(255)
);

CREATE TABLE Drugs (
    DrugID INT PRIMARY KEY,
    Name VARCHAR(255),
    ManufacturerID INT,
    Cost INT,
    FOREIGN KEY (ManufacturerID) REFERENCES Manufacturers(ManufacturerID)
);

CREATE TABLE Trials (
    TrialID INT PRIMARY KEY,
    DrugID INT,
    StartDate DATE,
    EndDate DATE,
    FOREIGN KEY (DrugID) REFERENCES Drugs(DrugID)
);

CREATE TABLE Patients (
    PatientID INT PRIMARY KEY,
    Name VARCHAR(255),
    Age INT,
    Gender VARCHAR(10),
    -- 1 denotes healthy, 0 denotes unhealthy 
    Healthy INT CHECK (Healthy BETWEEN 0 AND 1),
    -- Caucasian, African American, Asian, Hispanic
    Race VARCHAR(255)
);

CREATE TABLE TrialResults (
    TrialID INT,
    PatientID INT,
    Result VARCHAR(255),
    FOREIGN KEY (TrialID) REFERENCES Trials(TrialID),
    FOREIGN KEY (PatientID) REFERENCES Patients(PatientID),
    PRIMARY KEY (TrialID, PatientID)
);

INSERT INTO Manufacturers VALUES (1, 'Johnson & Johnson', 'US');
INSERT INTO Manufacturers VALUES (2, 'Pfizer', 'US');
INSERT INTO Manufacturers VALUES (3, 'Roche', 'CH');
INSERT INTO Manufacturers VALUES (4, 'Abbvie', 'US');
INSERT INTO Manufacturers VALUES (5, 'Novartis', 'CH');
INSERT INTO Manufacturers VALUES (6, 'Merck', 'US');
INSERT INTO Manufacturers VALUES (7, 'Bristol Myers Squibb', 'US');
INSERT INTO Manufacturers VALUES (8, 'GlaxoSmithKline', 'UK');
INSERT INTO Manufacturers VALUES (9, 'Sanofi', 'FR');
INSERT INTO Manufacturers VALUES (10, 'AstraZeneca', 'UK');
INSERT INTO Manufacturers VALUES (11, 'Takeda', 'JP');
INSERT INTO Manufacturers VALUES (12, 'Eli Lilly', 'US');
INSERT INTO Manufacturers VALUES (13, 'Bayer', 'DE');
INSERT INTO Manufacturers VALUES (14, 'Gilead Sciences', 'US');
INSERT INTO Manufacturers VALUES (15, 'Amgen', 'US');
INSERT INTO Manufacturers VALUES (16, 'Boehringer Ingelheim', 'DE');
INSERT INTO Manufacturers VALUES (17, 'Novo Nordisk', 'DK');
INSERT INTO Manufacturers VALUES (18, 'BioNTech', 'DE');
INSERT INTO Manufacturers VALUES (19, 'Moderna', 'US');
INSERT INTO Manufacturers VALUES (20, 'Viatris', 'US');

INSERT INTO Drugs VALUES (1, 'Tylenol', 1, 5);
INSERT INTO Drugs VALUES (2, 'Motrin', 1, 8);
INSERT INTO Drugs VALUES (3, 'Benadryl', 1, 6);
INSERT INTO Drugs VALUES (4, 'Zyrtec', 1, 7);
INSERT INTO Drugs VALUES (5, 'Pepcid', 1, 4);
INSERT INTO Drugs VALUES (6, 'Lipitor', 2, 15);
INSERT INTO Drugs VALUES (7, 'Viagra', 2, 20);
INSERT INTO Drugs VALUES (8, 'Xanax', 2, 12);
INSERT INTO Drugs VALUES (9, 'Zoloft', 2, 10);
INSERT INTO Drugs VALUES (10, 'Celebrex', 2, 18);
INSERT INTO Drugs VALUES (11, 'Avastin', 3, 50);
INSERT INTO Drugs VALUES (12, 'Herceptin', 3, 45);
INSERT INTO Drugs VALUES (13, 'Rituxan', 3, 40);
INSERT INTO Drugs VALUES (14, 'Xeloda', 3, 30);
INSERT INTO Drugs VALUES (15, 'Tarceva', 3, 35);
INSERT INTO Drugs VALUES (16, 'Humira', 4, 55);
INSERT INTO Drugs VALUES (17, 'Imbruvica', 4, 60);
INSERT INTO Drugs VALUES (18, 'Venclexta', 4, 52);
INSERT INTO Drugs VALUES (19, 'Rinvoq', 4, 58);
INSERT INTO Drugs VALUES (20, 'Skyrizi', 4, 48);
INSERT INTO Drugs VALUES (21, 'Gleevec', 5, 42);
INSERT INTO Drugs VALUES (22, 'Diovan', 5, 30);
INSERT INTO Drugs VALUES (23, 'Sandostatin', 5, 25);
INSERT INTO Drugs VALUES (24, 'Zometa', 5, 35);
INSERT INTO Drugs VALUES (25, 'Femara', 5, 28);
INSERT INTO Drugs VALUES (26, 'Januvia', 6, 20);
INSERT INTO Drugs VALUES (27, 'Keytruda', 6, 65);
INSERT INTO Drugs VALUES (28, 'Gardasil', 6, 55);
INSERT INTO Drugs VALUES (29, 'ProQuad', 6, 40);
INSERT INTO Drugs VALUES (30, 'Zetia', 6, 30);
INSERT INTO Drugs VALUES (31, 'Opdivo', 7, 70);
INSERT INTO Drugs VALUES (32, 'Eliquis', 7, 62);
INSERT INTO Drugs VALUES (33, 'Yervoy', 7, 75);
INSERT INTO Drugs VALUES (34, 'Sprycel', 7, 58);
INSERT INTO Drugs VALUES (35, 'Reyataz', 7, 68);
INSERT INTO Drugs VALUES (36, 'Augmentin', 8, 18);
INSERT INTO Drugs VALUES (37, 'Advair Diskus', 8, 65);
INSERT INTO Drugs VALUES (38, 'Lamictal', 8, 40);
INSERT INTO Drugs VALUES (39, 'Zofran', 8, 30);
INSERT INTO Drugs VALUES (40, 'Imitrex', 8, 25);
INSERT INTO Drugs VALUES (41, 'Lantus', 9, 30);
INSERT INTO Drugs VALUES (42, 'Plavix', 9, 42);
INSERT INTO Drugs VALUES (43, 'Aubagio', 9, 38);
INSERT INTO Drugs VALUES (44, 'Toujeo', 9, 35);
INSERT INTO Drugs VALUES (45, 'Eloxatin', 9, 50);
INSERT INTO Drugs VALUES (46, 'Tagrisso', 10, 55);
INSERT INTO Drugs VALUES (47, 'Lynparza', 10, 60);
INSERT INTO Drugs VALUES (48, 'Imfinzi', 10, 52);
INSERT INTO Drugs VALUES (49, 'Faslodex', 10, 58);
INSERT INTO Drugs VALUES (50, 'Zoladex', 10, 48);
INSERT INTO Drugs VALUES (51, 'Entyvio', 11, 70);
INSERT INTO Drugs VALUES (52, 'Ninlaro', 11, 75);
INSERT INTO Drugs VALUES (53, 'Alunbrig', 11, 80);
INSERT INTO Drugs VALUES (54, 'Adcetris', 11, 65);
INSERT INTO Drugs VALUES (55, 'Iclusig', 11, 72);
INSERT INTO Drugs VALUES (57, 'Humalog', 12, 60);
INSERT INTO Drugs VALUES (58, 'Cymbalta', 12, 55);
INSERT INTO Drugs VALUES (59, 'Alimta', 12, 70);
INSERT INTO Drugs VALUES (60, 'Evista', 12, 45);
INSERT INTO Drugs VALUES (61, 'Aspirin', 13, 2);
INSERT INTO Drugs VALUES (62, 'Xarelto', 13, 60);
INSERT INTO Drugs VALUES (63, 'Nexavar', 13, 75);
INSERT INTO Drugs VALUES (64, 'Stivarga', 13, 80);
INSERT INTO Drugs VALUES (65, 'Kogenate', 13, 85);
INSERT INTO Drugs VALUES (66, 'Remdesivir', 14, 90);
INSERT INTO Drugs VALUES (67, 'Sovaldi', 14, 95);
INSERT INTO Drugs VALUES (68, 'Harvoni', 14, 100);
INSERT INTO Drugs VALUES (69, 'Epclusa', 14, 85);
INSERT INTO Drugs VALUES (70, 'Veklury', 14, 92);
INSERT INTO Drugs VALUES (71, 'Enbrel', 15, 55);
INSERT INTO Drugs VALUES (72, 'Neulasta', 15, 65);
INSERT INTO Drugs VALUES (73, 'Prolia', 15, 80);
INSERT INTO Drugs VALUES (74, 'Aranesp', 15, 70);
INSERT INTO Drugs VALUES (75, 'Sensipar', 15, 75);
INSERT INTO Drugs VALUES (76, 'Jardiance', 16, 45);
INSERT INTO Drugs VALUES (77, 'Spiriva', 16, 50);
INSERT INTO Drugs VALUES (78, 'Pradaxa', 16, 60);
INSERT INTO Drugs VALUES (79, 'Ofev', 16, 55);
INSERT INTO Drugs VALUES (80, 'Trajenta', 16, 40);
INSERT INTO Drugs VALUES (81, 'Insulin Aspart', 17, 25);
INSERT INTO Drugs VALUES (82, 'Liraglutide', 17, 30);
INSERT INTO Drugs VALUES (83, 'Semaglutide', 17, 35);
INSERT INTO Drugs VALUES (84, 'Insulin Degludec', 17, 40);
INSERT INTO Drugs VALUES (85, 'Mecasermin', 17, 45);
INSERT INTO Drugs VALUES (86, 'Comirnaty', 18, 50);
INSERT INTO Drugs VALUES (87, 'BNT162b2', 18, 55);
INSERT INTO Drugs VALUES (88, 'BNT111', 18, 60);
INSERT INTO Drugs VALUES (89, 'BNT113', 18, 65);
INSERT INTO Drugs VALUES (90, 'BNT114', 18, 70);
INSERT INTO Drugs VALUES (91, 'mRNA-1273', 19, 75);
INSERT INTO Drugs VALUES (92, 'Moderna COVID-19 Vaccine', 19, 80);
INSERT INTO Drugs VALUES (93, 'mRNA-1647', 19, 85);
INSERT INTO Drugs VALUES (94, 'mRNA-4157', 19, 90);
INSERT INTO Drugs VALUES (95, 'mRNA-1653', 19, 95);
INSERT INTO Drugs VALUES (96, 'Drug A', 20, 100);
INSERT INTO Drugs VALUES (97, 'Drug B', 20, 105);
INSERT INTO Drugs VALUES (98, 'Drug C', 20, 110);
INSERT INTO Drugs VALUES (99, 'Drug D', 20, 115);
INSERT INTO Drugs VALUES (100, 'Drug E', 20, 120);

INSERT INTO Patients VALUES (1, 'John Doe', 45, 'Male', 1, 'Caucasian');
INSERT INTO Patients VALUES (2, 'Jane Smith', 30, 'Female', 1, 'African American');
INSERT INTO Patients VALUES (3, 'Robert Johnson', 60, 'Male', 0, 'Caucasian');
INSERT INTO Patients VALUES (4, 'Mary Williams', 50, 'Female', 1, 'Hispanic');
INSERT INTO Patients VALUES (5, 'James Brown', 35, 'Male', 1, 'Asian');
INSERT INTO Patients VALUES (6, 'Patricia Jones', 40, 'Female', 1, 'Caucasian');
INSERT INTO Patients VALUES (7, 'Michael Miller', 55, 'Male', 0, 'African American');
INSERT INTO Patients VALUES (8, 'Linda Davis', 45, 'Female', 1, 'Hispanic');
INSERT INTO Patients VALUES (9, 'William Garcia', 50, 'Male', 1, 'Asian');
INSERT INTO Patients VALUES (10, 'Elizabeth Martinez', 30, 'Female', 1, 'Caucasian');
INSERT INTO Patients VALUES (11, 'David Rodriguez', 40, 'Male', 1, 'African American');
INSERT INTO Patients VALUES (12, 'Jennifer Wilson', 35, 'Female', 1, 'Hispanic');
INSERT INTO Patients VALUES (13, 'Richard Moore', 60, 'Male', 0, 'Asian');
INSERT INTO Patients VALUES (14, 'Susan Taylor', 55, 'Female', 0, 'Caucasian');
INSERT INTO Patients VALUES (15, 'Joseph Anderson', 45, 'Male', 1, 'African American');
INSERT INTO Patients VALUES (16, 'Margaret Thomas', 50, 'Female', 1, 'Hispanic');
INSERT INTO Patients VALUES (17, 'Charles Jackson', 35, 'Male', 1, 'Asian');
INSERT INTO Patients VALUES (18, 'Jessica White', 40, 'Female', 1, 'Caucasian');
INSERT INTO Patients VALUES (19, 'Thomas Harris', 55, 'Male', 0, 'African American');
INSERT INTO Patients VALUES (20, 'Sarah Martin', 45, 'Female', 1, 'Hispanic');
INSERT INTO Patients VALUES (21, 'Christopher Thompson', 50, 'Male', 1, 'Asian');
INSERT INTO Patients VALUES (22, 'Karen Martinez', 30, 'Female', 1, 'Caucasian');
INSERT INTO Patients VALUES (23, 'Daniel Robinson', 40, 'Male', 1, 'African American');
INSERT INTO Patients VALUES (24, 'Nancy Clark', 35, 'Female', 1, 'Hispanic');
INSERT INTO Patients VALUES (25, 'Paul Rodriguez', 60, 'Male', 0, 'Asian');
INSERT INTO Patients VALUES (26, 'Lisa Lewis', 55, 'Female', 0, 'Caucasian');
INSERT INTO Patients VALUES (27, 'Mark Walker', 45, 'Male', 1, 'African American');
INSERT INTO Patients VALUES (28, 'Betty Hall', 50, 'Female', 1, 'Hispanic');
INSERT INTO Patients VALUES (29, 'Donald Young', 35, 'Male', 1, 'Asian');
INSERT INTO Patients VALUES (30, 'Dorothy Allen', 40, 'Female', 1, 'Caucasian');
INSERT INTO Patients VALUES (31, 'George King', 55, 'Male', 0, 'African American');
INSERT INTO Patients VALUES (32, 'Helen Wright', 45, 'Female', 1, 'Hispanic');
INSERT INTO Patients VALUES (33, 'Kenneth Scott', 50, 'Male', 1, 'Asian');
INSERT INTO Patients VALUES (34, 'Ruth Green', 30, 'Female', 1, 'Caucasian');
INSERT INTO Patients VALUES (35, 'Steven Baker', 40, 'Male', 1, 'African American');
INSERT INTO Patients VALUES (36, 'Sharon Gonzalez', 35, 'Female', 1, 'Hispanic');
INSERT INTO Patients VALUES (37, 'Edward Nelson', 60, 'Male', 0, 'Asian');
INSERT INTO Patients VALUES (38, 'Barbara Carter', 55, 'Female', 0, 'Caucasian');
INSERT INTO Patients VALUES (39, 'Brian Mitchell', 45, 'Male', 1, 'African American');
INSERT INTO Patients VALUES (40, 'Helen Perez', 50, 'Female', 1, 'Hispanic');
INSERT INTO Patients VALUES (41, 'Ronald Roberts', 35, 'Male', 1, 'Asian');
INSERT INTO Patients VALUES (42, 'Diane Turner', 40, 'Female', 1, 'Caucasian');
INSERT INTO Patients VALUES (43, 'Gary Phillips', 55, 'Male', 0, 'African American');
INSERT INTO Patients VALUES (44, 'Carol Campbell', 45, 'Female', 1, 'Hispanic');
INSERT INTO Patients VALUES (45, 'Frank Parker', 50, 'Male', 1, 'Asian');
INSERT INTO Patients VALUES (46, 'Rebecca Evans', 30, 'Female', 1, 'Caucasian');
INSERT INTO Patients VALUES (47, 'Larry Edwards', 40, 'Male', 1, 'African American');
INSERT INTO Patients VALUES (48, 'Kathleen Collins', 35, 'Female', 1, 'Hispanic');
INSERT INTO Patients VALUES (49, 'Gregory Stewart', 60, 'Male', 0, 'Asian');
INSERT INTO Patients VALUES (50, 'Gloria Morris', 55, 'Female', 0, 'Caucasian');


INSERT INTO Trials VALUES (1, 1, '2020-01-01', '2020-12-31');
INSERT INTO Trials VALUES (2, 2, '2020-02-01', '2020-12-31');
INSERT INTO Trials VALUES (3, 3, '2020-03-01', '2020-12-31');
INSERT INTO Trials VALUES (4, 4, '2020-04-01', '2020-12-31');
INSERT INTO Trials VALUES (5, 5, '2020-05-01', '2020-12-31');
INSERT INTO Trials VALUES (6, 6, '2020-06-01', '2020-12-31');
INSERT INTO Trials VALUES (7, 7, '2020-07-01', '2020-12-31');
INSERT INTO Trials VALUES (8, 8, '2020-08-01', '2020-12-31');
INSERT INTO Trials VALUES (9, 9, '2020-09-01', '2020-12-31');
INSERT INTO Trials VALUES (10, 10, '2020-10-01', '2020-12-31');
INSERT INTO Trials VALUES (11, 11, '2020-11-01', '2020-12-31');
INSERT INTO Trials VALUES (12, 12, '2020-12-01', '2020-12-31');
INSERT INTO Trials VALUES (13, 13, '2021-01-01', '2021-12-31');
INSERT INTO Trials VALUES (14, 14, '2021-02-01', '2021-12-31');
INSERT INTO Trials VALUES (15, 15, '2021-03-01', '2021-12-31');
INSERT INTO Trials VALUES (16, 16, '2021-04-01', '2021-12-31');
INSERT INTO Trials VALUES (17, 17, '2021-05-01', '2021-12-31');
INSERT INTO Trials VALUES (18, 18, '2021-06-01', '2021-12-31');
INSERT INTO Trials VALUES (19, 19, '2021-07-01', '2021-12-31');
INSERT INTO Trials VALUES (20, 20, '2021-08-01', '2021-12-31');
INSERT INTO Trials VALUES (21, 21, '2021-09-01', '2021-12-31');
INSERT INTO Trials VALUES (22, 22, '2021-10-01', '2021-12-31');
INSERT INTO Trials VALUES (23, 23, '2021-11-01', '2021-12-31');
INSERT INTO Trials VALUES (24, 24, '2021-12-01', '2021-12-31');
INSERT INTO Trials VALUES (25, 25, '2022-01-01', '2022-12-31');
INSERT INTO Trials VALUES (26, 26, '2022-02-01', '2022-12-31');
INSERT INTO Trials VALUES (27, 27, '2022-03-01', '2022-12-31');
INSERT INTO Trials VALUES (28, 28, '2022-04-01', '2022-12-31');
INSERT INTO Trials VALUES (29, 29, '2022-05-01', '2022-12-31');
INSERT INTO Trials VALUES (30, 30, '2022-06-01', '2022-12-31');
INSERT INTO Trials VALUES (31, 31, '2022-07-01', '2022-12-31');
INSERT INTO Trials VALUES (32, 32, '2022-08-01', '2022-12-31');
INSERT INTO Trials VALUES (33, 33, '2022-09-01', '2022-12-31');
INSERT INTO Trials VALUES (34, 34, '2022-10-01', '2022-12-31');
INSERT INTO Trials VALUES (35, 35, '2022-11-01', '2022-12-31');
INSERT INTO Trials VALUES (36, 36, '2022-12-01', '2022-12-31');
INSERT INTO Trials VALUES (37, 37, '2023-01-01', '2023-12-31');
INSERT INTO Trials VALUES (38, 38, '2023-02-01', '2023-12-31');
INSERT INTO Trials VALUES (39, 39, '2023-03-01', '2023-12-31');
INSERT INTO Trials VALUES (40, 40, '2023-04-01', '2023-12-31');
INSERT INTO Trials VALUES (41, 41, '2023-05-01', '2023-12-31');
INSERT INTO Trials VALUES (42, 42, '2023-06-01', '2023-12-31');
INSERT INTO Trials VALUES (43, 43, '2023-07-01', '2023-12-31');
INSERT INTO Trials VALUES (44, 44, '2023-08-01', '2023-12-31');
INSERT INTO Trials VALUES (45, 45, '2023-09-01', '2023-12-31');
INSERT INTO Trials VALUES (46, 46, '2023-10-01', '2023-12-31');
INSERT INTO Trials VALUES (47, 47, '2023-11-01', '2023-12-31');
INSERT INTO Trials VALUES (48, 48, '2023-12-01', '2023-12-31');
INSERT INTO Trials VALUES (49, 49, '2024-01-01', '2024-12-31');
INSERT INTO Trials VALUES (50, 50, '2024-02-01', '2024-12-31');
INSERT INTO Trials VALUES (51, 51, '2024-03-01', '2024-12-31');
INSERT INTO Trials VALUES (52, 52, '2024-04-01', '2024-12-31');
INSERT INTO Trials VALUES (53, 53, '2024-05-01', '2024-12-31');
INSERT INTO Trials VALUES (54, 54, '2024-06-01', '2024-12-31');
INSERT INTO Trials VALUES (55, 55, '2024-07-01', '2024-12-31');
INSERT INTO Trials VALUES (56, 56, '2024-08-01', '2024-12-31');
INSERT INTO Trials VALUES (57, 57, '2024-09-01', '2024-12-31');
INSERT INTO Trials VALUES (58, 58, '2024-10-01', '2024-12-31');
INSERT INTO Trials VALUES (59, 59, '2024-11-01', '2024-12-31');
INSERT INTO Trials VALUES (60, 60, '2024-12-01', '2024-12-31');
INSERT INTO Trials VALUES (61, 61, '2025-01-01', '2025-12-31');
INSERT INTO Trials VALUES (62, 62, '2025-02-01', '2025-12-31');
INSERT INTO Trials VALUES (63, 63, '2025-03-01', '2025-12-31');
INSERT INTO Trials VALUES (64, 64, '2025-04-01', '2025-12-31');
INSERT INTO Trials VALUES (65, 65, '2025-05-01', '2025-12-31');
INSERT INTO Trials VALUES (66, 66, '2025-06-01', '2025-12-31');
INSERT INTO Trials VALUES (67, 67, '2025-07-01', '2025-12-31');
INSERT INTO Trials VALUES (68, 68, '2025-08-01', '2025-12-31');
INSERT INTO Trials VALUES (69, 69, '2025-09-01', '2025-12-31');
INSERT INTO Trials VALUES (70, 70, '2025-10-01', '2025-12-31');
INSERT INTO Trials VALUES (71, 71, '2025-11-01', '2025-12-31');
INSERT INTO Trials VALUES (72, 72, '2025-12-01', '2025-12-31');
INSERT INTO Trials VALUES (73, 73, '2026-01-01', '2026-12-31');
INSERT INTO Trials VALUES (74, 74, '2026-02-01', '2026-12-31');
INSERT INTO Trials VALUES (75, 75, '2026-03-01', '2026-12-31');
INSERT INTO Trials VALUES (76, 76, '2026-04-01', '2026-12-31');
INSERT INTO Trials VALUES (77, 77, '2026-05-01', '2026-12-31');
INSERT INTO Trials VALUES (78, 78, '2026-06-01', '2026-12-31');
INSERT INTO Trials VALUES (79, 79, '2026-07-01', '2026-12-31');
INSERT INTO Trials VALUES (80, 80, '2026-08-01', '2026-12-31');
INSERT INTO Trials VALUES (81, 81, '2026-09-01', '2026-12-31');
INSERT INTO Trials VALUES (82, 82, '2026-10-01', '2026-12-31');
INSERT INTO Trials VALUES (83, 83, '2026-11-01', '2026-12-31');
INSERT INTO Trials VALUES (84, 84, '2026-12-01', '2026-12-31');
INSERT INTO Trials VALUES (85, 85, '2027-01-01', '2027-12-31');
INSERT INTO Trials VALUES (86, 86, '2027-02-01', '2027-12-31');
INSERT INTO Trials VALUES (87, 87, '2027-03-01', '2027-12-31');
INSERT INTO Trials VALUES (88, 88, '2027-04-01', '2027-12-31');
INSERT INTO Trials VALUES (89, 89, '2027-05-01', '2027-12-31');
INSERT INTO Trials VALUES (90, 90, '2027-06-01', '2027-12-31');
INSERT INTO Trials VALUES (91, 91, '2027-07-01', '2027-12-31');
INSERT INTO Trials VALUES (92, 92, '2027-08-01', '2027-12-31');
INSERT INTO Trials VALUES (93, 93, '2027-09-01', '2027-12-31');
INSERT INTO Trials VALUES (94, 94, '2027-10-01', '2027-12-31');
INSERT INTO Trials VALUES (95, 95, '2027-11-01', '2027-12-31');
INSERT INTO Trials VALUES (96, 96, '2027-12-01', '2027-12-31');
INSERT INTO Trials VALUES (97, 97, '2028-01-01', '2028-12-31');
INSERT INTO Trials VALUES (98, 98, '2028-02-01', '2028-12-31');
INSERT INTO Trials VALUES (99, 99, '2028-03-01', '2028-12-31');
INSERT INTO Trials VALUES (100, 100, '2028-04-01', '2028-12-31');

INSERT INTO TrialResults VALUES (1, 40, 'Negative');
INSERT INTO TrialResults VALUES (1, 49, 'Positive');
INSERT INTO TrialResults VALUES (2, 25, 'Positive');
INSERT INTO TrialResults VALUES (2, 42, 'Positive');
INSERT INTO TrialResults VALUES (2, 11, 'Negative');
INSERT INTO TrialResults VALUES (2, 23, 'Positive');
INSERT INTO TrialResults VALUES (4, 38, 'Negative');
INSERT INTO TrialResults VALUES (4, 44, 'Positive');
INSERT INTO TrialResults VALUES (4, 16, 'Positive');
INSERT INTO TrialResults VALUES (4, 17, 'Negative');
INSERT INTO TrialResults VALUES (4, 19, 'Negative');
INSERT INTO TrialResults VALUES (5, 7, 'Negative');
INSERT INTO TrialResults VALUES (5, 8, 'Positive');
INSERT INTO TrialResults VALUES (5, 45, 'Positive');
INSERT INTO TrialResults VALUES (5, 18, 'Negative');
INSERT INTO TrialResults VALUES (5, 20, 'Positive');
INSERT INTO TrialResults VALUES (6, 20, 'Positive');
INSERT INTO TrialResults VALUES (7, 50, 'Negative');
INSERT INTO TrialResults VALUES (7, 4, 'Positive');
INSERT INTO TrialResults VALUES (7, 29, 'Positive');
INSERT INTO TrialResults VALUES (7, 38, 'Negative');
INSERT INTO TrialResults VALUES (8, 41, 'Negative');
INSERT INTO TrialResults VALUES (8, 27, 'Negative');
INSERT INTO TrialResults VALUES (8, 43, 'Negative');
INSERT INTO TrialResults VALUES (8, 23, 'Positive');
INSERT INTO TrialResults VALUES (9, 50, 'Negative');
INSERT INTO TrialResults VALUES (9, 11, 'Positive');
INSERT INTO TrialResults VALUES (9, 39, 'Negative');
INSERT INTO TrialResults VALUES (10, 41, 'Negative');
INSERT INTO TrialResults VALUES (10, 1, 'Negative');
INSERT INTO TrialResults VALUES (12, 34, 'Negative');
INSERT INTO TrialResults VALUES (12, 36, 'Positive');
INSERT INTO TrialResults VALUES (12, 5, 'Positive');
INSERT INTO TrialResults VALUES (12, 11, 'Negative');
INSERT INTO TrialResults VALUES (12, 30, 'Negative');
INSERT INTO TrialResults VALUES (13, 39, 'Negative');
INSERT INTO TrialResults VALUES (14, 24, 'Negative');
INSERT INTO TrialResults VALUES (14, 2, 'Negative');
INSERT INTO TrialResults VALUES (14, 28, 'Negative');
INSERT INTO TrialResults VALUES (14, 13, 'Negative');
INSERT INTO TrialResults VALUES (15, 12, 'Negative');
INSERT INTO TrialResults VALUES (15, 29, 'Positive');
INSERT INTO TrialResults VALUES (16, 33, 'Positive');
INSERT INTO TrialResults VALUES (16, 18, 'Positive');
INSERT INTO TrialResults VALUES (16, 12, 'Negative');
INSERT INTO TrialResults VALUES (16, 38, 'Positive');
INSERT INTO TrialResults VALUES (18, 46, 'Positive');
INSERT INTO TrialResults VALUES (18, 26, 'Positive');
INSERT INTO TrialResults VALUES (18, 22, 'Negative');
INSERT INTO TrialResults VALUES (19, 24, 'Positive');
INSERT INTO TrialResults VALUES (19, 27, 'Negative');
INSERT INTO TrialResults VALUES (19, 21, 'Negative');
INSERT INTO TrialResults VALUES (20, 33, 'Positive');
INSERT INTO TrialResults VALUES (20, 3, 'Positive');
INSERT INTO TrialResults VALUES (20, 12, 'Positive');
INSERT INTO TrialResults VALUES (20, 45, 'Negative');
INSERT INTO TrialResults VALUES (20, 26, 'Negative');
INSERT INTO TrialResults VALUES (21, 48, 'Negative');
INSERT INTO TrialResults VALUES (21, 19, 'Positive');
INSERT INTO TrialResults VALUES (22, 38, 'Positive');
INSERT INTO TrialResults VALUES (23, 35, 'Negative');
INSERT INTO TrialResults VALUES (23, 8, 'Positive');
INSERT INTO TrialResults VALUES (23, 46, 'Positive');
INSERT INTO TrialResults VALUES (23, 15, 'Negative');
INSERT INTO TrialResults VALUES (23, 30, 'Positive');
INSERT INTO TrialResults VALUES (24, 42, 'Positive');
INSERT INTO TrialResults VALUES (24, 11, 'Positive');
INSERT INTO TrialResults VALUES (24, 45, 'Positive');
INSERT INTO TrialResults VALUES (24, 17, 'Negative');
INSERT INTO TrialResults VALUES (24, 50, 'Negative');
INSERT INTO TrialResults VALUES (26, 5, 'Positive');
INSERT INTO TrialResults VALUES (27, 50, 'Negative');
INSERT INTO TrialResults VALUES (27, 20, 'Negative');
INSERT INTO TrialResults VALUES (27, 36, 'Positive');
INSERT INTO TrialResults VALUES (28, 49, 'Positive');
INSERT INTO TrialResults VALUES (28, 2, 'Negative');
INSERT INTO TrialResults VALUES (29, 1, 'Negative');
INSERT INTO TrialResults VALUES (29, 34, 'Negative');
INSERT INTO TrialResults VALUES (29, 42, 'Negative');
INSERT INTO TrialResults VALUES (29, 14, 'Negative');
INSERT INTO TrialResults VALUES (29, 48, 'Positive');
INSERT INTO TrialResults VALUES (29, 49, 'Positive');
INSERT INTO TrialResults VALUES (32, 40, 'Negative');
INSERT INTO TrialResults VALUES (32, 26, 'Negative');
INSERT INTO TrialResults VALUES (32, 36, 'Positive');
INSERT INTO TrialResults VALUES (32, 23, 'Positive');
INSERT INTO TrialResults VALUES (33, 42, 'Positive');
INSERT INTO TrialResults VALUES (33, 21, 'Negative');
INSERT INTO TrialResults VALUES (34, 1, 'Positive');
INSERT INTO TrialResults VALUES (35, 1, 'Negative');
INSERT INTO TrialResults VALUES (35, 33, 'Negative');
INSERT INTO TrialResults VALUES (35, 15, 'Positive');
INSERT INTO TrialResults VALUES (35, 49, 'Positive');
INSERT INTO TrialResults VALUES (35, 50, 'Negative');
INSERT INTO TrialResults VALUES (35, 23, 'Positive');
INSERT INTO TrialResults VALUES (35, 30, 'Negative');
INSERT INTO TrialResults VALUES (36, 5, 'Negative');
INSERT INTO TrialResults VALUES (36, 9, 'Negative');
INSERT INTO TrialResults VALUES (36, 42, 'Positive');
INSERT INTO TrialResults VALUES (36, 12, 'Negative');
INSERT INTO TrialResults VALUES (36, 16, 'Positive');
INSERT INTO TrialResults VALUES (36, 23, 'Positive');
INSERT INTO TrialResults VALUES (36, 31, 'Positive');
INSERT INTO TrialResults VALUES (37, 19, 'Positive');
INSERT INTO TrialResults VALUES (37, 45, 'Negative');
INSERT INTO TrialResults VALUES (38, 49, 'Negative');
INSERT INTO TrialResults VALUES (38, 39, 'Negative');
INSERT INTO TrialResults VALUES (40, 42, 'Negative');
INSERT INTO TrialResults VALUES (40, 12, 'Positive');
INSERT INTO TrialResults VALUES (40, 20, 'Negative');
INSERT INTO TrialResults VALUES (41, 9, 'Negative');
INSERT INTO TrialResults VALUES (41, 46, 'Positive');
INSERT INTO TrialResults VALUES (41, 17, 'Positive');
INSERT INTO TrialResults VALUES (41, 23, 'Positive');
INSERT INTO TrialResults VALUES (41, 26, 'Negative');
INSERT INTO TrialResults VALUES (42, 1, 'Negative');
INSERT INTO TrialResults VALUES (42, 35, 'Positive');
INSERT INTO TrialResults VALUES (42, 36, 'Negative');
INSERT INTO TrialResults VALUES (42, 37, 'Positive');
INSERT INTO TrialResults VALUES (42, 39, 'Positive');
INSERT INTO TrialResults VALUES (42, 47, 'Negative');
INSERT INTO TrialResults VALUES (42, 18, 'Positive');
INSERT INTO TrialResults VALUES (43, 32, 'Negative');
INSERT INTO TrialResults VALUES (43, 2, 'Positive');
INSERT INTO TrialResults VALUES (43, 44, 'Positive');
INSERT INTO TrialResults VALUES (43, 36, 'Positive');
INSERT INTO TrialResults VALUES (44, 2, 'Positive');
INSERT INTO TrialResults VALUES (44, 6, 'Negative');
INSERT INTO TrialResults VALUES (44, 13, 'Negative');
INSERT INTO TrialResults VALUES (44, 20, 'Negative');
INSERT INTO TrialResults VALUES (44, 21, 'Positive');
INSERT INTO TrialResults VALUES (44, 23, 'Positive');
INSERT INTO TrialResults VALUES (45, 48, 'Positive');
INSERT INTO TrialResults VALUES (45, 33, 'Negative');
INSERT INTO TrialResults VALUES (45, 38, 'Positive');
INSERT INTO TrialResults VALUES (47, 1, 'Negative');
INSERT INTO TrialResults VALUES (47, 33, 'Negative');
INSERT INTO TrialResults VALUES (47, 34, 'Negative');
INSERT INTO TrialResults VALUES (47, 41, 'Negative');
INSERT INTO TrialResults VALUES (47, 43, 'Negative');
INSERT INTO TrialResults VALUES (47, 19, 'Positive');
INSERT INTO TrialResults VALUES (47, 29, 'Negative');
INSERT INTO TrialResults VALUES (49, 40, 'Negative');
INSERT INTO TrialResults VALUES (49, 3, 'Negative');
INSERT INTO TrialResults VALUES (49, 38, 'Positive');
INSERT INTO TrialResults VALUES (49, 23, 'Negative');
INSERT INTO TrialResults VALUES (50, 2, 'Negative');
INSERT INTO TrialResults VALUES (50, 38, 'Negative');
INSERT INTO TrialResults VALUES (50, 7, 'Negative');
INSERT INTO TrialResults VALUES (50, 40, 'Positive');
INSERT INTO TrialResults VALUES (50, 19, 'Positive');
INSERT INTO TrialResults VALUES (52, 11, 'Positive');
INSERT INTO TrialResults VALUES (52, 4, 'Negative');
INSERT INTO TrialResults VALUES (52, 20, 'Positive');
INSERT INTO TrialResults VALUES (52, 38, 'Positive');
INSERT INTO TrialResults VALUES (53, 1, 'Positive');
INSERT INTO TrialResults VALUES (53, 35, 'Negative');
INSERT INTO TrialResults VALUES (53, 44, 'Negative');
INSERT INTO TrialResults VALUES (53, 45, 'Positive');
INSERT INTO TrialResults VALUES (53, 17, 'Negative');
INSERT INTO TrialResults VALUES (54, 13, 'Positive');
INSERT INTO TrialResults VALUES (54, 39, 'Positive');
INSERT INTO TrialResults VALUES (55, 25, 'Negative');
INSERT INTO TrialResults VALUES (55, 45, 'Negative');
INSERT INTO TrialResults VALUES (56, 8, 'Positive');
INSERT INTO TrialResults VALUES (56, 23, 'Negative');
INSERT INTO TrialResults VALUES (58, 32, 'Negative');
INSERT INTO TrialResults VALUES (58, 6, 'Positive');
INSERT INTO TrialResults VALUES (58, 41, 'Negative');
INSERT INTO TrialResults VALUES (58, 44, 'Positive');
INSERT INTO TrialResults VALUES (58, 23, 'Positive');
INSERT INTO TrialResults VALUES (58, 28, 'Negative');
INSERT INTO TrialResults VALUES (58, 29, 'Positive');
INSERT INTO TrialResults VALUES (59, 3, 'Positive');
INSERT INTO TrialResults VALUES (59, 6, 'Negative');
INSERT INTO TrialResults VALUES (59, 10, 'Negative');
INSERT INTO TrialResults VALUES (59, 43, 'Negative');
INSERT INTO TrialResults VALUES (59, 46, 'Negative');
INSERT INTO TrialResults VALUES (59, 26, 'Negative');
INSERT INTO TrialResults VALUES (60, 24, 'Positive');
INSERT INTO TrialResults VALUES (60, 25, 'Positive');
INSERT INTO TrialResults VALUES (60, 35, 'Negative');
INSERT INTO TrialResults VALUES (60, 4, 'Negative');
INSERT INTO TrialResults VALUES (62, 32, 'Positive');
INSERT INTO TrialResults VALUES (62, 37, 'Negative');
INSERT INTO TrialResults VALUES (62, 14, 'Positive');
INSERT INTO TrialResults VALUES (62, 48, 'Negative');
INSERT INTO TrialResults VALUES (62, 25, 'Positive');
INSERT INTO TrialResults VALUES (63, 32, 'Negative');
INSERT INTO TrialResults VALUES (63, 12, 'Positive');
INSERT INTO TrialResults VALUES (63, 31, 'Negative');
INSERT INTO TrialResults VALUES (63, 47, 'Positive');
INSERT INTO TrialResults VALUES (64, 2, 'Positive');
INSERT INTO TrialResults VALUES (64, 5, 'Negative');
INSERT INTO TrialResults VALUES (64, 10, 'Negative');
INSERT INTO TrialResults VALUES (64, 42, 'Positive');
INSERT INTO TrialResults VALUES (64, 49, 'Positive');
INSERT INTO TrialResults VALUES (64, 27, 'Negative');
INSERT INTO TrialResults VALUES (65, 41, 'Positive');
INSERT INTO TrialResults VALUES (66, 16, 'Negative');
INSERT INTO TrialResults VALUES (67, 27, 'Negative');
INSERT INTO TrialResults VALUES (67, 21, 'Negative');
INSERT INTO TrialResults VALUES (67, 3, 'Positive');
INSERT INTO TrialResults VALUES (67, 45, 'Positive');
INSERT INTO TrialResults VALUES (68, 18, 'Positive');
INSERT INTO TrialResults VALUES (68, 5, 'Positive');
INSERT INTO TrialResults VALUES (68, 13, 'Positive');
INSERT INTO TrialResults VALUES (68, 46, 'Negative');
INSERT INTO TrialResults VALUES (69, 7, 'Negative');
INSERT INTO TrialResults VALUES (70, 39, 'Positive');
INSERT INTO TrialResults VALUES (71, 31, 'Negative');
INSERT INTO TrialResults VALUES (72, 10, 'Positive');
INSERT INTO TrialResults VALUES (72, 15, 'Positive');
INSERT INTO TrialResults VALUES (73, 41, 'Positive');
INSERT INTO TrialResults VALUES (73, 15, 'Positive');
INSERT INTO TrialResults VALUES (73, 50, 'Positive');
INSERT INTO TrialResults VALUES (73, 28, 'Positive');
INSERT INTO TrialResults VALUES (73, 31, 'Positive');
INSERT INTO TrialResults VALUES (74, 1, 'Positive');
INSERT INTO TrialResults VALUES (74, 42, 'Positive');
INSERT INTO TrialResults VALUES (74, 22, 'Negative');
INSERT INTO TrialResults VALUES (74, 47, 'Negative');
INSERT INTO TrialResults VALUES (75, 41, 'Negative');
INSERT INTO TrialResults VALUES (75, 28, 'Negative');
INSERT INTO TrialResults VALUES (75, 39, 'Negative');
INSERT INTO TrialResults VALUES (75, 47, 'Positive');
INSERT INTO TrialResults VALUES (76, 34, 'Negative');
INSERT INTO TrialResults VALUES (76, 37, 'Negative');
INSERT INTO TrialResults VALUES (76, 6, 'Negative');
INSERT INTO TrialResults VALUES (76, 39, 'Positive');
INSERT INTO TrialResults VALUES (76, 15, 'Negative');
INSERT INTO TrialResults VALUES (76, 31, 'Positive');
INSERT INTO TrialResults VALUES (77, 45, 'Negative');
INSERT INTO TrialResults VALUES (77, 49, 'Negative');
INSERT INTO TrialResults VALUES (77, 22, 'Negative');
INSERT INTO TrialResults VALUES (77, 29, 'Negative');
INSERT INTO TrialResults VALUES (77, 30, 'Negative');
INSERT INTO TrialResults VALUES (78, 8, 'Negative');
INSERT INTO TrialResults VALUES (78, 34, 'Positive');
INSERT INTO TrialResults VALUES (78, 12, 'Negative');
INSERT INTO TrialResults VALUES (78, 31, 'Negative');
INSERT INTO TrialResults VALUES (79, 17, 'Negative');
INSERT INTO TrialResults VALUES (79, 50, 'Negative');
INSERT INTO TrialResults VALUES (79, 14, 'Negative');
INSERT INTO TrialResults VALUES (80, 6, 'Positive');
INSERT INTO TrialResults VALUES (80, 40, 'Negative');
INSERT INTO TrialResults VALUES (80, 46, 'Negative');
INSERT INTO TrialResults VALUES (80, 48, 'Negative');
INSERT INTO TrialResults VALUES (80, 22, 'Positive');
INSERT INTO TrialResults VALUES (80, 28, 'Positive');
INSERT INTO TrialResults VALUES (80, 30, 'Negative');
INSERT INTO TrialResults VALUES (81, 35, 'Positive');
INSERT INTO TrialResults VALUES (81, 50, 'Negative');
INSERT INTO TrialResults VALUES (81, 3, 'Positive');
INSERT INTO TrialResults VALUES (81, 37, 'Positive');
INSERT INTO TrialResults VALUES (82, 14, 'Positive');
INSERT INTO TrialResults VALUES (82, 17, 'Positive');
INSERT INTO TrialResults VALUES (82, 49, 'Positive');
INSERT INTO TrialResults VALUES (82, 21, 'Positive');
INSERT INTO TrialResults VALUES (82, 24, 'Positive');
INSERT INTO TrialResults VALUES (82, 30, 'Positive');
INSERT INTO TrialResults VALUES (83, 17, 'Negative');
INSERT INTO TrialResults VALUES (83, 45, 'Positive');
INSERT INTO TrialResults VALUES (83, 37, 'Negative');
INSERT INTO TrialResults VALUES (84, 49, 'Negative');
INSERT INTO TrialResults VALUES (84, 7, 'Positive');
INSERT INTO TrialResults VALUES (85, 2, 'Negative');
INSERT INTO TrialResults VALUES (85, 38, 'Positive');
INSERT INTO TrialResults VALUES (86, 3, 'Positive');
INSERT INTO TrialResults VALUES (86, 5, 'Negative');
INSERT INTO TrialResults VALUES (86, 38, 'Positive');
INSERT INTO TrialResults VALUES (87, 30, 'Negative');
INSERT INTO TrialResults VALUES (88, 1, 'Positive');
INSERT INTO TrialResults VALUES (89, 34, 'Positive');
INSERT INTO TrialResults VALUES (89, 4, 'Negative');
INSERT INTO TrialResults VALUES (89, 39, 'Positive');
INSERT INTO TrialResults VALUES (89, 21, 'Negative');
INSERT INTO TrialResults VALUES (89, 25, 'Positive');
INSERT INTO TrialResults VALUES (89, 26, 'Negative');
INSERT INTO TrialResults VALUES (89, 29, 'Negative');
INSERT INTO TrialResults VALUES (90, 32, 'Negative');
INSERT INTO TrialResults VALUES (90, 2, 'Positive');
INSERT INTO TrialResults VALUES (90, 5, 'Negative');
INSERT INTO TrialResults VALUES (90, 46, 'Positive');
INSERT INTO TrialResults VALUES (90, 19, 'Positive');
INSERT INTO TrialResults VALUES (93, 32, 'Positive');
INSERT INTO TrialResults VALUES (93, 33, 'Negative');
INSERT INTO TrialResults VALUES (93, 43, 'Positive');
INSERT INTO TrialResults VALUES (94, 10, 'Positive');
INSERT INTO TrialResults VALUES (94, 42, 'Positive');
INSERT INTO TrialResults VALUES (95, 8, 'Positive');
INSERT INTO TrialResults VALUES (95, 29, 'Negative');
INSERT INTO TrialResults VALUES (96, 8, 'Negative');
INSERT INTO TrialResults VALUES (96, 44, 'Negative');
INSERT INTO TrialResults VALUES (96, 14, 'Negative');
INSERT INTO TrialResults VALUES (96, 6, 'Positive');
INSERT INTO TrialResults VALUES (97, 8, 'Negative');
INSERT INTO TrialResults VALUES (97, 46, 'Negative');
INSERT INTO TrialResults VALUES (97, 15, 'Positive');
INSERT INTO TrialResults VALUES (97, 17, 'Negative');
INSERT INTO TrialResults VALUES (97, 20, 'Negative');
INSERT INTO TrialResults VALUES (98, 34, 'Positive');
INSERT INTO TrialResults VALUES (98, 4, 'Positive');
INSERT INTO TrialResults VALUES (98, 16, 'Positive');
INSERT INTO TrialResults VALUES (98, 49, 'Positive');
INSERT INTO TrialResults VALUES (98, 26, 'Positive');
INSERT INTO TrialResults VALUES (100, 2, 'Positive');
INSERT INTO TrialResults VALUES (100, 34, 'Positive');
INSERT INTO TrialResults VALUES (100, 18, 'Negative');
INSERT INTO TrialResults VALUES (100, 37, 'Negative');