Cadastros Iniciados e Efetivados

 SELECT
EXTRACT(YEAR FROM p.REGISTRATIONDATE) ano
, EXTRACT(MONTH FROM p.REGISTRATIONDATE) mes
, COUNT(1) AS COUNTSTARTEDREGISTRATION
, SUM(
          CASE WHEN P.REGISTRATIONSTATUS IN ('COMPLETE', 'APPROVED', 'BACKOFFICE_PENDING', 'REFUSED', 'DOCUMENTSPICTURES_BACK') THEN 1 ELSE 0 END
        ) AS COUNTCOMPLETEREGISTRATION
    FROM TUDOPROD.PERSON p
    WHERE EXTRACT(YEAR FROM p.REGISTRATIONDATE) = 2019
AND (P.REGISTRATIONSTATUS IS NOT NULL OR P.REGISTRATIONSTATUS != 'OPENED')
GROUP BY EXTRACT(YEAR FROM p.REGISTRATIONDATE)
, EXTRACT(MONTH FROM p.REGISTRATIONDATE)
ORDER BY 1;