with pa1 as (
select
address
from flipside_prod_db.algorand.account_asset
where asset_name like '%Warrior Croc%'
and amount >0
),
pa2 as (
SELECT
balance,
created_at,
address
from flipside_prod_db.algorand.account
)
SELECT
a.address,
b.balance,
b.created_at,
b.address
from pa1 a
left join pa2 b
on a.address=b.address