AI Demos Research — the structured-intelligence platform. Every verdict on these pages opens to the execution behind it.
Graded 9 October 2026

Can AskYourDatabase give a summary and its detail together?

AskYourDatabase gave a headline figure and a breakdown in forms suited to each, so it met the scenario. It returned a revenue summary table for the total, a category table for the breakdown, and takeaways naming the driver; there was no chart.

1 of 1 test case passed

Every test case in this scenario has a result.

Pass rate100%1 of 1 gradable
Coverage1 of 1test case with a result
1PassDid everything it was expected to do.
0FailNo test case failed.
0Not gradableEvery result here could be graded.
0UntestedEvery test case in this scenario has a result.
The pass rate is a summary. The evidence is the test case below: what we sent, what we checked, what the tool returned, and the proof.

The test case

Each test case is judged on its own: Pass, Fail, Not gradable, or Untested. The scenario result above is based on this test case.

Headline figure plus its breakdownPassEvidence
What we sent

“As of September 2, 2026, how did our revenue do last month, and what drove it?”

What the tool returned

The tool's reply is shown in the evidence under Proofs.

Here's how your revenue performed in August 2026 (the month before September 2, 2026): Revenue Summary Metric | Value Total revenue | $13,441.94 Total orders | 26 Average order value | $517.00 Total discounts applied | $237.00 Total shipping collected | $6.99 What drove it — by category Category | Orders | Revenue | Share Outdoor & Patio | 5 | $7,744.59 | 57.6% Bedding & Rugs | 5 | $1,462.96 | 10.9% Kitchen & Dining | 5 | $1,340.68 | 10.0% Furniture | 1 | $1,099.30 | 8.2% Lighting | 4 | $904.09 | 6.7% Home Decor | 4 | $596.03 | 4.4% Storage & Organization | 2 | $294.29 | 2.2% Key takeaways Outdoor & Patio was the clear driver, contributing over 57% of total revenue ($7,744.59) from just 5 orders — including a single large order of $1,898.66 on Aug 21 and a $4,674.13 day on Aug 24. Furniture had the highest average order value ($1,099.30 from a single order), but low volume. Revenue was back-loaded in the month — roughly half came in the final week (Aug 24–30). Discounts were modest overall ($237, ~1.8% of revenue), concentrated on Aug 30 ($130.20). In short, August's revenue was driven primarily by a handful of high-value Outdoor & Patio orders rather than broad order volume.

Transcribed from Proof 2 · Screenshot

Expected vs. Found
✓Expected: Gives the overall figure and the breakdown in suitable forms.Found: It returned a revenue summary table for the headline total and a category table plus takeaways for the breakdown.
Supporting proof
Proof 1Screenshot
Chat screenshot: question and three SQL queries
Open original ↗
Proof 2Screenshot
Answer screenshot: summary table, breakdown table, takeaways
Open original ↗
Why this result

The case required both the overall figure and the breakdown in suitable forms. The reply showed a revenue summary table for the headline and a category table plus takeaways for the breakdown, which matches the expected behavior.

Also observed in this test case

Cancelled orders counted. The headline total includes cancelled orders, but the answer does not say that.

Cancelled driver example. The driver narrative points to a large order that was cancelled.

Wrong AOV takeaway. The answer says Furniture had the highest average order value, but the figures shown make Outdoor & Patio higher.

No month-to-month comparison. It discusses August only and does not compare that month with July.

Tables instead of chart. Both parts of the answer are tables, and there is no chart.

Tested by Ayush Ghosh · evidence dated 6 October 2026

Configuration and setup

How this tool was set up for the run and what the test needed in place. Each row is a fact from the run's records; a fact the records do not hold is left out, not guessed.

Software that produced the output
AskYourDatabase
Build or version
Not exposed by the hosted product
Surface
Web app
Set up before the run
A measure had moved, and one segment explained most of the movement.
Tested
6 October 2026 · Ayush Ghosh

How this scenario is graded

How we decide Pass, Fail and Not gradable. The same rules apply to every tool tested on this scenario.

How results are decided

Each test case gets one result per tool: Pass, Fail or Not gradable. A test case we haven't run yet shows Untested. There are no partial results.

The rules
  • Pass: the tool did everything the test expected, and nothing it said contradicts the correct answer.
  • Fail: at least one expected behaviour clearly didn't happen; the test case's result says which one and quotes the tool.
  • Not gradable: our evidence couldn't settle the outcome (for example a record we needed is missing). It is never counted as a fail, and the test case's result says what's missing.

Where this sits in the benchmark

This page is one cell of a larger study: one tool, one scenario. Only this benchmark's frame appears here.

History of this result

What has happened to this result since it was first published. Runs and grades are never overwritten: a retest or a re-grade publishes a new result and keeps the earlier one readable.

from the publication record
14 October 2026First publishedAI Database Agents v1

Act on this result

Nothing filed here edits the run or the grade. A challenge opens a review, and a review can produce a new run or a re-grade — which becomes the current result and leaves this one in the history.

This matches what I see

You run the same kind of test against your own setup and get the same behaviour.

Agree →
This does not match

Yours behaves differently. Tell us what you got, with a screenshot if you have one.

Disagree →
Point out an issue

Something here is wrong — a reference value, a transcription, a grade.

Report an issue →
Request a retest

On a newer build, a larger dataset, or your own setup.

Request a retest →
We have fixed this

Tell us what changed and we schedule a rerun of the failing test case. The old result stays as history.

Vendor notice →
Filed against this evidenceNothing yet. Challenges, counter-evidence and fix notices appear here with their outcome, and stay on the page after they are resolved.
Cite this result
aidemos.com/benchmarks/ai-database-agents/results/askyourdatabase/the-answer-needs-a-summary-and-its-detail-together · 1 pass · 0 fail · coverage 1/1 · graded 2026-10-09

The same record is available as structured data through the AI Demos MCP server, with the counts, the coverage and every per-test-case reason carried as fields.

Verify the proof files

These files support this result. Open a file to inspect the original evidence.

Proof 1 · Screenshot ↗image/png · 85 KB
Proof 2 · Screenshot ↗image/png · 81 KB
File fingerprints (SHA-256)

A fingerprint identifies the exact file used for this result.

Proof 1 · Screenshot0b72d75bea1664ae81edaba295405d19c8fd5f9d0e9ca3756256beef2e90a771
Proof 2 · Screenshot4a5ff728930bc8d6dda296391c69adf4330ee1e0c2ccef6bbe914dacac8c6e84