CREATE TABLE SportsInfo (StuID NUMBER, SportName VARCHAR2, HoursPerWeek NUMBER, GamesPlayed NUMBER, OnScholarship VARCHAR2)
CREATE TABLE Student (StuID NUMBER, LName VARCHAR2, Fname VARCHAR2, Age NUMBER, Sex VARCHAR2, Major NUMBER, Advisor NUMBER, city_code VARCHAR2)
CREATE TABLE Video_Games (GameID NUMBER, GName VARCHAR2, GType VARCHAR2)
CREATE TABLE Plays_Games (StuID NUMBER, GameID NUMBER, Hours_Played NUMBER)

What are the last names for all scholarship students, and count them by a bar chart, I want to rank x axis in desc order.
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 LName DESC
SELECT "LName", COUNT("LName") FROM "SportsInfo" "T1" JOIN "Student" "T2" ON "T1"."StuID" = "T2"."StuID" WHERE "T1"."OnScholarship" = 'Y' GROUP BY "LName" ORDER BY "LName" DESC