Загрузка данных

CREATE VIEW Min_g AS
SELECT 
    p.project,
    CONCAT(m.lastName, ' ', m.name) AS rukovoditel,
    YEAR(p.dateStart) AS year_start
FROM PROJECT p
JOIN WORK w ON p.shifr = w.projectid
JOIN TEAM t ON w.teamid = t.id
JOIN MENTOR m ON t.mentor = m.id
WHERE YEAR(p.dateStart) = (SELECT MIN(YEAR(dateStart)) FROM PROJECT);

-- Проверка
SELECT * FROM Min_g;


CREATE VIEW Max_st AS
SELECT lastName, name, yearBirth,
       YEAR(CURDATE()) - yearBirth AS age
FROM STUDENTS
WHERE yearBirth = (SELECT MIN(yearBirth) FROM STUDENTS);

-- Проверка
SELECT * FROM Max_st;