SQL：计算在输出列上出现的次数，并根据出现的次数计算一些百分比

我相信这就是您所需要的：

SELECt    a.id,    a.resolution,    b.*FROM     Table1 aCROSS JOIN    (        SELECt CONCAt(SUM(aa.resolution = 'pass'), '/', COUNT(*)) AS attempts, CONCAt((SUM(aa.resolution = 'pass') / COUNT(*)) * 100, '%') AS percent_attempts, CONCAt(SUM(bb.mindate IS NOT NULL AND resolution = 'pass'), '/', SUM(resolution = 'pass')) AS first_attempt         FROM Table1 aa        LEFT JOIN  (     SELECt          MIN(`date`) AS mindate      FROM          Table1 ) bb ON aa.`date` = bb.mindate    ) b