SQL Query with Aggregate Count, where at least 1 of the counts has a value in a field
I suspect you can do it using a subquery, something like:

SELECT PERSON_ID, COUNT(APPL_ID) COUNTS
FROM APPLICATIONS
WHERE PERSON_ID IN (
    SELECT DISTINCT PERSON_ID
    FROM APPLICATIONS
    WHERE APPL_DATE &gt; 2018-01-01
)
GROUP BY PERSON_ID
ORDER BY COUNTS DESC