Year-over-Year Revenue Growth

Return each year, its total revenue and the percentage growth compared with the previous year rounded to two decimals (NULL for the first year). Order by year.

Table schema

Orders(id INT PRIMARY KEY, order_date DATE, amount INT)

Sample data

id | order_date | amount
1 | 2024-05-01 | 100
2 | 2025-03-01 | 100
3 | 2025-08-01 | 50
4 | 2026-01-01 | 120