https://medium.com/@code1br/would-you-create-a-report-with-the-the-top-3-absentees-e69cebbe18e0

fetchties.sql

SELECT name, COUNT(*)
FROM absences
GROUP BY name
ORDER BY COUNT(*) DESC
FETCH FIRST 3 ROWS WITH TIES;

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