Evidence · first-party tested

Generates a valid aggregation query over orders that groups by customer_id and computes order_count, total_spend, avg_order_value, and last_order_date, then sorts by total_spend descending with a LIMIT 25.

✓ WorkedQuerio →
Input — the actual file we sent
Best customers with top-3 unpaid orders and payment method follow-ups
A conversational multi-table customer analysis that ranks best customers by order volume and spend, then drills into unpaid orders and usual payment methods for the top 3, testing context retention across follow-ups.
Output — unretouched
tool output
The observation

Generates a valid aggregation query over orders that groups by customer_id and computes order_count, total_spend, avg_order_value, and last_order_date, then sorts by total_spend descending with a LIMIT 25.

Criterion: SQL Generation · Scenario: Best customers with top-3 unpaid orders and payment method follow-ups (group: live-database-nl2sql)
Query this
get_evidence({
  tool: "querio",
  scenario: "live-database-nl2sql"
})
MCP · mcp.aidemos.com/api/mcp
Free with attribution.
Same input, other tools
AskYourDatabase ✓ WorkedBasedash ✓ WorkedDefinite ✓ WorkedDraxlr ✓ Worked
Real outputs, no retouching · every cell queryable via API & MCP · aidemos.com