订单重要时成功尝试分组查询

您可以使用SQL解决此问题:

SELECT t.attempt_id,
       SUM(CASE t.result WHEN TRUE THEN 1 ELSE 0 END) AS cleared,
       COUNT(*) AS total
  FROM Jumper t
 GROUP BY t.attempt_id

编辑: 如果trunt\u id只是一个序列,并且您想使用它来计算每个跳线的尝试次数,则可以使用此查询:

SELECT t.attempt_number,
       SUM(CASE t.result WHEN TRUE THEN 1 ELSE 0 END) AS cleared,
       COUNT(*) AS total
  FROM (SELECT s.*,
               ROW_NUMBER() OVER(PARTITION BY athlete
                                 ORDER BY attempt_id) AS attempt_number
        FROM Jumper s) t
 GROUP BY t.attempt_number

这样,您可以将所有运动员的第一次尝试、第二次尝试等分组。。。