你可以使用下面的SQL

select 
job,
100*sum(if(status='Success', 1,0)) / count(*) success_percent,
100*sum(if(status='Failed', 1,0)) / count(*) failed_percent,
100*sum(if(status='Unknown', 1,0)) / count(*) unknown_percent
from mytable
group by job

下面是SQL代码的示例输出

with mytable as (
select 'a' job, 'Success' status union all select 'b' job, 'Success' status union all 
select 'a' job, 'Failed' status union all select 'b' job, 'Unknown' status)

select 
job,
100*sum(if(status='Success', 1,0)) / count(*) success_percent,
100*sum(if(status='Failed', 1,0)) / count(*) failed_percent,
100*sum(if(status='Unknown', 1,0)) / count(*) Unknown_percent
from mytable
group by job

它获取状态计数，并将其除以所有记录的计数以获得%。