Return a histogram on how old is each gender, on average?, rank from high to low by the gender.
CREATE TABLE PersonFriend (
    name varchar(20),
    friend varchar(20),
    year INTEGER
)

CREATE TABLE Person (
    name varchar(20),
    age INTEGER,
    city TEXT,
    gender TEXT,
    job TEXT
)
SELECT gender, AVG(age) FROM Person GROUP BY gender ORDER BY gender DESC
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Return a histogram on how old is each gender, on average?, rank from high to low by the gender. ### Input: CREATE TABLE PersonFriend (
    name varchar(20),
    friend varchar(20),
    year INTEGER
)

CREATE TABLE Person (
    name varchar(20),
    age INTEGER,
    city TEXT,
    gender TEXT,
    job TEXT
) ### Response: SELECT gender, AVG(age) FROM Person GROUP BY gender ORDER BY gender DESC