Jump to content

dumpyboii

Members
  • Posts

    1
  • Joined

  • Last visited

Everything posted by dumpyboii

  1. dumpyboii

    SQL issue

    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
×
×
  • Create New...