CODE EXAMPLE FOR SQL

sql count group by

SELECT gender, COUNT(*) FROM people GROUP BY gender;