Posts by Anderson Pimenta • 3 points

• 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 6 years, 1 month 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 6 years, 1 month ago Anderson Pimenta 3