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)

Return a bar chart showing how many members have visited for each college location, show from high to low by the y axis.
SELECT College_Location, COUNT(College_Location) FROM college AS T1 JOIN member AS T2 ON T1.College_ID = T2.College_ID GROUP BY College_Location ORDER BY COUNT(College_Location) DESC
SELECT "College_Location", COUNT("College_Location") FROM "college" "T1" JOIN "member" "T2" ON "T1"."College_ID" = "T2"."College_ID" GROUP BY "College_Location" ORDER BY COUNT("College_Location") DESC