Input Tokens
0
Output Tokens
0
Duration
0
Cost
0
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 video_url FROM lessons WHERE course_id = (SELECT course_id FROM courses WHERE instructor_id = (SELECT user_id FROM users WHERE name = 'Amanda Svensson' AND role = 'instructor') LIMIT 1) AND is_draft = FALSE ORDER BY order_index DESC LIMIT 1;