Duration
45s
Input Tokens
1189
Output Tokens
223
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 users u
JOIN courses c ON u.user_id = c.instructor_id
JOIN lessons l ON c.course_id = l.course_id
WHERE u.name = 'Amanda Svensson'
AND u.role = 'instructor'
AND c.is_published = TRUE
AND l.is_draft = FALSE
AND l.video_url IS NOT NULL
AND l.order_index = (
SELECT MAX(l2.order_index)
FROM lessons l2
WHERE l2.course_id = c.course_id
AND l2.is_draft = FALSE
);