query.sql

1. Выдает список свидетельств и кол-во программ
select 
_id,
`Id` as `GUID`,
( select count(*) from `certificatesupplement` cs INNER JOIN `accreditedprogramm` ap on ap.certificatesupplement_id = cs._id WHERE cs.certificate_id = ac._id ) as `Total` 
from accreditationcertificate as ac 
order by _id
2. Выдает список свидетельств где нет программ
select 
_id,
`Id` as `GUID`,
( select count(*) from `certificatesupplement` cs INNER JOIN `accreditedprogramm` ap on ap.certificatesupplement_id = cs._id WHERE cs.certificate_id = ac._id ) as `Total` 
from accreditationcertificate as ac 
where `Total` = 0
order by _id