在Case Satement Oracle中返回计数

SELECT 
    SUM(CASE WHEN condition1 THEN 1 ELSE 0 END) AS count1,
    SUM(CASE WHEN condition2 THEN 1 ELSE 0 END) AS count2,
    SUM(CASE WHEN condition3 THEN 1 ELSE 0 END) AS count3
FROM 
    your_table;

SELECT 
    column1,
    SUM(CASE WHEN condition1 THEN 1 ELSE 0 END) AS count1,
    SUM(CASE WHEN condition2 THEN 1 ELSE 0 END) AS count2,
    SUM(CASE WHEN condition3 THEN 1 ELSE 0 END) AS count3
FROM 
    your_table
GROUP BY
    column1;

SELECT 
    COUNT(CASE WHEN condition1 THEN 1 END) AS count1,
    COUNT(CASE WHEN condition2 THEN 1 END) AS count2,
    COUNT(CASE WHEN condition3 THEN 1 END) AS count3
FROM 
    your_table;