SELECT acs.ACNUM,
(SELECT COUNT(ints.ACNUM) FROM INTEREST ints WHERE ints.ACNUM = acs.ACNUM GROUP BY ints.ACNUM HAVING  COUNT(ints.ACNUM) > 5) intCOUNT,
(SELECT COUNT(auth.ACNUM) FROM AUTHOR auth WHERE acs.ACNUM = auth.ACNUM GROUP BY auth.ACNUM HAVING  COUNT(auth.ACNUM) < 10) authCOUNT
FROM ACADEMIC acs;