How many students are enrolled in colleges that have student accepted during tryouts, and in which states are those colleges Show bar chart, show by the bars in descending.
CREATE TABLE College (
    cName varchar(20),
    state varchar(2),
    enr numeric(5,0)
)

CREATE TABLE Tryout (
    pID numeric(5,0),
    cName varchar(20),
    pPos varchar(8),
    decision varchar(3)
)

CREATE TABLE Player (
    pID numeric(5,0),
    pName varchar(20),
    yCard varchar(3),
    HS numeric(5,0)
)
SELECT state, enr FROM College AS T1 JOIN Tryout AS T2 ON T1.cName = T2.cName WHERE T2.decision = 'yes' ORDER BY state 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: How many students are enrolled in colleges that have student accepted during tryouts, and in which states are those colleges Show bar chart, show by the bars in descending. ### Input: CREATE TABLE College (
    cName varchar(20),
    state varchar(2),
    enr numeric(5,0)
)

CREATE TABLE Tryout (
    pID numeric(5,0),
    cName varchar(20),
    pPos varchar(8),
    decision varchar(3)
)

CREATE TABLE Player (
    pID numeric(5,0),
    pName varchar(20),
    yCard varchar(3),
    HS numeric(5,0)
) ### Response: SELECT state, enr FROM College AS T1 JOIN Tryout AS T2 ON T1.cName = T2.cName WHERE T2.decision = 'yes' ORDER BY state DESC