sobrinho · May 31, 2022 22:11
diff --git a/limit5.sql b/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
	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