SJSUCSClub / acm-website-server

1 stars 0 forks source link

[BACKEND] Student year sql function #42

Open ManasC478 opened 1 month ago

ManasC478 commented 1 month ago

Create a function that tells use which year a student is in. The function takes a user_id parameter and using the grad_date and education_level, return a value from {'freshman', 'sophomore', 'junior', 'senior'}. grad students can't be 'junior' or 'seniors' so that's where we use the education_level column to determine the exact year.