instruction: Show last names for all student who are on scholarship, and count them by a bar chart, and could you sort in descending by the y-axis?
response: SELECT LName, COUNT(LName) FROM SportsInfo AS T1 JOIN Student AS T2 ON T1.StuID = T2.StuID WHERE T1.OnScholarship = 'Y' GROUP BY LName ORDER BY COUNT(LName) DESC