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?

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);

WITH user_course AS (
    SELECT e.course_id
    FROM enrollments e
    INNER JOIN courses c ON e.course_id = c.course_id
    INNER JOIN users instr ON c.instructor_id = instr.user_id
    WHERE instr.name = 'Amanda Svensson'
    AND e.user_id = $1
    AND e.status = 'active'
    ORDER BY e.enrolled_at DESC
    LIMIT 1
)
SELECT l.video_url
FROM lessons l
INNER JOIN user_course uc ON l.course_id = uc.course_id
ORDER BY l.order_index DESC
LIMIT 1;