SELECT Residence, COUNT(Residence) FROM player WHERE Occupation <> "Researcher" GROUP BY Residence ORDER BY COUNT(Residence)
For players whose occupation is not 'Researcher', tell me the distribution of their residences with a bar chart, and I want to show y axis from low to high order.
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
)

CREATE TABLE coach (
    Coach_ID int,
    Coach_name text,
    Gender text,
    Club_ID int,
    Rank int
)

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
)