CREATE TABLE coach (Coach_ID NUMBER, Coach_name CLOB, Gender CLOB, Club_ID NUMBER, Rank NUMBER)
CREATE TABLE player (Player_ID NUMBER, Sponsor_name CLOB, Player_name CLOB, Gender CLOB, Residence CLOB, Occupation CLOB, Votes NUMBER, Rank CLOB)
CREATE TABLE match_result (Rank NUMBER, Club_ID NUMBER, Gold NUMBER, Big_Silver NUMBER, Small_Silver NUMBER, Bronze NUMBER, Points NUMBER)
CREATE TABLE club (Club_ID NUMBER, Club_name CLOB, Region CLOB, Start_year NUMBER)
CREATE TABLE player_coach (Player_ID NUMBER, Coach_ID NUMBER, Starting_year NUMBER)

For players whose occupation is not 'Researcher', tell me the proportion of their residences with a pie chart.
SELECT Residence, COUNT(Residence) FROM player WHERE Occupation <> "Researcher" GROUP BY Residence
SELECT "Residence", COUNT("Residence") FROM "player" WHERE "Occupation" <> "Researcher" GROUP BY "Residence"