/* create table */ CREATE TABLE presidents ( President INT, ID INT, FullName VARCHAR(255), Party VARCHAR(255), Terms VARCHAR(255) ); /* insert data */ INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (1, 1, 'George Washington', 'None, Federalist', '1789-1797'); INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (2, 2, 'John Adams', 'Federalist', '1797-1801'); INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (3, 3, 'Thomas Jefferson', 'Democratic-Republican', '1801-1809'); INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (4, 4, 'James Madison', 'Democratic-Republican', '1809-1817'); INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (5, 5, 'James Monroe', 'Democratic-Republican', '1817-1825');