sobrinho · May 31, 2022 22:10
diff --git a/limit3.sql b/limit3.sql
 SELECT name, COUNT(*)
 FROM absences
 GROUP BY name
 ORDER BY COUNT(*) DESC
 LIMIT 3;

    name    | count 
 ------------+-------
 John Doe    |  2392
 Jane Doe    |  1960
 Richard Doe |  1898
	SELECT name, COUNT(*)
	FROM absences
	GROUP BY name
	ORDER BY COUNT(*) DESC
	LIMIT 3;

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