Условие
CREATE TABLE pupils (
pupil_id INT PRIMARY KEY,
name VARCHAR(50),
grade INT
);
CREATE TABLE tutors (
tutor_id INT PRIMARY KEY,
name VARCHAR(50),
subject_taught VARCHAR(50)
);
CREATE TABLE subjects (
subject_id INT PRIMARY KEY,
subject_name VARCHAR(50)
);
CREATE TABLE lessons (
lesson_id INT PRIMARY KEY,
date DATE,
pupil_id INT,
tutor_id INT,
subject_id INT
);
INSERT INTO pupils (pupil_id, name, grade)
VALUES
(1, 'John', 10),
(2, 'Emily', 9),
(3, 'Michael', 11),
(4, 'John', 4),
(5, 'Andrew', 7),
(6, 'Kate', 11);
INSERT INTO tutors (tutor_id, name, subject_taught)
VALUES
(1, 'Mr. Smith',…