USE test;

CREATE TABLE States (
  Code CHAR(2) NOT NULL
, Name VARCHAR(25) NOT NULL
, PRIMARY KEY (Code)
);

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