Give me a histogram for how many students play each sport?, sort from high to low by the Y.
CREATE TABLE SportsInfo (
    StuID INTEGER,
    SportName VARCHAR(32),
    HoursPerWeek INTEGER,
    GamesPlayed INTEGER,
    OnScholarship VARCHAR(1)
)

CREATE TABLE Student (
    StuID INTEGER,
    LName VARCHAR(12),
    Fname VARCHAR(12),
    Age INTEGER,
    Sex VARCHAR(1),
    Major INTEGER,
    Advisor INTEGER,
    city_code VARCHAR(3)
)

CREATE TABLE Video_Games (
    GameID INTEGER,
    GName VARCHAR(40),
    GType VARCHAR(40)
)

CREATE TABLE Plays_Games (
    StuID INTEGER,
    GameID INTEGER,
    Hours_Played INTEGER
)
SELECT SportName, COUNT(*) FROM SportsInfo GROUP BY SportName ORDER BY COUNT(*) DESC
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Give me a histogram for how many students play each sport?, sort from high to low by the Y. ### Input: CREATE TABLE SportsInfo (
    StuID INTEGER,
    SportName VARCHAR(32),
    HoursPerWeek INTEGER,
    GamesPlayed INTEGER,
    OnScholarship VARCHAR(1)
)

CREATE TABLE Student (
    StuID INTEGER,
    LName VARCHAR(12),
    Fname VARCHAR(12),
    Age INTEGER,
    Sex VARCHAR(1),
    Major INTEGER,
    Advisor INTEGER,
    city_code VARCHAR(3)
)

CREATE TABLE Video_Games (
    GameID INTEGER,
    GName VARCHAR(40),
    GType VARCHAR(40)
)

CREATE TABLE Plays_Games (
    StuID INTEGER,
    GameID INTEGER,
    Hours_Played INTEGER
) ### Response: SELECT SportName, COUNT(*) FROM SportsInfo GROUP BY SportName ORDER BY COUNT(*) DESC