For each distinct test result, find the number of students who got the result.
select test_result, count(*) from student_tests_taken group by test_result order by count(*) desc