select
no,
case when rule1 = 'P' then 1 else 0 end +
case when rule2 = 'P' then 1 else 0 end +
case when rule3 = 'P' then 1 else 0 end as passes,
case when rule1 = 'F' then 1 else 0 end +
case when rule2 = 'F' then 1 else 0 end +
case when rule3 = 'F' then 1 else 0 end as fails
from
table
;
1 个回答