'Optimism' as network,

case

when price>0 and price<=0.01 then 'a. < 0.01 ETH'

when price>0.01 and price<=0.1 then 'b. 0.01-0.1 ETH'

when price>0.1 and price<=1 then 'c. 0.1-1 ETH'

when price>1 and price<=10 then 'd. 1-10 ETH'

when price>10 then 'e. > 10ETH'

end as bucket,

count(distinct tx_hash) as sale_no,

count(distinct BUYER_ADDRESS) as buyer_no,

sum(PRICE) as volume

from optimism.core.ez_nft_sales

where PLATFORM_NAME='quixotic'

and EVENT_TYPE='sale'

and CURRENCY_SYMBOL='ETH'

group by 1,2 having bucket is not null

union all

'Ethereum' as network,

case

when price>0 and price<=0.01 then 'a. < 0.01 ETH'

when price>0.01 and price<=0.1 then 'b. 0.01-0.1 ETH'

when price>0.1 and price<=1 then 'c. 0.1-1 ETH'

when price>1 and price<=10 then 'd. 1-10 ETH'

when price>10 then 'e. > 10ETH'

end as bucket,

count(distinct tx_hash) as sale_no,

count(distinct BUYER_ADDRESS) as buyer_no,

sum(PRICE) as volume

from ethereum.core.ez_nft_sales

where EVENT_TYPE='sale'

group by 1,2 having bucket is not null