select count if in sql code example

Example: sql count if

COUNT(CASE WHEN <condition> THEN 1 END)