postgresHow to group resulting set by specific column values

SELECT first_name, COUNT(*) FROM person GROUP BY first_name;ctrl + cgithub

COUNT(*)

aggregate function that returns the number of rows

GROUP BY first_name

group the result set by first_name