highest points

Question

Is there any other secret in getting the highest number of points in a course rather than getting all the quizzes correct?

Answer 1

lets say you have a table
quizzes
name
score

select * from quizzes order by score dec
--not sure if dec or des. OR asc to go top to bottom
this will return the highest score on top.
you could use an aggregation of MAX but not sure how to do that in mysql. only sql...... sorry :/
hope this helps