/* create table */ CREATE TABLE states ( StateName VARCHAR(255), Abbreviation VARCHAR(255), Capital VARCHAR(255), Statehood VARCHAR(255), ID INT ); /* insert data */ INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Alabama', 'AL', 'Montgomery', 1819, 1); INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Alaska', 'AK', 'Juneau', 1959, 2); INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('American Samoa', 'AS', 'Pago Pago', 1899, 3); INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Arizona', 'AZ', 'Phoenix', 1912, 4); INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Arkansas', 'AR', 'Little Rock', 1836, 5);