CREATE TABLE CITY (
  id      INTEGER PRIMARY KEY,
  name    VARCHAR(30),
  state   VARCHAR(30),
  country VARCHAR(30)
);

INSERT INTO CITY (ID, NAME, STATE, COUNTRY) values (2000, 'Washington', 'DC', 'US');
INSERT INTO CITY (ID, NAME, STATE, COUNTRY) values (2001, 'San Francisco', 'CA', 'US');
