CREATE TABLE Student (StuID INT, LName VARCHAR, Fname VARCHAR, Age INT, Sex VARCHAR, Major INT, Advisor INT, city_code VARCHAR)
CREATE TABLE Voting_record (StuID INT, Registration_Date VARCHAR, Election_Cycle VARCHAR, President_Vote INT, Vice_President_Vote INT, Secretary_Vote INT, Treasurer_Vote INT, Class_President_Vote INT, Class_Senator_Vote INT)

For each advisor, report the total number of students advised by him or her. Plot them as scatter chart.
SELECT Advisor, COUNT(*) FROM Student GROUP BY Advisor
SELECT "Advisor", COUNT(*) FROM "Student" GROUP BY "Advisor"