APP

SELECT count(*)
from
requestsubject RS, requestsubjectgroup_requestsubject RG, requestsubjectgroup RSG, request R, requestgroup G, application AP, applicant AT,person P, term_type T
where RS.id=RG.requestsubject_id
and RSG.id=RG.requestsubjectgroup_id
and RSG.request_id=R.id and R.requestgroup_id=G.id
and G.application_id=AP.id and AP.applicant_id=AT.id
and AT.person_id=P.id and T.id=AP.term_type_id
and AP.term_year::text || T.termnumber='20202' --aktuelles Bewerbungssemester
and R.k_request_status_id in (select KRS.id from k_request_status KRS where (KRS.hiskey_id not in (1,2,3) or KRS.hiskey_id is null))
and RS.k_requestsubject_status_id in (select KRS.id from k_requestsubject_status KRS where (KRS.hiskey_id is null or KRS.hiskey_id not in (1,2,3)));

HISinOne-BI

select count(*) from zul_antr_aggr where bewsem=20202