Show all advisors and corresponding number of students.
CREATE TABLE Student (advisor VARCHAR)
SELECT advisor, COUNT(*) FROM Student GROUP BY advisor
### Context: CREATE TABLE Student (advisor VARCHAR) ### Question: Show all advisors and corresponding number of students. ### Answer: SELECT advisor, COUNT(*) FROM Student GROUP BY advisor