Thanks Marvin!

SELECT distinct top (100)percent

dbo.COURSES.CRS_SUBJECT AS 'Course_Subject',

dbo.COURSES.CRS_NO ...