johnbocook
3/8/2016 - 8:53 PM

Calculate Students Level. Level_ table is usually accurate, You can also do the calculation based on number of credits received 0-29 is fres

Calculate Students Level. Level_ table is usually accurate, You can also do the calculation based on number of credits received 0-29 is freshman, 30-59 is sophomore, 60-89 is junior and 90+ is senior.

student_level.sql
content_copyfile_download
(COUNT cred_rec FROM nmcrs
  INNER JOIN grades ON grades.grade=nmcrs.grade AND grades.pass = 1
  WHERE enrolled = "EN")