AmwPEsrw

1CREATE TABLE IF NOT EXISTS usa_bigest_cites (
2    `Place` INT,
3    `City` VARCHAR(12) CHARACTER SET utf8,
4    `Population` INT,
5    `Latitude` NUMERIC(9, 7),
6    `Longitude` NUMERIC(10, 7)
7);
8INSERT INTO usa_bigest_cites VALUES
9    (1,'New Jork',10250567,40.7127753,-74.0059728),
10    (2,'Los Angeles',3849378,34.0522342,-118.2436849),
11    (3,'Chicago',2833321,41.8781136,-87.6297982),
12    (4,'Houston',2144491,29.7604267,-95.3698028),
13    (5,'Phoenix',1512986,33.4483771,-112.0740373),
14    (6,'Philadelphia',1448394,39.9525839,-75.1652215),
15    (7,'San Antonio',1296682,29.4241219,-98.4936282),
16    (8,'San Diego',1256951,32.715738,-117.1610838),
17    (9,'Dallas',1232940,32.7766642,-96.7969879),
18    (10,'San José',929936,37.3382082,-121.8863286);