Database: allergy_1
Question: Show all advisors and corresponding number of students.
SQL:
SELECT advisor ,  count(*) FROM Student GROUP BY advisor