Divisão 4 – Solos, ambiente e sociedade – Lista de sócio

select upper(p.nome) as nome, n.nome as nucleo, count(f.id_fatura) as contagem from soc_pessoa p inner join soc_socio s on p.id_pessoa = s.id_pessoa inner join soc_nucleo n on p.nucleo = n.id_nucleo left join soc_fatura f on f.id_socio = s.id_socio and f.pago = 1 where p.tipo_pessoa = 'pf' and s.id_socio in ( select id_socio from soc_fatura where anuidade = 2023 and pago =1 ) and (p.divisao in (select id_divisao from soc_divisao where id_divisao = 4) or p.divisao_2 in (select id_divisao from soc_divisao where id_divisao = 4) or p.divisao_3 in (select id_divisao from soc_divisao where id_divisao = 4) or p.divisao_4 in (select id_divisao from soc_divisao where id_divisao = 4)) group by p.id_pessoa order by p.nome asc