-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathcreate_population_cities_2025.sql
More file actions
110 lines (107 loc) · 6.47 KB
/
create_population_cities_2025.sql
File metadata and controls
110 lines (107 loc) · 6.47 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
/* @create_population_cities_2025.sql */
/* Data about 100 Largest cities in the world (2025) */
/* Table: cities2024 */
CREATE TABLE IF NOT EXISTS cities2025 (idCity INTEGER PRIMARY KEY,
name CHAR(40),
country CHAR(40),
population INTEGER);
INSERT INTO cities VALUES(1, 'Tokyo', 'Japan', 37036200);
INSERT INTO cities VALUES(2, 'Delhi', 'India', 34665600);
INSERT INTO cities VALUES(3, 'Shanghai', 'China', 30482100);
INSERT INTO cities VALUES(4, 'Dhaka', 'Bangladesh', 24652900);
INSERT INTO cities VALUES(5, 'Cairo', 'Egypt', 23074200);
INSERT INTO cities VALUES(6, 'Sao Paulo', 'Brazil', 22990000);
INSERT INTO cities VALUES(7, 'Mexico City', 'Mexico', 22752400);
INSERT INTO cities VALUES(8, 'Beijing', 'China', 22596500);
INSERT INTO cities VALUES(9, 'Mumbai', 'India', 22089000);
INSERT INTO cities VALUES(10, 'Osaka', 'Japan', 18921600);
INSERT INTO cities VALUES(11, 'Chongqing', 'China', 18171200);
INSERT INTO cities VALUES(12, 'Karachi', 'Pakistan', 18076800);
INSERT INTO cities VALUES(13, 'Kinshasa', 'DR Congo', 17778500);
INSERT INTO cities VALUES(14, 'Lagos', 'Nigeria', 17156400);
INSERT INTO cities VALUES(15, 'Istanbul', 'Turkey', 16236700);
INSERT INTO cities VALUES(16, 'Kolkata', 'India', 15845200);
INSERT INTO cities VALUES(17, 'Buenos Aires', 'Argentina', 15752300);
INSERT INTO cities VALUES(18, 'Manila', 'Philippines', 15230600);
INSERT INTO cities VALUES(19, 'Guangzhou', 'China', 14878700);
INSERT INTO cities VALUES(20, 'Lahore', 'Pakistan', 14825800);
INSERT INTO cities VALUES(21, 'Tianjin', 'China', 14704100);
INSERT INTO cities VALUES(22, 'Bangalore', 'India', 14395400);
INSERT INTO cities VALUES(23, 'Rio de Janeiro', 'Brazil', 13923200);
INSERT INTO cities VALUES(24, 'Shenzhen', 'China', 13545400);
INSERT INTO cities VALUES(25, 'Moscow', 'Russia', 12737400);
INSERT INTO cities VALUES(26, 'Chennai', 'India', 12336000);
INSERT INTO cities VALUES(27, 'Bogota', 'Colombia', 11795800);
INSERT INTO cities VALUES(28, 'Jakarta', 'Indonesia', 11634100);
INSERT INTO cities VALUES(29, 'Lima', 'Peru', 11517300);
INSERT INTO cities VALUES(30, 'Bangkok', 'Thailand', 11391700);
INSERT INTO cities VALUES(31, 'Paris', 'France', 11346800);
INSERT INTO cities VALUES(32, 'Hyderabad', 'India', 11337900);
INSERT INTO cities VALUES(33, 'Nanjing', 'China', 10174900);
INSERT INTO cities VALUES(34, 'Luanda', 'Angola', 10027900);
INSERT INTO cities VALUES(35, 'Seoul', 'South Korea', 10025800);
INSERT INTO cities VALUES(36, 'Chengdu', 'China', 9998870);
INSERT INTO cities VALUES(37, 'London', 'United Kingdom', 9840740);
INSERT INTO cities VALUES(38, 'Ho Chi Minh City', 'Vietnam', 9816320);
INSERT INTO cities VALUES(39, 'Tehran', 'Iran', 9729740);
INSERT INTO cities VALUES(40, 'Nagoya', 'Japan', 9534790);
INSERT INTO cities VALUES(41, 'Xi-an', 'China', 9222080);
INSERT INTO cities VALUES(42, 'Ahmedabad', 'India', 9061820);
INSERT INTO cities VALUES(43, 'Kuala Lumpur', 'Malaysia', 9000280);
INSERT INTO cities VALUES(44, 'Wuhan', 'China', 8986480);
INSERT INTO cities VALUES(45, 'Suzhou', 'China', 8592820);
INSERT INTO cities VALUES(46, 'Hangzhou', 'China', 8591040);
INSERT INTO cities VALUES(47, 'Surat', 'India', 8581730);
INSERT INTO cities VALUES(48, 'Dar es Salaam', 'Tanzania', 8561520);
INSERT INTO cities VALUES(49, 'Baghdad', 'Iraq', 8141120);
INSERT INTO cities VALUES(50, 'Shenyang', 'China', 7974270);
INSERT INTO cities VALUES(51, 'Riyadh', 'Saudi Arabia', 7952860);
INSERT INTO cities VALUES(52, 'New York City', 'United States', 7936530);
INSERT INTO cities VALUES(53, 'Foshan', 'China', 7817160);
INSERT INTO cities VALUES(54, 'Dongguan', 'China', 7772860);
INSERT INTO cities VALUES(55, 'Hong Kong', 'Hong Kong', 7768510);
INSERT INTO cities VALUES(56, 'Pune', 'India', 7525720);
INSERT INTO cities VALUES(57, 'Haerbin', 'China', 7066860);
INSERT INTO cities VALUES(58, 'Santiago', 'Chile', 6999460);
INSERT INTO cities VALUES(59, 'Madrid', 'Spain', 6810530);
INSERT INTO cities VALUES(60, 'Khartoum', 'Sudan', 6754180);
INSERT INTO cities VALUES(61, 'Toronto', 'Canada', 6491290);
INSERT INTO cities VALUES(62, 'Johannesburg', 'South Africa', 6444580);
INSERT INTO cities VALUES(63, 'Belo Horizonte', 'Brazil', 6351680);
INSERT INTO cities VALUES(64, 'Dalian', 'China', 6347380);
INSERT INTO cities VALUES(65, 'Qingdao', 'China', 6217970);
INSERT INTO cities VALUES(66, 'Singapore', 'Singapore', 6157270);
INSERT INTO cities VALUES(67, 'Zhengzhou', 'China', 6156140);
INSERT INTO cities VALUES(68, 'Ji nan Shandong', 'China', 6065850);
INSERT INTO cities VALUES(69, 'Abidjan', 'Ivory Coast', 6056880);
INSERT INTO cities VALUES(70, 'Addis Ababa', 'Ethiopia', 5956680);
INSERT INTO cities VALUES(71, 'Yangon', 'Myanmar', 5813190);
INSERT INTO cities VALUES(72, 'Alexandria', 'Egypt', 5807050);
INSERT INTO cities VALUES(73, 'Nairobi', 'Kenya', 5766990);
INSERT INTO cities VALUES(74, 'Barcelona', 'Spain', 5733250);
INSERT INTO cities VALUES(75, 'Chittagong', 'Bangladesh', 5653490);
INSERT INTO cities VALUES(76, 'Hanoi', 'Vietnam', 5602200);
INSERT INTO cities VALUES(77, 'Saint Petersburg', 'Russia', 5597340);
INSERT INTO cities VALUES(78, 'Guadalajara', 'Mexico', 5578580);
INSERT INTO cities VALUES(79, 'Ankara', 'Turkey', 5550490);
INSERT INTO cities VALUES(80, 'Fukuoka', 'Japan', 5465920);
INSERT INTO cities VALUES(81, 'Melbourne', 'Australia', 5391890);
INSERT INTO cities VALUES(82, 'Monterrey', 'Mexico', 5272360);
INSERT INTO cities VALUES(83, 'Sydney', 'Australia', 5248790);
INSERT INTO cities VALUES(84, 'Urumqi', 'China', 5132170);
INSERT INTO cities VALUES(85, 'Changsha', 'China', 5128270);
INSERT INTO cities VALUES(86, 'Cape Town', 'South Africa', 5063580);
INSERT INTO cities VALUES(87, 'Jiddah', 'Saudi Arabia', 5021600);
INSERT INTO cities VALUES(88, 'Brasilia', 'Brazil', 4990930);
INSERT INTO cities VALUES(89, 'Kunming', 'China', 4955680);
INSERT INTO cities VALUES(90, 'Changchun', 'China', 4891020);
INSERT INTO cities VALUES(91, 'Kabul', 'Afghanistan', 4877020);
INSERT INTO cities VALUES(92, 'Yaounde', 'Cameroon', 4854260);
INSERT INTO cities VALUES(93, 'Hefei', 'China', 4830170);
INSERT INTO cities VALUES(94, 'Ningbo', 'China', 4770300);
INSERT INTO cities VALUES(95, 'Shantou', 'China', 4737590);
INSERT INTO cities VALUES(96, 'Kano', 'Nigeria', 4645320);
INSERT INTO cities VALUES(97, 'Tel Aviv', 'Israel', 4568530);
INSERT INTO cities VALUES(98, 'New Taipei', 'Taiwan', 4563850);
INSERT INTO cities VALUES(99, 'Shijiazhuang', 'China', 4534990);
INSERT INTO cities VALUES(100, 'Jaipur', 'India', 4411110);