---

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

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

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