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
WITH student AS (
SELECT user_id
FROM users
WHERE email = $1
),
target_course AS (
SELECT c.course_id
FROM enrollments e
JOIN courses c ON c.course_id = e.course_id
JOIN users i ON i.user_id = c.instructor_id
JOIN student s ON s.user_id = e.user_id
WHERE i.name = 'Amanda Svensson'
AND e.status = 'active'
AND c.is_published = TRUE
ORDER BY e.enrolled_at DESC
LIMIT 1
)
SELECT l.video_url
FROM lessons l
JOIN target_course tc ON tc.course_id = l.course_id
WHERE COALESCE(l.is_draft, TRUE) = FALSE
AND l.video_url IS NOT NULL
ORDER BY l.order_index DESC NULLS LAST, l.lesson_id DESC
LIMIT 1;