Business questions
Five questions, graded 0 to 2 each, for a maximum of 10. The data covers 2024-01-01 to 2025-12-31; the latest month is 2025-12.
Q01: How many prescriptions were filled by region and month?
Section titled “Q01: How many prescriptions were filled by region and month?”Paraphrases (other ways a user might ask; try them in chat, the grader scores the main wording):
- Show monthly prescription fill counts for each region.
- What is the fill volume per region per month?
- Break down prescriptions filled by region and calendar month.
- How many scripts did each region fill every month?
Answer columns: region, year_month, prescriptions_filled
Grading: table, partial credit by row_fraction.
How the reference answer is defined
Count every fill, new prescriptions and refills together, by store region and calendar month for all 24 months in the data (January 2024 to December 2025).
Expected answer (96 rows, first 12 shown)
| region | year_month | prescriptions_filled |
|---|---|---|
| East | 2024-01 | 454 |
| East | 2024-02 | 436 |
| East | 2024-03 | 438 |
| East | 2024-04 | 396 |
| East | 2024-05 | 445 |
| East | 2024-06 | 441 |
| East | 2024-07 | 453 |
| East | 2024-08 | 378 |
| East | 2024-09 | 409 |
| East | 2024-10 | 440 |
| East | 2024-11 | 448 |
| East | 2024-12 | 468 |
Q02: Which medication categories experienced the largest volume changes?
Section titled “Q02: Which medication categories experienced the largest volume changes?”Paraphrases (other ways a user might ask; try them in chat, the grader scores the main wording):
- Which therapeutic categories moved the most in the latest month?
- Where did prescription volume change the most by drug category?
- Rank medication categories by how much their fill volume changed.
- Which categories grew or shrank the most last month?
Answer columns: category, prior_month_fills, latest_month_fills, change, change_pct
Grading: ranking, partial credit by top_key.
How the reference answer is defined
Compare fills in the latest complete month in the data (December 2025) with the previous month (November 2025) for each therapeutic category. Rank categories by the absolute change in fills, largest first. Report both months, the change, and the percent change as a fraction (0.25 means 25 percent).
Expected answer (8 rows)
| category | prior_month_fills | latest_month_fills | change | change_pct |
|---|---|---|---|---|
| Respiratory | 219 | 456 | 237 | 1.082192 |
| Anti-infective | 197 | 271 | 74 | 0.375635 |
| Dermatology | 112 | 60 | -52 | -0.464286 |
| Cardiovascular | 346 | 377 | 31 | 0.089595 |
| Pain and Inflammation | 185 | 210 | 25 | 0.135135 |
| Gastrointestinal | 213 | 203 | -10 | -0.046948 |
| Diabetes | 253 | 246 | -7 | -0.027668 |
| Mental Health | 236 | 229 | -7 | -0.029661 |
Q03: What was the average prescription processing time by store?
Section titled “Q03: What was the average prescription processing time by store?”Paraphrases (other ways a user might ask; try them in chat, the grader scores the main wording):
- How long does each store take to process a prescription on average?
- Show mean processing minutes per store.
- Which stores are slowest at getting prescriptions ready?
- Average time from intake to ready for pickup, by store.
Answer columns: store, avg_processing_minutes
Grading: ranking, partial credit by top_key.
How the reference answer is defined
Average processing minutes per fill for each store across the full data window (January 2024 to December 2025). Sort slowest first.
Expected answer (12 rows)
| store | avg_processing_minutes |
|---|---|
| Sunset Mesa | 20.519744 |
| Harbor Point | 13.169722 |
| Granite Park | 12.41314 |
| Riverbend | 12.318225 |
| Lakeview | 12.077522 |
| Oak Terrace | 12.043905 |
| Bayside | 12.014074 |
| Magnolia Square | 11.567551 |
| Fox Run | 11.476436 |
| Pine Hollow | 11.362979 |
| Willow Creek | 10.933369 |
| Stonebridge | 10.862511 |
Q04: Which stores had unusually high refill activity?
Section titled “Q04: Which stores had unusually high refill activity?”Paraphrases (other ways a user might ask; try them in chat, the grader scores the main wording):
- Which stores are refilling far more than the rest of the chain?
- Flag stores with abnormal refill rates.
- Where is refill activity unusually high?
- Which pharmacies stand out for refills recently?
Answer columns: store, refill_rate, refill_rate_index
Grading: set, partial credit by any_key.
How the reference answer is defined
For the latest quarter in the data (October to December 2025), compute each store’s refill rate (refills divided by all fills) and its index against the chain-wide refill rate for the same quarter. A store is unusually high when its index is 1.25 or more. Return only the flagged stores. Rates are fractions (0.8 means 80 percent).
Expected answer (2 rows)
| store | refill_rate | refill_rate_index |
|---|---|---|
| Riverbend | 0.795737 | 1.368062 |
| Granite Park | 0.781633 | 1.343813 |
Q05: How did prescription volume compare with the previous period?
Section titled “Q05: How did prescription volume compare with the previous period?”Paraphrases (other ways a user might ask; try them in chat, the grader scores the main wording):
- Is prescription volume up or down versus the prior period?
- Compare this month’s fills with last month.
- How much did total fills change period over period?
- What was the month-over-month change in prescriptions filled?
Answer columns: period, prescriptions_filled, previous_period_fills, change, change_pct
Grading: table, partial credit by column_match.
How the reference answer is defined
Compare total fills in the latest complete month in the data (December 2025) with the previous month (November 2025). Report the period as YYYY-MM, both totals, the change, and the percent change as a fraction.
Expected answer (1 rows)
| period | prescriptions_filled | previous_period_fills | change | change_pct |
|---|---|---|---|---|
| 2025-12 | 2052 | 1761 | 291 | 0.165247 |