Optimizing Month Naming
I am very new to SQL, I am learning it for my job, can I get any advice on how to optimize the naming for the months in the following code:
(The date convention with the database is 'YYYY-MM-DD')
Select
strftime('%Y-%m', order_date) AS month,
COUNT(id),
CASE
When order_date LIKE '2023-01-%' Then 'January'
When order_date LIKE '2023-02-%' Then 'Feburary'
When order_date LIKE '2023-03-%' Then 'March'
When order_date LIKE '2023-04-%' Then 'April'
When order_date LIKE '2023-05-%' Then 'May'
When order_date LIKE '2023-06-%' Then 'June'
When order_date LIKE '2023-07-%' Then 'July'
When order_date LIKE '2023-08-%' Then 'August'
When order_date LIKE '2023-09-%' Then 'September'
When order_date LIKE '2023-10-%' Then 'October'
When order_date LIKE '2023-11-%' Then 'November'
Else 'December'
END AS Month
From
orders
Group by
strftime('%Y-%m', order_date)
Order by
order_date