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

Visualize a scatter chart on how many students does each advisor have?
SELECT Advisor, COUNT(*) FROM Student GROUP BY Advisor
SELECT "Advisor", COUNT(*) FROM "Student" GROUP BY "Advisor"