sql - 在 SQL 中计算精度/召回率曲线

Question

假设我有分类决策和置信度作为记录，有没有办法通过SQL获得精确率/召回率曲线？换句话说，有没有办法将以下一组查询折叠成一个？

select avg(predicted_label=correct_label) from t where confidence<0
select avg(predicted_label=correct_label) from t where confidence<1
select avg(predicted_label=correct_label) from t where confidence<2
select avg(predicted_label=correct_label) from t where confidence<3
select avg(predicted_label=correct_label) from t where confidence<4
select avg(predicted_label=correct_label) from t where confidence<5
select avg(predicted_label=correct_label) from t where confidence<6
....

Answer 1

获取avg的predicted_label对于置信范围，请尝试此操作。
编辑:加入 <=

SELECT FLOOR(t1.confidence), AVG(t2.predicted_label)
FROM Table t1
    JOIN Table t2 ON t2.confidence <= t1.Confidence
GROUP BY FLOOR(t1.confidence)