Pergunta de entrevista da empresa The Lead Group
Query visitor counts for the 5 states with most total visitors
Resposta da entrevista
Sigiloso
17 de set. de 2020
SELECT id, COUNT(id) as totalVisitors, SUM(isUnique) as uniqueVisitors from visitors GROUP BY stateId ORDER BY count DESC LIMIT 5