Posts by Anderson Pimenta • 3 points

2 posts

0
votes

1
answer

15
views

Q: Display prayed results

Good evening I’m creating a referral system, But the query result does not return users with zero indications Here is my select SELECT c.id, c.nome, funcao, area, count(p.cpf_cli) AS quantidade FROM…

select join count
asked 5 years, 9 months ago Anderson Pimenta 3
0
votes

1
answer

38
views

Q: filter between two dates with Join

I have two tables: col (collaborator) and Indicacao. I made a select to know how many referrals each employee has. It’s working but I can’t filter by date using between. SELECT c.id, c.nome, funcao,…

sql join where
asked 5 years, 9 months ago Anderson Pimenta 3