SELECT test_result ,  COUNT(*) FROM Student_Tests_Taken GROUP BY test_result ORDER BY COUNT(*) DESC
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
select test_result , count ( * ) from student_tests_taken group by test_result order by count ( * ) desc
For each distinct test result , find the number of students who got the result .