Database: allergy_1
Question: How many students does each advisor have?
SQL:
SELECT advisor ,  count(*) FROM Student GROUP BY advisor