/* 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');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (6, 6, 'John Quincy Adams', 'Democratic-Republican', '1825-1829');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (7, 7, 'Andrew Jackson', 'Democrat', '1829-1837');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (8, 8, 'Martin van Buren', 'Democrat', '1837-1841');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (9, 9, 'William H. Harrison', 'Whig', 1841);
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (10, 10, 'John Tyler', 'Whig', '1841-1845');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (11, 11, 'James K. Polk', 'Democrat', '1845-1849');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (12, 12, 'Zachary Taylor', 'Whig', '1849-1850');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (13, 13, 'Millard Fillmore', 'Whig', '1850-1853');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (14, 14, 'Franklin Pierce', 'Democrat', '1853-1857');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (15, 15, 'James Buchanan', 'Democrat', '1857-1861');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (16, 16, 'Abraham Lincoln', 'Republican', '1861-1865');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (17, 17, 'Andrew Johnson', 'National Union', '1865-1869');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (18, 18, 'Ulysses S. Grant', 'Republican', '1869-1877');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (19, 19, 'Rutherford Hayes', 'Republican', '1877-1881');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (20, 20, 'James Garfield', 'Republican', 1881);
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (21, 21, 'Chester Arthur', 'Republican', '1881-1885');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (22, 22, 'Grover Cleveland', 'Democrat', '1885-1889');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (23, 23, 'Benjamin Harrison', 'Republican', '1889-1893');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (24, 24, 'Grover Cleveland', 'Democrat', '1893-1897');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (25, 25, 'William McKinley', 'Republican', '1897-1901');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (26, 26, 'Theodore Roosevelt', 'Republican', '1901-1909');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (27, 27, 'William Taft', 'Republican', '1909-1913');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (28, 28, 'Woodrow Wilson', 'Democrat', '1913-1921');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (29, 29, 'Warren Harding', 'Republican', '1921-1923');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (30, 30, 'Calvin Coolidge', 'Republican', '1923-1929');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (31, 31, 'Herbert C. Hoover', 'Republican', '1929-1933');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (32, 32, 'Franklin Delano Roosevelt', 'Democrat', '1933-1945');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (33, 33, 'Harry S Truman', 'Democrat', '1945-1953');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (34, 34, 'Dwight David Eisenhower', 'Republican', '1953-1961');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (35, 35, 'John Fitzgerald Kennedy', 'Democrat', '1961-1963');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (36, 36, 'Lyndon Baines Johnson', 'Democrat', '1963-1969');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (37, 37, 'Richard Milhous Nixon', 'Republican', '1969-1974');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (38, 38, 'Gerald R. Ford', 'Republican', '1974-1977');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (39, 39, 'Jimmy Carter', 'Democrat', '1977-1981');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (40, 40, 'Ronald Wilson Reagan', 'Republican', '1981-1989');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (41, 41, 'George H. W. Bush', 'Republican', '1989-1993');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (42, 42, 'Bill Clinton', 'Democrat', '1993-2001');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (43, 43, 'George W. Bush', 'Republican', '2001-2009');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (44, 44, 'Barack Obama', 'Democrat', '2009-2017');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (45, 45, 'Donald Trump', 'Republican', '2017-2021');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (46, 46, 'Joe Biden', 'Democrat', '2021-2025');
INSERT INTO presidents (President, ID, FullName, Party, Terms) VALUES (47, 47, 'Donald Trump', 'Republican', '2025-2029');