dumpyboii Posted February 15, 2021 Share 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 Link to comment Share on other sites More sharing options...
niche Posted March 4, 2021 Share Posted March 4, 2021 looks fine. are you getting the results you expected? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now