SQL · 4 checks · max 500 tokens · benched 2026-09-16
OpenAI models side by side on "Products over 100 units with HAVING": GPT-5.4 Nano scores 10/10; GPT-5.4 Nano is the cheapest answer scoring 8+ at $0.07 per 1,000 runs. Outputs, checks, judge reasons, latency and cost.
System
You are a database engineer. Reply with a single SQL statement and nothing else.
User
Tables: products(id, name) and order_items(product_id, quantity). Write one standard SQL query that lists product names whose total quantity sold across all order_items is greater than 100. Filter the aggregate with a HAVING clause.
Rubric for the judge: Join, SUM(quantity), GROUP BY product, HAVING > 100; returns names only; no WHERE on the aggregate.
Every cell is one OpenRouter call at temperature 0 with the prompt's token cap and reasoning effort "low" where the model supports it. Cost is usage × the catalogue rate in models.json. Quality is one judge call to anthropic/claude-haiku-4.5 against the prompt's rubric, cached per prompt version.
openai/gpt-5.5
73 in · 82 out (33 reasoning) · 22 words · checks 4/4
SELECT p.name FROM products AS p JOIN order_items AS oi ON oi.product_id = p.id GROUP BY p.id, p.name HAVING SUM(oi.quantity) > 100;
Judge: Query correctly joins products and order_items, groups by product, uses HAVING with SUM(quantity) > 100, returns only names, and contains no WHERE clause on the aggregate.
openai/gpt-5.4
73 in · 57 out (10 reasoning) · 22 words · checks 4/4
SELECT p.name FROM products AS p JOIN order_items AS oi ON oi.product_id = p.id GROUP BY p.id, p.name HAVING SUM(oi.quantity) > 100;
Judge: Query correctly joins products and order_items, groups by product, uses HAVING with SUM(quantity) > 100, returns only names, and contains no WHERE clause on the aggregate.
openai/gpt-5.4-mini
73 in · 57 out (10 reasoning) · 20 words · checks 4/4
SELECT p.name FROM products p JOIN order_items oi ON oi.product_id = p.id GROUP BY p.id, p.name HAVING SUM(oi.quantity) > 100;
Judge: Query correctly joins products and order_items, groups by product, uses HAVING with SUM(quantity) > 100, returns names only, and contains no WHERE clause on the aggregate.
openai/gpt-5.4-nano
73 in · 42 out · 21 words · checks 4/4
SELECT p.name FROM products AS p JOIN order_items AS oi ON oi.product_id = p.id GROUP BY p.name HAVING SUM(oi.quantity) > 100;
Judge: Query correctly joins products and order_items, groups by product name, uses SUM(quantity) in HAVING clause to filter aggregates > 100, returns only names, and contains no WHERE clause on the aggregate.
openai/gpt-5.3-codex
73 in · 82 out (35 reasoning) · 22 words · checks 4/4
SELECT p.name FROM products AS p JOIN order_items AS oi ON oi.product_id = p.id GROUP BY p.id, p.name HAVING SUM(oi.quantity) > 100;
Judge: Query correctly joins products and order_items, groups by product, uses HAVING with SUM(quantity) > 100, returns only names, and contains no WHERE clause on the aggregate.
SQL: Join, SUM(quantity), GROUP BY product, HAVING > 100; returns names only; no WHERE on the aggregate. The deterministic checks are regex, regex, regex, regex.
If the judge's bar of 8/10 is good enough for you, GPT-5.4 Nano at $0.07 per 1,000 runs. If you need the top score, GPT-5.4 Nano at $0.07 per 1,000 runs.
Run it yourself
Re-run this prompt on OpenAI with your own OpenRouter key, or tweak the wording and see what changes.
More OpenAI prompts
If our calculators helped you cut down on hidden AI wallet leaks, thanks for using them. A tiny fraction of your savings is what keeps our pricing indexes updated daily.
Not sure which AI is cheapest for your use case? Find out in 30 seconds — no signup required.
AI cost intelligence
Join the OverpayingForAI list for pricing updates, cheaper alternatives, and practical buying guidance.
Now tracking 50+ AI tools, models, platforms, subscriptions, coding tools, and automation products.