dayname(to_date(block_timestamp::date)) as week_day,

sum(price_USD) as volume,

count(*) as sales_count

from ethereum.core.ez_nft_sales

where NFT_ADDRESS='0x716f29b8972d551294d9e02b3eb0fc1107fbf4aa'

group by 1)

select avg(volume) as avg_volume, avg(sales_count), week_day,

case when week_day in ('Sat', 'Sun') then 'WeekEnds'

else 'WeekDays' END as date_type

from tb3

group by week_day