CREATE TABLE member (Member_ID NUMBER, Name CLOB, Country CLOB, College_ID NUMBER)
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)

A bar chart showing the number of members in each country, and rank by the names in desc.
SELECT Country, COUNT(Country) FROM member GROUP BY Country ORDER BY Country DESC
SELECT "Country", COUNT("Country") FROM "member" GROUP BY "Country" ORDER BY "Country" DESC