android - 如何在 Android 上的 SQLite 中使用 CASE WHEN 对两个字段求和

Question

我想显示现场尝试的总和和连接在一起的点的总和，但我只得到现场尝试的总和。

SELECT
ContactName,
SUM(CASE WHEN event = 'Event1' THEN tries || '/' || points END) AS "E1",
SUM(CASE WHEN event = 'Event2' THEN tries || '/' || points END) AS "E2",
SUM(CASE WHEN event = 'Event3' THEN tries || '/' || points END) AS "E3",

FROM names
WHERE
period = 2
GROUP BY
ContactName

Answer 1

我通过将两个总和相除进行了以下操作

SUM(CASE WHEN event = 'Event1' THEN tries END) || "/" || SUM(CASE WHEN event = 'Event1' THEN points END) AS "E1"