johnbocook/student_level.sql

Created March 8, 2016 20:53

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/johnbocook/9a25a4b9142444a95fcb.js"></script>
Save johnbocook/9a25a4b9142444a95fcb to your computer and use it in GitHub Desktop.

Download ZIP

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.

Raw

student_level.sql

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment