Text to SQL

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