1
2
3
4

table year as Year, semester as Semester
from #sfu_course 
where file.name[0] = ")" 
sort year desc, semester desc