SELECT DECODE(EXTRACT ('dayofweek',BLOCK_TIMESTAMP),
1, 'Monday',
2, 'Tuesday',
3, 'Wednesday',
4, 'Thursday',
5, 'Friday',
6, 'Saturday',
0, 'Sunday') AS day,
SUM(PRICE_USD) AS "Total Sales"
FROM ethereum.nft.ez_nft_sales
WHERE NFT_ADDRESS= LOWER('0xBd3531dA5CF5857e7CfAA92426877b022e612cf8')
GROUP BY 1