“what were my top product sales, and who bought them?”

Every step the AI took

1. 1
   Checked the saved queries
   4 saved queries
2. 2
   Read the Fishbowl notes index
   12 topic notes
3. 3
   Looked up a table · soitem
   35 columns
4. 4
   Looked up a table · so
   66 columns
5. 5
   Top selling products and which customers bought them; first checking line item types

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT t.id, t.name, COUNT(*) AS n
   FROM soitem AS si
   JOIN soitemtype AS t ON t.id = si.typeId
   GROUP BY t.id, t.name
   LIMIT 101

   5 rows · 313 ms
6. 6
   Top selling products and which customers bought them; checking order statuses and date range

   checking so statuses and date range

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT s.id, s.name, COUNT(*) AS n, MIN(so.dateIssued) AS firstIssued, MAX(so.dateIssued) AS lastIssued
   FROM so
   JOIN sostatus AS s ON s.id = so.statusId
   GROUP BY s.id, s.name
   LIMIT 101

   5 rows · 230 ms
7. 7
   Top selling products by revenue across issued/fulfilled sales orders

   main ranking of products by revenue

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT si.productNum, MAX(p.description) AS description, ROUND(SUM(si.totalPrice), 2) AS revenue, ROUND(SUM(si.qtyOrdered), 2) AS qtyOrdered, ROUND(SUM(si.qtyFulfilled), 2) AS qtyFulfilled, COUNT(DISTINCT si.soId) AS orders, COUNT(DISTINCT so.customerId) AS customers
   FROM soitem AS si
   JOIN so ON so.id = si.soId
   LEFT JOIN product AS p ON p.id = si.productId
   WHERE si.typeId IN (10, 12) AND so.statusId IN (20, 25, 60, 70)
   GROUP BY si.productNum
   ORDER BY revenue DESC
   LIMIT 101

   36 rows · 295 ms
8. 8
   Which customers bought each product, with revenue and quantity

   breakdown by product and customer

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT si.productNum, c.name AS customer, ROUND(SUM(si.totalPrice), 2) AS revenue, ROUND(SUM(si.qtyOrdered), 2) AS qtyOrdered, COUNT(DISTINCT si.soId) AS orders
   FROM soitem AS si
   JOIN so ON so.id = si.soId
   JOIN customer AS c ON c.id = so.customerId
   WHERE si.typeId IN (10, 12) AND so.statusId IN (20, 25, 60, 70)
   GROUP BY si.productNum, c.name
   ORDER BY si.productNum, revenue DESC
   LIMIT 1001

   84 rows · 284 ms
9. 9
   Total product sales revenue for share calculation

   overall total

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT ROUND(SUM(si.totalPrice), 2) AS revenue, COUNT(DISTINCT si.soId) AS orders, COUNT(DISTINCT si.productNum) AS products
   FROM soitem AS si
   JOIN so ON so.id = si.soId
   WHERE si.typeId IN (10, 12) AND so.statusId IN (20, 25, 60, 70)
   LIMIT 101

   1 row · 285 ms