SQL

Natural language to SQL query generation evaluates text-to-query fidelity and schema reasoning. This task is particularly relevant for analytics chat assistants and simplified database interfaces.

Duration

Input Tokens

1001

Output Tokens

426

Cost

$0.00

Context

Input

I am in the class with teacher Amanda Svensson, I can't find the link to the video for the last lesson. Can you provide me with it?

Expected output

SELECT l.video_url FROM lessons l JOIN courses c ON l.course_id = c.course_id JOIN users u ON c.instructor_id = u.user_id WHERE u.name = 'Amanda Svensson' AND l.order_index = (SELECT MAX(order_index) FROM lessons l2 WHERE l2.course_id = c.course_id);

Model output

SELECT l.video_url FROM lessons l JOIN courses c ON l.course_id = c.course_id JOIN enrollments e ON c.course_id = e.course_id WHERE e.user_id = (SELECT user_id FROM users WHERE name = 'Amanda Svensson') AND c.instructor_id = (SELECT user_id FROM users WHERE name = 'Amanda Svensson') ORDER BY l.order_index DESC LIMIT 1;