The following works in PostgreSQL:
with _data as (
select
asp.id submission_portal_id ,
ea.tax_number,
ea.id application_id,
(
select
count(1)
from
eae_field ef
join eae_field_geospatial_data efgd
on ef.id = efgd.field_id
where
ea.id = ef.application_id
) field_count,
(
select
count(1)
from
eae_livestock el
join eae_livestock_stable els
on el.id = els.livestock_id
where
ea.id = el.application_id
) stable_count
from
eae_application ea
left join eae_applicant_commitment eac
on ea.tax_number = eac.tax_number
left join app_submission_portal asp
on eac.submission_portal_id = asp.id
where
ea.application_status_id in (2) and
asp.id = 569
)
select
*
from
_data t
where
t.field_count > 10 and
t.stable_count > 3
;