https://medium.com/@code1br/know-your-data-e69cebbe18e0

limit5.sql

SELECT name, COUNT(*)
FROM absences
GROUP BY name
ORDER BY COUNT(*) DESC
LIMIT 5;

    name    | count 
------------+-------
John Doe    |  2392
Jane Doe    |  1960
Richard Doe |  1898
Robert Doe  |  1898
Mark Moe    |  1713