From AI-ready to AI‑operational

Question: Which regions logged the most site visits last quarter?

1. classifyData question, sent to the query path
2. databasedemo_field_ops, named in the request
3. schemaCached: visits, sites, regions
4. policyRead only, passed

SELECT r.name AS region, COUNT(*) AS visits
FROM visits v
JOIN sites s   ON s.id = v.site_id
JOIN regions r ON r.id = s.region_id
WHERE v.visited_at >= DATE '2026-07-01'
  AND v.visited_at <  DATE '2026-10-01'
GROUP BY r.name
ORDER BY visits DESC;

Answer: The North East logged the most visits last quarter, 412, followed by the Midwest with 356.

Question: And only for oncology sites?

1. classifyFollow-up, resolved against the last question
2. resolvedSite visits last quarter by region, oncology sites only
3. schemaReused from the last question
4. policyRead only, passed

SELECT r.name AS region, COUNT(*) AS visits
FROM visits v
JOIN sites s   ON s.id = v.site_id
JOIN regions r ON r.id = s.region_id
WHERE v.visited_at >= DATE '2026-07-01'
  AND v.visited_at <  DATE '2026-10-01'
  AND s.therapy_area = 'oncology'
GROUP BY r.name
ORDER BY visits DESC;

Answer: For oncology sites the order changes: the North East still leads with 138, and the South moves to second with 121.

Question: What can you do?

1. classifyConversation, not a data question
2. databaseNot touched

Answer: I answer questions about field operations in demo_field_ops: visits, sites and regions. I can only read, and I show the query behind every answer.