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 PRICE_USD::float > 0

and price>0

and PLATFORM_NAME ='blur'

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 t1

group by week_day