CASE

WHEN EXTRACT(DOW FROM block_timestamp) = 0 THEN 'Sunday'

WHEN EXTRACT(DOW FROM block_timestamp) = 1 THEN 'Monday'

WHEN EXTRACT(DOW FROM block_timestamp) = 2 THEN 'Tuesday'

WHEN EXTRACT(DOW FROM block_timestamp) = 3 THEN 'Wednesday'

WHEN EXTRACT(DOW FROM block_timestamp) = 4 THEN 'Thursday'

WHEN EXTRACT(DOW FROM block_timestamp) = 5 THEN 'Friday'

WHEN EXTRACT(DOW FROM block_timestamp) = 6 THEN 'Saturday'

END AS sale_dayname,

COUNT(*) AS sales_count

FROM

near.nft.ez_nft_sales

GROUP BY

sale_dayname

ORDER BY

CASE

WHEN sale_dayname = 'Monday' THEN 1

WHEN sale_dayname = 'Tuesday' THEN 2

WHEN sale_dayname = 'Wednesday' THEN 3

WHEN sale_dayname = 'Thursday' THEN 4

WHEN sale_dayname = 'Friday' THEN 5

WHEN sale_dayname = 'Saturday' THEN 6

WHEN sale_dayname = 'Sunday' THEN 7

END;