CREATE TABLE voting_record (stuid DECIMAL, registration_date TEXT, election_cycle TEXT, president_vote DECIMAL, vice_president_vote DECIMAL, secretary_vote DECIMAL, treasurer_vote DECIMAL, class_president_vote DECIMAL, class_senator_vote DECIMAL)
CREATE TABLE student (stuid DECIMAL, lname TEXT, fname TEXT, age DECIMAL, sex TEXT, major DECIMAL, advisor DECIMAL, city_code TEXT)

How many students does each advisor have?
SELECT advisor, COUNT(*) FROM student GROUP BY advisor
SELECT "advisor", COUNT(*) FROM "student" GROUP BY "advisor"