CREATE TABLE College_Students (
    Student_id INT PRIMARY KEY,
    Name VARCHAR(50),
    Age INT,
    Grade VARCHAR(50)
);

CREATE TABLE Result(
    Student_id INT PRIMARY KEY,
    Subject VARCHAR(50),
    Marks INT,
    Outcome VARCHAR(50)
);

-- Insert data into College_Students table
INSERT INTO College_Students (Student_id, Name, Age, Grade)
VALUES
(1, 'Salish', 21, 'A'),
(2, 'Molly', 19, 'B+'),
(3, 'Bill', 27, 'D-'),
(4, 'Shriyan', 23, 'A*'),
(5, 'Oscar', 18, 'B+');

-- Insert data into Result table
INSERT INTO Result (Student_id, Subject, Marks, Outcome)
VALUES
(1, 'Maths', 47, 'Fail'),
(2, 'English', 82, 'Pass'),
(3, 'Science', 68, 'Fail'),
(4, 'Computer Science', 100, 'Pass'),
(5, 'Geograhy', 89, 'Pass');

SELECT * FROM College_Students;
SELECT * FROM Result;