Optimizing Month Naming
11:44 15 Jun 2026

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
sql sqlite