Show all the faculty ranks and the number of students advised by each rank.
CREATE TABLE Faculty (
    rank VARCHAR,
    FacID VARCHAR
)

CREATE TABLE Student (
    advisor VARCHAR
)
SELECT T1.rank, COUNT(*) FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID = T2.advisor GROUP BY T1.rank
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: Show all the faculty ranks and the number of students advised by each rank. ### Input: CREATE TABLE Faculty (
    rank VARCHAR,
    FacID VARCHAR
)

CREATE TABLE Student (
    advisor VARCHAR
) ### Response: SELECT T1.rank, COUNT(*) FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID = T2.advisor GROUP BY T1.rank