CREATE TABLE student (
    StudentID INT PRIMARY KEY, 
    student_name VARCHAR(100), 
    age INT, 
    grade VARCHAR(100)
);
INSERT INTO student VALUES
    (1, "John", 18, "C+"),
    (3, "Luke", 22, "A+"),
    (6, "Peter", 20, "B-");
SELECT * FROM student;
CREATE TABLE student_result (
    StudentID INT, 
    subject VARCHAR(100), 
    marks INT,
    result INT,
    FOREIGN KEY (StudentID) REFERENCES student(StudentID)
);
INSERT INTO student_result VALUES
    (3, "Computer Science", 50, 48),
    (6, "Math", 30, 18),
    (1, "Science", 40, 20);

SELECT * FROM student_result;