CREATE OR REPLACE FUNCTION public.fn_professor_list_admin_courses(p_professor_id bigint)
 RETURNS TABLE(course_id integer, name text, language text, active boolean)
 LANGUAGE sql
 STABLE
AS $function$
  SELECT c.course_id, c.name, c.language, c.active
  FROM public.course_admins ca
  JOIN public.courses c ON c.course_id = ca.course_id
  WHERE ca.professor_id = p_professor_id
  ORDER BY c.name;
$function$
;