MONTH

1
SELECT
2
  sale_date,
3
  MONTH(sale_date) as sale_month,
4
  YEAR(sale_date) as sale_year
5
FROM sales
6
LIMIT 3;

1
SELECT
2
  YEAR(sale_date) as year,
3
  MONTH(sale_date) as month,
4
  SUM(amount) as monthly_sales
5
FROM sales
6
WHERE YEAR(sale_date) = 2024
7
GROUP BY YEAR(sale_date), MONTH(sale_date)
8
ORDER BY month;

1
SELECT
2
  CASE
3
    WHEN MONTH(order_date) IN (12, 1, 2) THEN 'Winter'
4
    WHEN MONTH(order_date) IN (3, 4, 5) THEN 'Spring'
5
    WHEN MONTH(order_date) IN (6, 7, 8) THEN 'Summer'
6
    ELSE 'Fall'
7
  END as season,
8
  COUNT(*) as order_count,
9
  SUM(amount) as total_sales
10
FROM orders
11
GROUP BY season;