---

-- Шаг 1. Добавление нового курса
INSERT INTO courses (title, instructor_id, price, duration_hours)
VALUES ('Введение в Data Science', 3, 15000.00, 30);

-- Шаг 2. Запись первого студента (Иван Иванов)
INSERT INTO enrollments (student_id, course_id, enroll_date)
VALUES (
    (SELECT id FROM students WHERE email = 'ivan@example.com'),
    (SELECT id FROM courses WHERE title = 'Введение в Data Science'),
    CURRENT_DATE
);

-- Шаг 3. Запись второго студента (Елена Смирнова)
INSERT INTO enrollments (student_id, course_id, enroll_date)
VALUES (
    (SELECT id FROM students WHERE email = 'elena@example.com'),
    (SELECT id FROM courses WHERE title = 'Введение в Data Science'),
    CURRENT_DATE
);