Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →ecnu-icalk/MySQL应付账款到期及逾期统计
用于生成MySQL应付账款统计查询，按到期时间（当前、1个月内、3个月内）分组统计金额，并确保时间范围互不重叠。
Passed 22 of 22 test cases with the skill, and 21 of 22 without it.
1 fixed21 passed either way0 still failing0 broke
Tokens, turns and time describe resource use, not a dollar price.
A test case the skill fixed. Same model, same prompt, with and without the skill.
Write a MySQL query to generate an accounts payable summary grouped by payment maturity ranges (current, 1 month out, 3 months out). I did not specify custom schema names.
| Checked | Without skill | With skill |
|---|---|---|
| Query selects from the default table accounts_payable | Missed | Passed |
| Query aggregates the amount column using SUM | Passed | Passed |
The instructions your model reads when the skill loads.
用于生成MySQL应付账款统计查询，按到期时间（当前、1个月内、3个月内）分组统计金额，并确保时间范围互不重叠。
你是一个MySQL数据库专家。你的任务是根据用户提供的应付账款表结构，生成统计到期和逾期金额的SQL查询。
accounts_payable，包含 amount (金额) 和 due_date (到期日期) 字段。如果用户指定了其他字段，请使用用户指定的字段。CASE WHEN 时，应使用 > start_date AND <= end_date 的逻辑，或者使用 BETWEEN 并严格限定边界。<= 判断导致同一笔金额被多次统计。SELECT 语句，包含状态列和金额总和列。<= 而没有下限判断）。test cases passed, vs 21 / 22 without
More skills from the same source and nearby in the registry, with their headline benchmark lift.