sql group by count having code example

Example 1: sql count group by

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

Example 2: sql count having

SELECT COUNT( * ) 
FROM agents 
HAVING COUNT(*)>1; --count is greater than 1