1、两个统计量的减法：
select (select count(*) from defect)-(select count(*) from defect where cljg like '%合格%' and cljg not like '%不合格%') as count from dual
