SELECT F.RASSOC,
(SELECT COUNT(DTENG)
FROM PARHLISE
WHERE FORNECE = F.CODIGO) AS TOTAL_PARHLISE,

(SELECT COUNT(P.DTENG)
FROM PARHLISE AS P
INNER JOIN HISTLISE AS H ON H.FORNECE = P.FORNECE
WHERE P.FORNECE = F.CODIGO AND P.DTENG > H.DTEMI) AS PARHLISE_ATRASO

FROM FORNECED AS F
LEFT JOIN PARHLISE AS PH ON PH.FORNECE = F.CODIGO
LEFT JOIN PARCLISE AS PC ON PC.FORNECE = F.CODIGO
GROUP BY F.CODIGO, F.RASSOC