Cacher is the code snippet organizer for pro developers

select
count(distinct three_requests.id) as count,
client_name
from three_requests
join gateways on gateways.id = three_requests.mid_id
where three_requests.created_at between '2019-08-16 00:00:00' and '2019-09-15 23:59:59'
group by client_id
order by count desc