dumpyboii Posted February 15 Report Share Posted February 15 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 Report Share Posted March 4 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