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

CREATE TABLE Quizzes(
    QuizID INT 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');