CREATE TABLE potus
(
id INT PRIMARY KEY,
jmeno VARCHAR(40),
od INT,
do INT
);
INSERT INTO potus VALUES (1, George Washington,1789,1797);;
INSERT INTO potus VALUES (2, John Adams, 1797,1801);
INSERT INTO potus VALUES (3, Thomas Jefferson, 1801,1809);
INSERT INTO potus VALUES (4, James Madison, 1809,1817);
INSERT INTO potus VALUES (5, James Monroe, 1817,1825);
INSERT INTO potus VALUES (6, John Quincy Adams, 1825,1829);
INSERT INTO potus VALUES (7, Andrew Jackson, 1829,1837);
INSERT INTO potus VALUES (8, Martin Van Buren, 1837,1841);
INSERT INTO potus VALUES (9, William Henry Harrison, 1841,1841);
INSERT INTO potus VALUES (10, John Tyler, 1841,1845);
INSERT INTO potus VALUES (11, James Knox Polk, 1845,1849);
INSERT INTO potus VALUES (12, Zachary Taylor, 1849,1850);
INSERT INTO potus VALUES (13, Millard Fillmore, 1850,1853);
INSERT INTO potus VALUES (14, Franklin Pierce, 1853,1857);
INSERT INTO potus VALUES (15, James Buchanan, 1857,1861);
INSERT INTO potus VALUES (16, Abraham Lincoln, 1861,1865);
INSERT INTO potus VALUES (17, Andrew Johnson, 1865,1869);
INSERT INTO potus VALUES (18, Ulysses Simpson Grant, 1869,1877);
INSERT INTO potus VALUES (19, Rutherford Birchard Hayes, 1877,1881);
INSERT INTO potus VALUES (20, James Garfield, 1881,1881);
INSERT INTO potus VALUES (21, Chester Arthur, 1881,1885);
INSERT INTO potus VALUES (22, Grover Cleveland, 1885,1889);
INSERT INTO potus VALUES (23, Benjamin Harrison, 1889,1893);
INSERT INTO potus VALUES (24, Grover Cleveland, 1893,1897);
INSERT INTO potus VALUES (25, William McKinley, 1897,1901);
INSERT INTO potus VALUES (26, Theodore Roosevelt, 1901,1909);
INSERT INTO potus VALUES (27, William Howard Taft, 1909,1913);
INSERT INTO potus VALUES (28, Woodrow Wilson, 1913,1921);
INSERT INTO potus VALUES (29, Warren Gamaliel Harding, 1921,1923);
INSERT INTO potus VALUES (30, Calvin Coolidge, 1923,1929);
INSERT INTO potus VALUES (31, Herbert Hoover, 1929,1933);
INSERT INTO potus VALUES (32, Franklin Delano Roosevelt, 1933,1945);
INSERT INTO potus VALUES (33, Harry S, Truman,1945,1953);
INSERT INTO potus VALUES (34, Dwight David Eisenhower, 1953,1961);
INSERT INTO potus VALUES (35, John Fitzgerald Kennedy, 1961,1963);
INSERT INTO potus VALUES (36, Lyndon Baines Johnson, 1963,1969);
INSERT INTO potus VALUES (37, Richard Milhous Nixon, 1969,1974);
INSERT INTO potus VALUES (38, Gerald Rudolph Ford, 1974,1977);
INSERT INTO potus VALUES (39, Jimmy Carter, 1977,1981);
INSERT INTO potus VALUES (40, Ronald Reagan, 1981,1989);
INSERT INTO potus VALUES (41, George Bush, 1989,1993);
INSERT INTO potus VALUES (42, Bill Clinton, 1993,2001);
INSERT INTO potus VALUES (43, George Walker Bush jr, 2001, NULL)