-- build hero
--builds the hero database using SQLite 
DROP TABLE hero;

CREATE TABLE hero (
  id INTEGER PRIMARY KEY,
  name varchar(30),
  power varchar(30),
  weapon varchar(30),
  transportation varchar(30)
);

INSERT INTO hero VALUES (0, 'Professor One', 'Earthquake generation', 'Laser Pointer', 'Binary Cow');
INSERT INTO hero VALUES (1, 'Bat Worm', 'Super Speed', 'Worm belt', 'Bat taxi');
INSERT INTO hero VALUES (2, 'Millennium Panther', 'Death Breath', 'Panther Bullets', 'Panther Submarine');
INSERT INTO hero VALUES (3, 'Lightning Guardian', 'Electric Toe', 'Guardian Missles', 'Guardian Moped');
INSERT INTO hero VALUES (4, 'Yak-Bot', 'Super Yurt', 'Yakbutter flamethrower', 'Yak Dirigible');

SELECT * FROM hero where power like 'E%';