Good evening, I'm creating an indication system, But the query result does not return users with zero statements
Here's my select
SELECT
c.id,
c.nome,
funcao,
area,
count(p.cpf_cli) AS quantidade
FROM col c
LEFT JOIN indicacao p
ON p.id_colaborador = c.id
WHERE
indicacao.data_ind BETWEEN '2018/09/20' AND '2018/09/21'
GROUP BY
c.id, c.nome
ORDER BY
c.nome