我正在Sqlite3中使用以下查询:
SELECT
Platform,
SUM((CASE WHEN Result=='Pass' THEN 1 ELSE 0 END) AS NumPass),
SUM((CASE WHEN Result =='Fail' THEN 1 ELSE 0 END) AS NumFail),
SUM((CASE WHEN Result=='NoRun' THEN 1 ELSE 0 END) AS NumNoRun),
SUM((count(Result) as NumTotal))
FROM a