-- student table
-- primary key: id
-- first name, last name (50 characters), birthdate, age, 
-- completed_math_course (boolean)
CREATE TABLE student(
    student_id INT PRIMARY KEY AUTO_INCREMENT,
    first_name VARCHAR(50),
    last_name VARCHAR(50),
    birthdate DATE,
    age INT,
    completed_math_course BOOLEAN
);
INSERT INTO student (first_name, last_name, birthdate, age, completed_math_course) VALUES
    ("Mark", "Roa", "2020-7-11", 6, FALSE),
    ("Luke", "Roa", "2020-3-11", 8, FALSE);
SELECT * FROM student;

CREATE TABLE result(
    result_id INT PRIMARY KEY,
    subject_name VARCHAR(50),
    score DOUBLE,
    student_id INT,
    FOREIGN KEY(student_id) REFERENCES student(student_id)
);
INSERT INTO result VALUES
    (4, "Math", 9.8, 1),
    (1, "English", 6.9, 1),
    (6, "Math", 9.9, 2),
    (3, "English", 8.9, 2);
SELECT * FROM result;