How to fix ER_WINDOW_RANGE_FRAME_NUMERIC_TYPE (3589): RANGE frame requires numeric ORDER BY expression in MySQL

SELECT 
  name,
  amount,
  SUM(amount) OVER (
    ORDER BY name  -- Error: 'name' is not numeric/temporal
    RANGE BETWEEN 10 PRECEDING AND 10 FOLLOWING
  )
FROM orders;

DESC your_table;  -- Check column types

-- Valid numeric types: INT, BIGINT, DECIMAL, FLOAT, DOUBLE
-- Valid temporal types: DATE, TIME, DATETIME, TIMESTAMP

-- Invalid for RANGE: VARCHAR, TEXT, CHAR, ENUM

SELECT 
  name,
  amount,
  order_date,
  SUM(amount) OVER (
    ORDER BY order_date  -- Valid: DATETIME column
    RANGE BETWEEN INTERVAL 7 DAY PRECEDING AND CURRENT ROW
  ) as rolling_sum_7days
FROM orders;

SELECT 
  name,
  amount,
  SUM(amount) OVER (
    ORDER BY name  -- Now valid with ROWS
    ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING
  ) as moving_sum_3rows
FROM orders;

-- Numeric column example
SELECT 
  product_id,
  price,
  SUM(price) OVER (
    ORDER BY unit_cost
    RANGE BETWEEN 5 PRECEDING AND 5 FOLLOWING  -- 5 units of price
  )
FROM products;

-- Temporal column example
SELECT 
  event_name,
  event_date,
  COUNT(*) OVER (
    ORDER BY event_date
    RANGE BETWEEN INTERVAL 30 DAY PRECEDING AND CURRENT ROW
  ) as events_last_30_days
FROM events;