CREATE OR REPLACE FUNCTION public.fn_professor_list_course_guests(p_course_id integer)
 RETURNS TABLE(email text, name text, surname text, tutor_name text, tutor_email text)
 LANGUAGE sql
 STABLE
AS $function$
  SELECT guest_email::text, name::text, surname::text, tutor_full_name AS tutor_name, tutor_email::text
  FROM public.vw_guest_with_tutor
  WHERE course_id = p_course_id
  ORDER BY surname, name;
$function$
;