pool_addresses as (

select address as address ,address_name

from terra.labels

where LABEL ilike 'loop'

and LABEL_SUBTYPE ilike 'pool'

group by 1,2),

pool_tvl as (

select address as address ,sum(balance_usd) as tvl ,balance_type

from terra.daily_balances where date::date > current_date-10

group by 1,3 having tvl is not null )

select distinct pa.address_name , pt.tvl

from pool_addresses as pa inner join pool_tvl as pt

on lower(pa.address) =lower(pt.address)

group by 1,2 having 2 >0