How many students does each advisor have?
SELECT advisor ,  count(*) FROM Student GROUP BY advisor
SELECT advisor ,  count(*) FROM Student GROUP BY advisor
[{'Advisor': 1121, 'count(*)': 3}, {'Advisor': 1148, 'count(*)': 3}, {'Advisor': 2192, 'count(*)': 4}, {'Advisor': 2311, 'count(*)': 3}, {'Advisor': 5718, 'count(*)': 2}, {'Advisor': 7134, 'count(*)': 2}, {'Advisor': 7271, 'count(*)': 2}, {'Advisor': 7712, 'count(*)': 1}, {'Advisor': 7723, 'count(*)': 1}, {'Advisor': 7792, 'count(*)': 1}, {'Advisor': 8423, 'count(*)': 1}, {'Advisor': 8721, 'count(*)': 1}, {'Advisor': 8722, 'count(*)': 3}, {'Advisor': 8723, 'count(*)': 1}, {'Advisor': 8741, 'count(*)': 1}, {'Advisor': 8772, 'count(*)': 3}, {'Advisor': 8918, 'count(*)': 1}, {'Advisor': 9172, 'count(*)': 1}]