CREATE TABLE Student (
    student_id INT PRIMARY KEY,
    name VARCHAR(50),
    subject VARCHAR(50),
    marks INT
);

-- Insert details of 5 students
INSERT INTO Student (student_id, name, subject, marks)
VALUES
(1., 'Brook', 'Biology', 97),
(2., 'Mark', 'English', 70),
(3., 'Rahul', 'Maths', 85),
(4., 'Shriyan', 'Physics', 101),
(5., 'Sofia', 'Science', 32);

SELECT * FROM Student;