Payments Gateway Query for Fauzaan

select distinct r.member_id as mid,
pm.key as keyssss,
pm.provider as provider,
count(r.id) as resv
from reservations r left join members m on m.id = r.member_id
left join payment_methods pm on pm.member_id = m.id
where month(r.start_at + Interval 8 hour) = '8'
and r.state = 'completed'
and m.imaginary in ('sofam', 'normal')
and r.member_id not in ('125', '127')
and pm.provider in ('braintree')
group by 1
order by 4 desc