SQL issue in SQL Posted February 15, 2021 Show the name, first name and permanent code of students who have been enrolled in a program for more than 3 years without graduating SELECT name, first_name, permanent_code FROM student WHERE graduation_dateĀ IS NULL GROUP BY enrollement_date HAVING enrollement_date>= year() +3 Do you have any idea, how to do it
SQL issue
in SQL
Posted
Show the name, first name and permanent code of students who have been enrolled in a program for more than 3 years without graduating
SELECT name, first_name, permanent_code
FROM student
WHERE graduation_dateĀ IS NULL
GROUP BY enrollement_date
HAVING enrollement_date>= year() +3
Do you have any idea, how to do it