Query editor
withpool_details as (selecttoken0 as token_address,evt_tx_hash,poolfromuniswap_v3_ethereum.Factory_evt_PoolCreatedunion allselecttoken1 as token_address,evt_tx_hash,poolfromuniswap_v3_ethereum.Factory_evt_PoolCreated),token_pool_summary as (selecttoken_address,count(pool) as pool_countfrompool_detailsgroup by1order by2 desclimit100)select t.symbol, p.token_address, p.pool_countfrom token_pool_summary pinner join tokens.erc20 t on p.token_address = t.contract_addressorder by 3 desc