Can AskYourDatabase show what people have been asking?
AskYourDatabase showed what people had asked and which account asked each question. Its usage list contained five entries for the five questions asked.
1 of 1 test case passed
Every test case in this scenario has a result.
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.
Usage view across two accountsPassEvidence
Input 1 · Person 1 (admin): “As of September 2, 2026, what's our total revenue in the last 30 days?”
Input 2 · Person 1 (admin): “What's our most common payment method?”
Input 3 · Person 1 (admin): “How many complaints have we received on social media this month?”
The Person 2 (Member) account was used for this question.
Input 4 · Person 2 (Member): “How many customers currently have an active subscription?”
Input 5 · Person 2 (Member): “What's our net promoter score for last quarter?”
Response 1 (Revenue calculation status) is a progress message the tool sent for Input 1; it is not part of the answer.
Response 2 (Revenue query) is the query the tool generated for Input 1; it is not part of the answer.
Response 3 answers Input 1.
Response 4 (Payment method check) is a progress message the tool sent for Input 2; it is not part of the answer.
Response 5 (Payment method query) is the query the tool generated for Input 2; it is not part of the answer.
Response 6 answers Input 2.
Response 7 answers Input 3.
Response 8 (Subscription count status) is a progress message the tool sent for Input 4; it is not part of the answer.
Response 9 (Active subscriptions query) is the query the tool generated for Input 4; it is not part of the answer.
Response 10 answers Input 4.
Response 11, the final response, answers Input 5.
I don't have access to any Net Promoter Score (NPS) data in this database. The available tables cover customers, orders, products, subscriptions, returns, tickets, and related operational data — but there's no survey or NPS feedback table. To calculate an NPS, I'd need data like customer survey responses (ratings 0–10) or promoter/detractor classifications, which aren't present here. Could you clarify: Is NPS data stored somewhere I'm not seeing (e.g., a different table or external system)? Or would you like me to look at a related metric I can compute, such as customer satisfaction signals from tickets/returns, or churn from subscription cancellations?
Transcribed from Proof 1 · Screen recording at 0:14
Every message the tool sent, in order (11)
- Revenue calculation status
I'll calculate the total revenue from orders placed in the 30 days before September 2, 2026.
- Revenue query · not part of the answer
SELECT COALESCE(SUM(total_amount), 0) AS total_revenue FROM orders WHERE placed_at >= '2026-08-03' AND placed_at < '2026-09-02' AND status <> 'cancelled'
- Revenue answer
As of September 2, 2026, the total revenue in the last 30 days (August 3 – September 2, 2026) was $8,828.82. This figure excludes cancelled orders.
- Payment method check
I'll check the payment methods used across orders to find the most common one.
- Payment method query · not part of the answer
SELECT payment_method, COUNT(*) AS order_count FROM orders GROUP BY payment_method ORDER BY order_count DESC;
- Payment method answer
Your most common payment method is card, used in 162 orders. Here's the full breakdown: Card 162, PayPal 42, Apple Pay 40, Affirm 27, Google Pay 23, Gift Card 14. Card payments account for more than half of all orders (162 out of 308 total).
- Social media complaints answer
I don't have access to social media data in this database. The database contains tables for customers, orders, products, subscriptions, returns, tickets, and related records — but nothing tracking social media mentions or complaints. If you're looking for customer complaints, the closest match would be the tickets table, which tracks support issues. Would you like me to check how many support tickets were opened this month instead?
- Subscription count status
I'll look up the number of customers with an active subscription.
- Active subscriptions query · not part of the answer
SELECT COUNT(DISTINCT customer_id) AS active_subscription_customers FROM subscriptions WHERE status = 'active';
- Active subscriptions answer
4 customers currently have an active subscription.
- Net promoter score answer
The final response, printed above.
| ✓ | Expected: Each question must appear under the account that asked it, with as many entries as questions asked.Found: The Messages page had five rows for five questions: three attributed to the admin account and two to the Member account. |
The five entries met the requirement for a complete, attributed list. A displayed count was not required, so its absence did not prevent a pass.
Member access to admin questions. A Member with view-and-query access can see the admin's questions with the admin's account identity label.
Unanswered questions look alike. In the Messages list, the social-media complaints and net promoter score questions have no unanswered marker. The admin must open each row to see the response.
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.
How this scenario is graded
How we decide Pass, Fail and Not gradable. The same rules apply to every tool tested on this scenario.
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.
- 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.
| Level | Name | Scope |
|---|---|---|
| Benchmark | AI Database Agents → | 28 scenarios · 11 tools |
| Capability | Analytics & Observability → | |
| Scenario | Someone needs to see what people have been asking → | |
| Tool | AskYourDatabase → |
Global scenario definition → · Global capability definition → · AskYourDatabase product page →
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.
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.
You run the same kind of test against your own setup and get the same behaviour.
Agree →Yours behaves differently. Tell us what you got, with a screenshot if you have one.
Disagree →Something here is wrong — a reference value, a transcription, a grade.
Report an issue →Tell us what changed and we schedule a rerun of the failing test case. The old result stays as history.
Vendor notice →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.
File fingerprints (SHA-256)
A fingerprint identifies the exact file used for this result.