with token as (

SELECT DISTINCT S.token0

from ethereum.dex_liquidity_pools S

where platform = 'sushiswap'

,

launch as (

SELECT T.token0 , min(creation_time::date) as launched_date_on_sushiswap

from ethereum.dex_liquidity_pools S , token T

where platform = 'sushiswap'

and T.token0 = S.token0

and creation_time is not NULL

group by 1

order by 2 desc

)

SELECT launched_date_on_sushiswap , C.name as symbol, C.address as contract_address

from launch L , ethereum.contracts C

where L.token0 = C.address

order by 1 desc

limit 10