sql count in where clause code example
Example 1: sql count where
SELECT count(CASE WHEN gender = 'F' THEN 1 ELSE NULL END) women_count,
count(CASE WHEN gender = 'M' THEN 1 ELSE NULL END) men_count
FROM people;
Example 2: SQL only show where count is great than 1
SELECT COUNT( * )
FROM agents
HAVING COUNT(*)>1; --count is greater than 1