Order Status Summary

Write a SQL query to count orders and total amount for each status.

Expected Columns

• status
• order_count
• total_amount

Example Output

| status | order_count | total_amount | |--------|-------------|--------------| | Delivered | 9 | 110200.0 | | Shipped | 3 | 44200.0 | | Processing | 3 | 156800.0 |