CASE

WHEN MONTH(block_timestamp) = 1 THEN 'January'

WHEN MONTH(block_timestamp) = 2 THEN 'February'

WHEN MONTH(block_timestamp) = 3 THEN 'March'

WHEN MONTH(block_timestamp) = 4 THEN 'April'

WHEN MONTH(block_timestamp) = 5 THEN 'May'

WHEN MONTH(block_timestamp) = 6 THEN 'June'

WHEN MONTH(block_timestamp) = 7 THEN 'July'

WHEN MONTH(block_timestamp) = 8 THEN 'August'

WHEN MONTH(block_timestamp) = 9 Then 'September'

END AS month_name,

AVG(value) AS average_value

FROM ethereum.core.fact_transactions

WHERE YEAR(block_timestamp) = YEAR(CURRENT_DATE())

GROUP BY MONTH(block_timestamp);