dumpyboii 0 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 Quote Link to post Share on other sites
niche 143 Posted March 4 Report Share Posted March 4 looks fine. are you getting the results you expected? Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.