WITH one as (SELECT sender, sum (amount) AS total_amount FROM anchor.borrows WHERE block_timestamp::date >= '2021-011-18' GROUP BY sender HAVING total_amount >1 AND total_amount <5 ), two as (SELECT sender, sum (amount) AS total_amount FROM anchor.borrows WHERE block_timestamp::date >= '2021-011-18' GROUP BY sender HAVING total_amount >=5 AND total_amount <10 ), three as (SELECT sender, sum (amount) AS total_amount FROM anchor.borrows WHERE block_timestamp::date >= '2021-011-18' GROUP BY sender HAVING total_amount >=10 AND total_amount <20 ), four as (SELECT sender, sum (amount) AS total_amount FROM anchor.borrows WHERE block_timestamp::date >= '2021-011-18' GROUP BY sender HAVING total_amount >=20 AND total_amount <40 ), five as (SELECT sender, sum (amount) AS total_amount FROM anchor.borrows WHERE block_timestamp::date >= '2021-011-18' GROUP BY sender HAVING total_amount >=40 AND total_amount <80 ), six as (SELECT sender, sum (amount) AS total_amount FROM anchor.borrows WHERE block_timestamp::date >= '2021-011-18' GROUP BY sender HAVING total_amount >=80 AND total_amount <160 ), seven as (SELECT sender, sum (amount) AS total_amount FROM anchor.borrows WHERE block_timestamp::date >= '2021-011-18' GROUP BY sender HAVING total_amount >=160 ) SELECT COUNT(sender) AS number,'Borrow>1 & <5' AS groups FROM one UNION SELECT COUNT(sender) AS number,'Borrow>=5 & <10' AS groups FROM two UNION SELECT COUNT(sender) AS number,'Borrow>=10 & <20' AS groups FROM three UNION SELECT COUNT(sender) AS number,'Borrow>=20 & <40' AS groups FROM four UNION SELECT COUNT(sender) AS number,'Borrow>=40 & <80' AS groups FROM five UNION SELECT COUNT(sender) AS number,'Borrow>=80 & <160' AS groups FROM six UNION SELECT COUNT(sender) AS number,'Borrow>=160' AS groups FROM seven

Anchor Emissions