学步园

1、两个统计量的减法：

select
(select count(*) from defect)-(select count(*) from defect where cljg like '%合格%' and cljg not like '%不合格%') as count
from dual