create table state
(
  state 	char(2)      	PRIMARY KEY,
  description 	varchar(30)	NOT NULL
);

INSERT INTO state (state, description) VALUES('AL','Alabama');
INSERT INTO state (state, description) VALUES('AK','Alaska');
INSERT INTO state (state, description) VALUES('AZ','Arizona'); 
INSERT INTO state (state, description) VALUES('AR','Arkansas'); 
INSERT INTO state (state, description) VALUES('CA','California'); 
INSERT INTO state (state, description) VALUES('CO','Colorado'); 
INSERT INTO state (state, description) VALUES('CT','Connecticut'); 
INSERT INTO state (state, description) VALUES('DE','Delaware'); 
INSERT INTO state (state, description) VALUES('DC','District of Columbia');
INSERT INTO state (state, description) VALUES('FL','Florida');
INSERT INTO state (state, description) VALUES('GA','Georgia'); 
INSERT INTO state (state, description) VALUES('GU','Guam');
INSERT INTO state (state, description) VALUES('HI','Hawaii');
INSERT INTO state (state, description) VALUES('ID','Idaho'); 
INSERT INTO state (state, description) VALUES('IL','Illinois'); 
INSERT INTO state (state, description) VALUES('IN','Indiana'); 
INSERT INTO state (state, description) VALUES('IA','Iowa'); 
INSERT INTO state (state, description) VALUES('KS','Kansas'); 
INSERT INTO state (state, description) VALUES('KY','Kentucky'); 
INSERT INTO state (state, description) VALUES('LA','Louisiana'); 
INSERT INTO state (state, description) VALUES('ME','Maine'); 
INSERT INTO state (state, description) VALUES('MD','Maryland'); 
INSERT INTO state (state, description) VALUES('MA','Massachusetts'); 
INSERT INTO state (state, description) VALUES('MI','Michigan'); 
INSERT INTO state (state, description) VALUES('MN','Minnesota'); 
INSERT INTO state (state, description) VALUES('MS','Mississippi'); 
INSERT INTO state (state, description) VALUES('MO','Missouri'); 
INSERT INTO state (state, description) VALUES('MT','Montana');
INSERT INTO state (state, description) VALUES('NE','Nebraska'); 
INSERT INTO state (state, description) VALUES('NV','Nevada'); 
INSERT INTO state (state, description) VALUES('NH','New Hampshire'); 
INSERT INTO state (state, description) VALUES('NJ','New Jersey'); 
INSERT INTO state (state, description) VALUES('NM','New Mexico'); 
INSERT INTO state (state, description) VALUES('NY','New York'); 
INSERT INTO state (state, description) VALUES('NC','North Carolina'); 
INSERT INTO state (state, description) VALUES('ND','North Dakota'); 
INSERT INTO state (state, description) VALUES('OH','Ohio'); 
INSERT INTO state (state, description) VALUES('OK','Oklahoma'); 
INSERT INTO state (state, description) VALUES('OR','Oregon'); 
INSERT INTO state (state, description) VALUES('PA','Pennsylvania'); 
INSERT INTO state (state, description) VALUES('PR','Puerto Rico');
INSERT INTO state (state, description) VALUES('RI','Rhode Island'); 
INSERT INTO state (state, description) VALUES('SC','South Carolina'); 
INSERT INTO state (state, description) VALUES('SD','South Dakota'); 
INSERT INTO state (state, description) VALUES('TN','Tennessee'); 
INSERT INTO state (state, description) VALUES('TX','Texas');
INSERT INTO state (state, description) VALUES('UT','Utah'); 
INSERT INTO state (state, description) VALUES('VT','Vermont'); 
INSERT INTO state (state, description) VALUES('VA','Virginia'); 
INSERT INTO state (state, description) VALUES('VI','Virgin Islands');
INSERT INTO state (state, description) VALUES('WA','Washington'); 
INSERT INTO state (state, description) VALUES('WV','West Virginia'); 
INSERT INTO state (state, description) VALUES('WI','Wisconsin');
INSERT INTO state (state, description) VALUES('WY','Wyoming'); 
