ORDER BY statement is used to sort results according to the specified
ORDER BY statement sorts records in ascending order by default.
If you want to sort records in descending order, you can use the
ORDER BY column (KEY) [ DESC | ASC ]
Count different access status codes and sort them in descending order:
SELECT status, COUNT(status) AS c GROUP BY status ORDER BY c DESC