SELECT test_result ,  COUNT(*) FROM Student_Tests_Taken GROUP BY test_result ORDER BY COUNT(*) DESC
List each test result and its count in descending order of count.
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
List each test result and its count in descending order of count .