[Solved] Select criteria using a case expression in where clause based on other columns [closed]

by

[ad_1]

SELECT ID,SUM(CASE WHEN Level=1 AND Grade IN ('A','B','C','D') THEN 1 
            WHEN Level=2 AND Grade IN ('A','B','C') THEN 1
            ELSE 0
       END AS GradeCount
FROM YourTable
GROUP BY ID;

0

[ad_2]

solved Select criteria using a case expression in where clause based on other columns [closed]