download_test.sql

select
  payment_instrument_detail_type,
  M.company_name,
  M.public_id,
  merchant_fk,
  count(*)
from gateway_production.transactions T
inner join gateway_production.merchants M ON
  T.merchant_fk = M.pk
where
 T.created_at > '2018-04-10 00:00:00'
 and T.created_at < '2018-04-24 23:59:00'
 and T.payment_instrument_detail_type = 'AndroidPayCardDetail'
group by 1,2,3,4
order by 1,COUNT(*) DESC
limit 10
;