Database: e_learning
Question: For each distinct test result, find the number of students who got the result.
SQL:
SELECT test_result ,  COUNT(*) FROM Student_Tests_Taken GROUP BY test_result ORDER BY COUNT(*) DESC