Local Docker/sample_appProduction Store/orders

QUICK ACTIONSSearchHistoryView DDLJump to column

userserver_costcustomer_report.sql

RunFormat SQL⌘ ↵

1. SELECT
2. c.id,
3. c.display_name,
4. COUNT(o.id) AS order_count,
5. SUM(o.total_amount) AS lifetime_value
6. FROM customers c
7. LEFT JOIN orders o ON o.customer_id = c.id
8. WHERE c.status = 'active'
9. GROUP BY c.id, c.display_name
10. ORDER BY lifetime_value DESC
11. LIMIT 100;

Query results3 rows · 18 ms

iddisplay_nameorder_countlifetime_value

101Alex Morgan128,420.50

204Jamie Chen96,104.00

318Sam Rivera74,885.25