CREATE TABLE competition_result (Competition_ID NUMBER, Club_ID_1 NUMBER, Club_ID_2 NUMBER, Score CLOB)
CREATE TABLE competition (Competition_ID NUMBER, Year FLOAT, Competition_type CLOB, Country CLOB)
CREATE TABLE club (Club_ID NUMBER, name CLOB, Region CLOB, Start_year CLOB)
CREATE TABLE club_rank (Rank FLOAT, Club_ID NUMBER, Gold FLOAT, Silver FLOAT, Bronze FLOAT, Total FLOAT)
CREATE TABLE player (Player_ID NUMBER, name CLOB, Position CLOB, Club_ID NUMBER, Apps FLOAT, Tries FLOAT, Goals CLOB, Points FLOAT)

List the types of competition and the number of competitions of each type. Visualize by bar chart.
SELECT Competition_type, COUNT(*) FROM competition GROUP BY Competition_type
SELECT "Competition_type", COUNT(*) FROM "competition" GROUP BY "Competition_type"