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

Plot the total number by grouped by country as a bar graph, and could you rank by the x-axis in desc?
SELECT Country, COUNT(*) FROM member GROUP BY Country ORDER BY Country DESC
SELECT "Country", COUNT(*) FROM "member" GROUP BY "Country" ORDER BY "Country" DESC