select
sum(case
when to_char(int_datahora_entrada, 'MM') = '06' and to_char(int_datahora_saida, 'MM') = '06'
then sum(date_part('day',(age(int_datahora_saida, int_datahora_entrada))))
when int_datahora_entrada < '2020-06-01' and to_char(int_datahora_saida, 'MM') = '06'
then sum(date_part('day',(age(int_datahora_saida, '2020-06-01'))))
when to_char(int_datahora_entrada, 'MM') = '06' and int_datahora_saida > '2020-06-30'
then sum(date_part('day',(age('2020-06-30', int_datahora_entrada)))) + 1
when int_datahora_entrada < '2020-06-01' and int_datahora_saida > '2020-06-30'