Input Tokens
0
Output Tokens
0
Duration
0
Cost
0
Context
Input
Hi I'm Oscar that enrolled in 2018, I don't remember what courses I completed, can you help me?Expected output
SELECT DISTINCT c.title FROM users u JOIN enrollments e ON u.user_id = e.user_id JOIN lessons l ON l.course_id = e.course_id JOIN completions cp ON cp.lesson_id = l.lesson_id AND cp.user_id = u.user_id JOIN courses c ON c.course_id = l.course_id WHERE u.name ILIKE '%oscar%' AND DATE_TRUNC('year', e.enrolled_at) = DATE '2018-01-01';Model output
WITH oscar_details AS (SELECT user_id FROM users WHERE name = 'Oscar' AND created_at BETWEEN '2018-01-01' AND '2018-12-31') SELECT c.title FROM courses c JOIN enrollments e ON c.course_id = e.course_id WHERE e.user_id IN (SELECT user_id FROM oscar_details) AND e.status = 'completed';