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

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" AS "T1" JOIN "Student" AS "T2" ON "T1"."StuID" = "T2"."StuID" WHERE "T1"."OnScholarship" = 'Y' GROUP BY "LName" ORDER BY "LName" DESC NULLS LAST