Sim
🧪 SQL Playground
Read-only · customer_events
Download CSV
SELECT menu_item, COUNT(*) AS orders, SUM(revenue) AS revenue, SUM(cost * quantity) AS cogs, SUM(revenue) - SUM(cost * quantity) AS gross_profit FROM customer_events WHERE event_type = 'pay' GROUP BY menu_item ORDER BY revenue DESC NULLS LAST
Run query
Query returned 0 rows.