How many students are enrolled in colleges that have student accepted during tryouts, and in which states are those colleges Show bar chart, I want to display x axis from low to high order.
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)
)

CREATE TABLE College (
    cName varchar(20),
    state varchar(2),
    enr 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
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, I want to display x axis from low to high order. ### Input: 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)
)

CREATE TABLE College (
    cName varchar(20),
    state varchar(2),
    enr 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