What do you want to know?
Describe the data you need — we’ll turn it into a query.
Results
22 rows
› View SQL
SELECT DATE_FORMAT(o.created_at, '%Y-%m') AS month, SUM(o.total_amount) AS total_revenue, COUNT(o.id) AS total_orders FROM orders o GROUP BY DATE_FORMAT(o.created_at, '%Y-%m') ORDER BY month ASC LIMIT 100
| Month | Total Revenue | Total Orders |
|---|---|---|
| 2024-11 | 88899.98 | 27 |
| 2024-12 | 183023.92 | 66 |
| 2025-01 | 99445.99 | 39 |
| 2025-02 | 105528.92 | 47 |
| 2025-03 | 85691.96 | 37 |
| 2025-04 | 109990.00 | 31 |
| 2025-05 | 98458.94 | 39 |
| 2025-06 | 110989.97 | 40 |
| 2025-07 | 81926.99 | 32 |
| 2025-08 | 106553.99 | 41 |
| 2025-09 | 87402.96 | 33 |
| 2025-10 | 106278.98 | 33 |
| 2025-11 | 205461.00 | 63 |
| 2025-12 | 173337.93 | 62 |
| 2026-01 | 95845.97 | 40 |
| 2026-02 | 92791.98 | 34 |
| 2026-03 | 123500.98 | 44 |
| 2026-04 | 72098.00 | 25 |
| 2026-05 | 105524.98 | 40 |
| 2026-06 | 25565.00 | 7 |
| 2026-11 | 91285.00 | 30 |
| 2026-12 | 114211.97 | 40 |