CREATE OR REPLACE FUNCTION public.fn_tutor_list_students(p_tutor_id bigint, p_course_id integer DEFAULT 1)
 RETURNS TABLE(student_id bigint, student_type text, student_name text, student_surname text, student_email text, student_phone text, student_country text, level_id integer, level_name text, enrollment_status text, enrolled_at timestamp with time zone)
 LANGUAGE sql
 STABLE
AS $function$
  SELECT
    student_id, student_type, student_name, student_surname, student_email,
    student_phone, student_country::text, level_id, level_name, enrollment_status,
    updated_at
  FROM public.vw_student_management_master
  WHERE tutor_id = p_tutor_id
    AND course_id = p_course_id
  ORDER BY updated_at DESC NULLS LAST;
$function$
;