What are their majors?
SELECT T2.major FROM Sportsinfo AS T1 JOIN Student AS T2 ON T1.StuID   =   T2.StuID WHERE T1.onscholarship   =   'Y'
their refers to students on scholarship; majors refers to the field of study or academic discipline in T2.major;