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
3s
Input Tokens
1019
Output Tokens
447
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.* FROM users u WHERE u.role = 'student' AND u.created_at >= date_trunc('year', CURRENT_DATE) AND EXISTS (SELECT 1 FROM completions c WHERE c.user_id = u.user_id);