SELECT
SUM(CASE WHEN current_date = P.dtInicio then 1 else 0 end) as "Hoje",
SUM(Case when cast(EXTRACT(WEEK FROM current_date) as integer) = cast(EXTRACT(WEEK FROM P.dtInicio) as integer) then 1 else 0 end) as "Semana ",
SUM(Case when EXTRACT(MONTH FROM current_date) = EXTRACT(MONTH FROM P.dtInicio) then 1 else 0 end) as "Mês ",
COUNT(*) as "Trimestre"
FROM esiaprocesso p
LEFT JOIN esiaCategoriaEvento c ON p.cdCategoriaevento = c.cdCategoriaEvento
LEFT JOIN esiaTipoPendencia tp ON p.cdTipoPendencia = tp.cdTipoPendencia
WHERE date_part('year',p.dtInicio) >= 2018
and date_part('MONTH',p.dtInicio) >= 7
Andand c.cdCategoriaEvento = 2
and tpp.cdTipoPendencia = 1
and p.cdEntidade <> 526
and p.cdProduto in (3,10,12,4,8,16,21) | 