What are their first names?
SELECT T2.fname FROM Sportsinfo AS T1 JOIN Student AS T2 ON T1.StuID   =   T2.StuID WHERE T1.onscholarship   =   'Y'
their first names refer to fname from the Student table; onscholarship = 'Y' indicates students who are on scholarship; joining Sportsinfo and Student tables on StuID connects sports information to individual students;