Show the number of different competition types with a bar graph, sort the number of competition type from high to low order.
CREATE TABLE club (
    Club_ID int,
    name text,
    Region text,
    Start_year text
)

CREATE TABLE competition_result (
    Competition_ID int,
    Club_ID_1 int,
    Club_ID_2 int,
    Score text
)

CREATE TABLE competition (
    Competition_ID int,
    Year real,
    Competition_type text,
    Country text
)

CREATE TABLE club_rank (
    Rank real,
    Club_ID int,
    Gold real,
    Silver real,
    Bronze real,
    Total real
)

CREATE TABLE player (
    Player_ID int,
    name text,
    Position text,
    Club_ID int,
    Apps real,
    Tries real,
    Goals text,
    Points real
)
SELECT Competition_type, COUNT(Competition_type) FROM competition GROUP BY Competition_type ORDER BY COUNT(Competition_type) 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: Show the number of different competition types with a bar graph, sort the number of competition type from high to low order. ### Input: CREATE TABLE club (
    Club_ID int,
    name text,
    Region text,
    Start_year text
)

CREATE TABLE competition_result (
    Competition_ID int,
    Club_ID_1 int,
    Club_ID_2 int,
    Score text
)

CREATE TABLE competition (
    Competition_ID int,
    Year real,
    Competition_type text,
    Country text
)

CREATE TABLE club_rank (
    Rank real,
    Club_ID int,
    Gold real,
    Silver real,
    Bronze real,
    Total real
)

CREATE TABLE player (
    Player_ID int,
    name text,
    Position text,
    Club_ID int,
    Apps real,
    Tries real,
    Goals text,
    Points real
) ### Response: SELECT Competition_type, COUNT(Competition_type) FROM competition GROUP BY Competition_type ORDER BY COUNT(Competition_type) DESC