I have 2 tables:
The relationship is as follows: 1 shop - > N leads
I need to list the number of leads registered for each store and then sort by descending order to know which store has the most leads
The inner join I am using doubles the stores when you run the query. HELP
I would do so:
SELECT nome_loja, uf, (SELECT COUNT(*) FROM leads
WHERE loja_selecionada = nome_loja) AS 'total'
FROM lojas ORDER BY total DESC
It also works. =)
Would it be something like this?
SELECT COUNT(le.id) AS total_leads FROM leads AS le
INNER JOIN lojas AS lo ON le.id_loja = lo.id
GROUP BY lo.id
ORDER BY lo.id DESC