FROM ethereum.erc20_balances

where contract_address='0x6b175474e89094c44da98b954eedeac495271d0f' and balance>0 and balance_date>'2022-01-01'

GROUP BY user_address)

, tbl_result as(Select t.user_address,balance,balance_date from ethereum.erc20_balances as t inner join max_data

on max_data.user_address = t.user_address and max_data.max_date = t.balance_date

where t.contract_address='0x6b175474e89094c44da98b954eedeac495271d0f' and balance>0 and balance_date>'2022-01-01')

select * from tbl_result

order by balance DESC

limit 20