Evidence · first-party tested

Generates a customer-spend aggregation grouped by customer_id and sorted by total spend descending, returning order_count, total_spend, avg_order_value, and last_order_at.

✓ WorkedQuerio
Output — unretouched
tool output
Output — unretouched
tool output
The observation

Generates a customer-spend aggregation grouped by customer_id and sorted by total spend descending, returning order_count, total_spend, avg_order_value, and last_order_at.

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