Month-over-Month Growth

Write a SQL query to calculate month-over-month order amount growth.

Expected Columns

• month
• total_amount
• prev_month_amount
• growth

Example Output

| month | total_amount | prev_month_amount | growth | |-------|--------------|-------------------|--------| | 2023-01 | 85350.0 | NULL | NULL | | 2023-02 | 29200.0 | 85350.0 | -65.79 | | ... | ... | ... | ... |