gistfile1.txt

create table equestria_votes (id int not null primary key auto_increment, county varchar(255), district int, candidate varchar(255), votes int);

insert into equestria_votes (county, district, candidate, votes) values 
('Ponyville',  1,   'Princess Celestia',  '15944'),
('Ponyville',  1,   'Princess Luna',    '11921'),
('Cloudsdale',   1,   'Princess Celestia',  '4573'),
('Cloudsdale',   1,   'Princess Luna',    '6156'),
('Appleloosa',  1,   'Princess Celestia',  '434'),
('Appleloosa',  1,   'Princess Luna',    '1090'),
('Canterlot',   1,   'Princess Celestia',  '3723'),
('Canterlot',   1,   'Princess Luna',    '5245'),
('Manehatten',   1,   'Princess Celestia',  '2343'),
('Manehatten',   1,   'Princess Luna',    '2391');