SQL Generation

Turn plain-English questions into correct SQL against a schema. The skill behind analytics chat, natural-language dashboards, and 'just ask the database' interfaces.

100
Duration
14s
Input Tokens
1021
Output Tokens
133
Cost
$0.00
Context
Input
Which students joined this year and already finished a lesson?
Expected output
SELECT DISTINCT u.name FROM users u JOIN completions c ON u.user_id = c.user_id WHERE u.role = 'student' AND u.created_at >= DATE_TRUNC('year', CURRENT_DATE);
Model output
SELECT DISTINCT u.name FROM users u JOIN completions c ON u.user_id = c.user_id WHERE EXTRACT(YEAR FROM u.created_at) = EXTRACT(YEAR FROM CURRENT_DATE) AND u.role = 'student';