sql group by count where count 1 code example Example: sql count group by SELECT gender, COUNT(*) FROM people GROUP BY gender;