CREATE TABLE Subjects(
    SubjectID AUTO_INCREMENT PRIMARY KEY,
    Subjectname VARCHAR(50)
)

CREATE TABLE Quizzes(
    QuizID AUTO_INCREMENT PRIMARY KEY,
    Quiz VARCHAR(500),
    Subject_ID INT
)

INSERT INTO Subjects(Subjectname)
VALUES

('Maths'),
('Coding'),
('Science');

INSERT INTO Quizzes(Quiz, Subject_ID)
VALUES

('834/(2x3)=', '1'),
('Make a calculator in scratch.', '2'),
('What is the ph level of Hydrocyanic acid?', '3');