with tab1 as (select date_trunc('day',block_timestamp) as day, sum(price) as total_sales_volume
from flow.core.fact_nft_sales
where nft_collection='A.e4cf4bdc1751c65d.AllDay'
group by 1
order by 1)
select sum(total_sales_volume) as "NFL All Day total sales volume", avg(total_sales_volume) as "NFL All Day average sales volume per day",
max(total_sales_volume) as "Max NFL All Day sales volume", min(total_sales_volume) as "Min NFL All Day sales volume"
from tab1