CREATE OR REPLACE FUNCTION public.fn_professor_list_course_students(p_course_id integer)
 RETURNS TABLE(partner_id bigint, name text, surname text, email text, level_name text, status text)
 LANGUAGE sql
 STABLE
AS $function$
  SELECT student_id, student_name, student_surname, student_email, level_name, enrollment_status
  FROM public.vw_enrolled_student
  WHERE course_id = p_course_id
  ORDER BY student_surname, student_name;
$function$
;