CREATE OR REPLACE FUNCTION public.fn_schedule_list(p_course_id integer)
 RETURNS jsonb
 LANGUAGE sql
 STABLE
AS $function$
  SELECT COALESCE(jsonb_agg(row_to_json(s.*) ORDER BY s.created_at), '[]'::jsonb)
  FROM public.session_schedules s
  WHERE s.course_id = p_course_id;
$function$
;