with all_add_liqs as (
select pool_name, tx_id, rune_amount_usd + asset_amount_usd as amount_usd
from thorchain.liquidity_actions
where lp_action = 'add_liquidity'
), count_add_liquidities as (
SELECT
pool_name,
count( CASE WHEN amount_usd < 1000 THEN amount_usd END) as count_below_1000_usd,
count( CASE WHEN amount_usd > 0 THEN amount_usd END) as count_all,
(count_below_1000_usd / count_all)*100 as percent
from all_add_liqs
group by 1
order by 2 desc
)
SELECT
*
from count_add_liquidities
where count_all > 1
order by count_below_1000_usd desc