在SQL中实现Wilson分数

SELECT (P+0.5) / (N+1) + ((N+1)*(P-Q+0.5)) / (4*N+2) AS Wilson_Score
FROM (
  SELECT COUNT(*) AS P FROM your_table WHERE your_condition = 'positive'
) AS Positive_Samples,
(
  SELECT COUNT(*) AS Q FROM your_table WHERE your_condition = 'negative'
) AS Negative_Samples,
(
  SELECT COUNT(*) AS N FROM your_table
) AS Total_Samples;