Compare the smallest enrollment of schools in each state using a bar chart, and I want to display by the X-axis in asc.
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)
)

CREATE TABLE Tryout (
    pID numeric(5,0),
    cName varchar(20),
    pPos varchar(8),
    decision varchar(3)
)
SELECT cName, MIN(enr) FROM College GROUP BY state ORDER BY cName
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: Compare the smallest enrollment of schools in each state using a bar chart, and I want to display by the X-axis in asc. ### Input: 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)
)

CREATE TABLE Tryout (
    pID numeric(5,0),
    cName varchar(20),
    pPos varchar(8),
    decision varchar(3)
) ### Response: SELECT cName, MIN(enr) FROM College GROUP BY state ORDER BY cName