SQL:
WITH monthly_totals AS (
SELECT DATE_FORMAT(billing_cycle, ‘%Y-%m’) AS month,
SUM(pretax_amount) AS monthly_amount
FROM billing
WHERE billing_cycle >= DATE_SUB(CURDATE(), INTERVAL 13 MONTH)
GROUP BY DATE_FORMAT(billing_cycle, ‘%Y-%m’)
)
SELECT month,
monthly_amount，
LAG(monthly_amount) OVER (ORDER BY month) AS prev_month_amount
FROM monthly_totals
ORDER BY month
LIMIT 100 OFFSET 0
ERROR:
SQL ERROR: parse sql ‘WITH monthly_totals AS ( SELECT DATE_FORMAT(billing_cycle, ‘%Y-%m’) AS month, SUM(pretax_amount) AS monthly_amount FROM billing WHERE billing_cycle >= DATE_SUB(CURDATE(), INTERVAL 13 MONTH) GROUP BY DATE_FORMAT(billing_cycle, ‘%Y-%m’) ) SELECT * FROM (SELECT month, monthly_amount， LAG(monthly_amount) OVER (ORDER BY month) AS prev_month_amount FROM monthly_totals ORDER BY month LIMIT 100 OFFSET 0) AS tmp LIMIT 100 OFFSET 0’ error: syntax error: unexpected LEX_ERROR at position 289 near �