-- Create the CollegeStudents table
CREATE TABLE CollegeStudents(
    StudentID INT PRIMARY KEY,
    FirstName VARCHAR(50),
    LastName VARCHAR(50)
    );

-- Insert data into CollegeStudents
INSERT INTO CollegeStudents (StudentID, FirstName, LastName)
VALUES
(1, 'Jolly', 'Roger'),
(2, 'ShriyanReddy', 'Kallem'),
(3, 'Winhard', 'Acom'),
(4, 'John', 'Tatum'),
(5, 'Bahony', 'Malon');

-- Display all college students
SELECT * FROM CollegeStudents;

-- Create the Injuries table
CREATE TABLE Injuries (
    StudentID INT PRIMARY KEY,
    InjuryType VARCHAR(100),
    BodyPart VARCHAR(100),
    Treated BOOLEAN
);

-- Insert data into Injuries
INSERT INTO Injuries (StudentID, InjuryType, BodyPart, Treated)
VALUES
(1, 'Bruise', 'Left knee', TRUE),
(2, 'Scratch', 'Right knee', TRUE),
(3, 'Scratch', 'Face', FALSE),
(4, 'Paper cut', 'Right hand', TRUE),
(5, 'Cut', 'Right hand', TRUE);

-- Display all injuries
SELECT * FROM Injuries;

-- Update the treatment status for StudentID 3
UPDATE Injuries
SET Treated = TRUE
WHERE StudentID = 3;

-- Display the updated injuries table
SELECT * FROM Injuries;