CREATE TABLE round (Round_ID NUMBER, Member_ID NUMBER, Decoration_Theme CLOB, Rank_in_Round NUMBER)
CREATE TABLE college (College_ID NUMBER, Name CLOB, Leader_Name CLOB, College_Location CLOB)
CREATE TABLE member (Member_ID NUMBER, Name CLOB, Country CLOB, College_ID NUMBER)

A bar chart showing the number of members in each country, rank from low to high by the bars please.
SELECT Country, COUNT(Country) FROM member GROUP BY Country ORDER BY Country
SELECT "Country", COUNT("Country") FROM "member" GROUP BY "Country" ORDER BY "Country"