请大家帮我转化下这个语句 转成exists 和 NOT exits格式的
select count(distinct mfg_no) from pda_mugn_mobile where mmcd='E202' and mfg_no in (select mfg_no from mfs_maintain where substr(maintain_code,0,1) not in ('6','5','8'));
select count(distinct mfg_no) from pda_mugn_mobile where mmcd='E202' and mfg_no in (select mfg_no from mfs_maintain where substr(maintain_code,0,1) not in ('6','5','8'));
select count(distinct mfg_no) from pda_mugn_mobile where mmcd='E202' and exists (select 1 from mfs_maintain where pda_mugn_mobile.mfg_no = mfs_maintain.mfg_no and not exists(select 1 from dual where substr(pda_mugn_mobile.maintain_code,0,1)=5 or substr(pda_mugn_mobile.maintain_code,0,1)=6 or substr(pda_mugn_mobile.maintain_code,0,1)=8);
select count(distinct mfg_no) from pda_mugn_mobile where mmcd='E202' and exists (select 1 from mfs_maintain where pda_mugn_mobile.mfg_no = mfs_maintain.mfg_no and not exists(select 1 from dual where substr(mfs_maintain.maintain_code,0,1)='5' or substr(mfs_maintain.maintain_code,0,1)='6' or substr(mfs_maintain.maintain_code,0,1)='8'));
from pda_mugn_mobile,(select mfg_no from mfs_maintain where not regexp_like(maintain_code,'^[568]') B
where mmcd='E202' and pda_mugn_mobile.mfg_no = B.mfg_no;