Group by month name when using a custom SQL query


I am trying to show sum of dealvalue month by month for each year. I am using a custom SQL query to solve this as it isn’t possible in another way.

But when doing so, I get the month numbers instead of names. How can I get the names instead of numbers?

This is not related to Metabase. This is a SQL question. You are applying the Month function which returns a number.
To get the month name, the function you should use depends on the underlying DB instance. In SQL Server you can use format or datename functions, in Postgres you can use to_char function, etc.