Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Soma de valor de quem fechou contrato
- select k.cpf, count(*) as qtd_contratos , sum (cl.valuefordeposit) as total from meutudo.clientecontatomkt k
- inner join public.tb_pessoa_meutudo p on p.num_cpf = k.cpf
- inner join public.tb_contrato_meutudo c on p.id_person = c.personid
- inner join public.tb_contractloan_meutudo cl on c.id = cl.contractid
- where k.status = 3 and c.contractdate::date >= k.dataenvio::date group by k.cpf;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement