CREATE OR REPLACE VIEW public.vw_enrolled_student AS
 SELECT sp.partner_id AS student_id,
    sp.tutor_id,
    sp.course_id,
    sp.level_id,
    sp.status AS enrollment_status,
    sp.updated_at,
    sp.remarks,
    p.name AS student_name,
    p.surname AS student_surname,
    p.email AS student_email,
    p.phone AS student_phone,
    p.country AS student_country,
    p.zinzino_range AS student_zinzino_range,
    COALESCE(l.name, ('Nivel '::text || sp.level_id::text)::character varying) AS level_name,
    COALESCE(l.zoom_room_name, l.name) AS zoom_room_name,
    l.active AS level_active
   FROM student_profiles sp
     JOIN partners p ON p.partner_id = sp.partner_id
     LEFT JOIN levels l ON l.level_id = sp.level_id AND l.course_id = sp.course_id;;