order by

select
  case
  when std.F$WFORMED = 0
   then 'Очная'
  when std.F$WFORMED = 1
   then 'Заочная'
  when std.F$WFORMED = 2
   then 'Очно-заочная'
 end form,
 l.F$WSEMESTR as "Семестр",
 fac.F$NAME as "Факультет",
 grp.F$NAME as "Группа",
 convert(varchar(1), grp.F$COURSE) + ' курс' as "Курс",
 std.F$FIO,  
 d.F$NAME as "Дисциплина",                      
 isnull(c.F$NAME, 'Оценка отсутствует') as "Оценка",
from 
 T$U_MARKS m left join T$CATALOGS c on c.F$NREC = m.F$CMARK
 inner join T$U_LIST l on l.F$NREC = m.F$CLIST
 inner join T$U_DISCIPLINE d on d.F$NREC = l.F$CDIS
 inner join T$PERSONS pr on pr.F$NREC = m.F$CPERSONS
 inner join T$U_STUDENT std on std.F$CPERSONS = pr.F$NREC
 inner join T$U_STUDGROUP grp on grp.F$NREC = std.F$CSTGR
 inner join T$CATALOGS fac on fac.F$NREC = std.F$CFACULTY
where 
 l.F$WTYPE = 2
order by
 convert(varchar(1), grp.F$COURSE),
 grp.F$NAME,
 std.F$FIO