CODE EXAMPLE FOR SQL

sql countif

SELECT COUNT(CASE WHEN <condition> THEN 1 END) FROM tableName;