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

For players whose occupation is not 'Researcher', tell me the distribution of their residences with a bar chart, and could you display by the total number in desc?
SELECT Residence, COUNT(Residence) FROM player WHERE Occupation <> "Researcher" GROUP BY Residence ORDER BY COUNT(Residence) DESC
SELECT "Residence", COUNT("Residence") FROM "player" WHERE "Occupation" <> "Researcher" GROUP BY "Residence" ORDER BY COUNT("Residence") DESC NULLS LAST