SUM(CASE WHEN ... THEN 1 ELSE 0 END)

Content coming soon.