majority_grouping.sql

# Majority Grouping
select concat(repeat('*', floor(a.trCount / 100))) as bar,
       floor(avg(a.trCount)) as avgTrCnt,
       max(a.trCount) as maxTrCnt,
       min(a.trCount) as minTrCnt,
       count(*) as accountCnt
from Account a
where 1
    and a.trCount > 10
group by bar
order by bar
limit 100;