“What has Allen's Groceries ordered from us, and how often?”

Every step the AI took

1. 1
   Checked the saved queries
   6 saved queries
2. 2
   Read the Fishbowl notes index
   13 topic notes
3. 3
   Find the customer record for Allen's Groceries and its sales order count, to report what they have ordered and how often

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT c.id, c.name, c.number, c.activeFlag + 0 AS active, COUNT(so.id) AS soCount, MIN(so.dateIssued) AS firstIssued, MAX(so.dateIssued) AS lastIssued
   FROM customer AS c
   LEFT JOIN so ON so.customerId = c.id
   WHERE c.name LIKE @pat
   GROUP BY c.id, c.name, c.number, c.activeFlag
   LIMIT 101

   1 row · 222 ms
4. 4
   Read Fishbowl notes · SALES.md
5. 5
   List every sales order and line item for customer Allen's Groceries to report what they ordered and how often

   Customer found (id 40); now pulling all SO headers and line items

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT so.num AS soNum, ss.name AS soStatus, so.dateCreated, so.dateIssued, so.dateCompleted, so.totalPrice, so.customerPO, si.soLineItem, sit.name AS lineType, si.productNum, si.description, si.qtyOrdered, si.qtyFulfilled, u.code AS uom, si.unitPrice, si.totalPrice AS lineTotal, sis.name AS lineStatus
   FROM so
   JOIN sostatus AS ss ON ss.id = so.statusId
   LEFT JOIN soitem AS si ON si.soId = so.id
   LEFT JOIN soitemtype AS sit ON sit.id = si.typeId
   LEFT JOIN soitemstatus AS sis ON sis.id = si.statusId
   LEFT JOIN uom AS u ON u.id = si.uomId
   WHERE so.customerId = @cid
   ORDER BY so.dateIssued, so.num, si.soLineItem
   LIMIT 501

   10 rows · 239 ms