(TSQL)利用CASE WHEN或IIF去統計筆數

IIF要SQL Server 2012之後才支援

REF:
https://dba.stackexchange.com/questions/120003/what-does-then-1-else-0-mean-in-a-case-expression-used-with-an-aggregate-functio