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.

Duration

Input Tokens

1077

Output Tokens

697

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

WITH year_start AS (
    SELECT date_trunc('year', max(created_at)) AS start_of_year
    FROM users
)
SELECT u.user_id,
       u.name,
       u.email
FROM users u
JOIN year_start ys ON u.created_at >= ys.start_of_year
JOIN completions c ON u.user_id = c.user_id
WHERE u.role = 'student'
GROUP BY u.user_id, u.name, u.email;