sum (price) as ETH_Value

FROM ethereum.core.ez_nft_sales

where EVENT_TYPE = 'sale'

and CURRENCY_SYMBOL = 'ETH'

and NFT_ADDRESS=lower('0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d')

and price>0

group by 1

order by 2 desc

limit 10