-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathcreate_population_cities_2024.sql
More file actions
110 lines (107 loc) · 6.47 KB
/
create_population_cities_2024.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_2024.sql */
/* Data about 100 Largest cities in the world (2024) */
/* Table: cities2024 */
CREATE TABLE IF NOT EXISTS cities2024 (idCity INTEGER PRIMARY KEY,
name CHAR(40),
country CHAR(40),
population INTEGER);
INSERT INTO cities VALUES(1, 'Tokyo', 'Japan', 37115000);
INSERT INTO cities VALUES(2, 'Delhi', 'India', 33807400);
INSERT INTO cities VALUES(3, 'Shanghai', 'China', 29867900);
INSERT INTO cities VALUES(4, 'Dhaka', 'Bangladesh', 23935700);
INSERT INTO cities VALUES(6, 'Sao Paulo', 'Brazil', 22806700);
INSERT INTO cities VALUES(5, 'Cairo', 'Egypt', 22623900);
INSERT INTO cities VALUES(7, 'Mexico City', 'Mexico', 22505300);
INSERT INTO cities VALUES(8, 'Beijing', 'China', 22189100);
INSERT INTO cities VALUES(9, 'Mumbai', 'India', 21673100);
INSERT INTO cities VALUES(10, 'Osaka', 'Japan', 18967500);
INSERT INTO cities VALUES(11, 'Chongqing', 'China', 17773900);
INSERT INTO cities VALUES(12, 'Karachi', 'Pakistan', 17648600);
INSERT INTO cities VALUES(13, 'Kinshasa', 'DR Congo', 17032300);
INSERT INTO cities VALUES(14, 'Lagos', 'Nigeria', 16536000);
INSERT INTO cities VALUES(15, 'Istanbul', 'Turkey', 16047400);
INSERT INTO cities VALUES(17, 'Buenos Aires', 'Argentina', 15618300);
INSERT INTO cities VALUES(16, 'Kolkata', 'India', 15570800);
INSERT INTO cities VALUES(18, 'Manila', 'Philippines', 14942000);
INSERT INTO cities VALUES(19, 'Guangzhou', 'China', 14590100);
INSERT INTO cities VALUES(21, 'Tianjin', 'China', 14470900);
INSERT INTO cities VALUES(20, 'Lahore', 'Pakistan', 14407100);
INSERT INTO cities VALUES(22, 'Bangalore', 'India', 14008300);
INSERT INTO cities VALUES(23, 'Rio de Janeiro', 'Brazil', 13824300);
INSERT INTO cities VALUES(24, 'Shenzhen', 'China', 13311900);
INSERT INTO cities VALUES(25, 'Moscow', 'Russia', 12712300);
INSERT INTO cities VALUES(26, 'Chennai', 'India', 12053700);
INSERT INTO cities VALUES(27, 'Bogota', 'Colombia', 11658200);
INSERT INTO cities VALUES(28, 'Jakarta', 'Indonesia', 11436000);
INSERT INTO cities VALUES(29, 'Lima', 'Peru', 11361900);
INSERT INTO cities VALUES(31, 'Paris', 'France', 11276700);
INSERT INTO cities VALUES(30, 'Bangkok', 'Thailand', 11233900);
INSERT INTO cities VALUES(32, 'Hyderabad', 'India', 11068900);
INSERT INTO cities VALUES(35, 'Seoul', 'South Korea', 10004800);
INSERT INTO cities VALUES(33, 'Nanjing', 'China', 9947550);
INSERT INTO cities VALUES(36, 'Chengdu', 'China', 9828110);
INSERT INTO cities VALUES(37, 'London', 'United Kingdom', 9748030);
INSERT INTO cities VALUES(34, 'Luanda', 'Angola', 9651030);
INSERT INTO cities VALUES(39, 'Tehran', 'Iran', 9616010);
INSERT INTO cities VALUES(38, 'Ho Chi Minh City', 'Vietnam', 9567660);
INSERT INTO cities VALUES(40, 'Nagoya', 'Japan', 9556880);
INSERT INTO cities VALUES(41, 'Xi-an', 'China', 9013840);
INSERT INTO cities VALUES(42, 'Ahmedabad', 'India', 8854440);
INSERT INTO cities VALUES(44, 'Wuhan', 'China', 8850850);
INSERT INTO cities VALUES(43, 'Kuala Lumpur', 'Malaysia', 8815630);
INSERT INTO cities VALUES(46, 'Hangzhou', 'China', 8419840);
INSERT INTO cities VALUES(45, 'Suzhou', 'China', 8350620);
INSERT INTO cities VALUES(47, 'Surat', 'India', 8330530);
INSERT INTO cities VALUES(48, 'Dar es Salaam', 'Tanzania', 8161230);
INSERT INTO cities VALUES(52, 'New York City', 'United States', 8097282);
INSERT INTO cities VALUES(49, 'Baghdad', 'Iraq', 7921130);
INSERT INTO cities VALUES(50, 'Shenyang', 'China', 7830380);
INSERT INTO cities VALUES(51, 'Riyadh', 'Saudi Arabia', 7820550);
INSERT INTO cities VALUES(55, 'Hong Kong', 'Hong Kong', 7725860);
INSERT INTO cities VALUES(53, 'Foshan', 'China', 7704940);
INSERT INTO cities VALUES(54, 'Dongguan', 'China', 7675150);
INSERT INTO cities VALUES(56, 'Pune', 'India', 7345850);
INSERT INTO cities VALUES(58, 'Santiago', 'Chile', 6950950);
INSERT INTO cities VALUES(57, 'Haerbin', 'China', 6938010);
INSERT INTO cities VALUES(59, 'Madrid', 'Spain', 6783240);
INSERT INTO cities VALUES(60, 'Khartoum', 'Sudan', 6542070);
INSERT INTO cities VALUES(61, 'Toronto', 'Canada', 6431430);
INSERT INTO cities VALUES(62, 'Johannesburg', 'South Africa', 6324350);
INSERT INTO cities VALUES(63, 'Belo Horizonte', 'Brazil', 6300410);
INSERT INTO cities VALUES(64, 'Dalian', 'China', 6217490);
INSERT INTO cities VALUES(66, 'Singapore', 'Singapore', 6119200);
INSERT INTO cities VALUES(65, 'Qingdao', 'China', 6104600);
INSERT INTO cities VALUES(67, 'Zhengzhou', 'China', 6014890);
INSERT INTO cities VALUES(68, 'Ji nan Shandong', 'China', 5940700);
INSERT INTO cities VALUES(69, 'Abidjan', 'Ivory Coast', 5866700);
INSERT INTO cities VALUES(74, 'Barcelona', 'Spain', 5711920);
INSERT INTO cities VALUES(71, 'Yangon', 'Myanmar', 5709680);
INSERT INTO cities VALUES(70, 'Addis Ababa', 'Ethiopia', 5703630);
INSERT INTO cities VALUES(72, 'Alexandria', 'Egypt', 5696130);
INSERT INTO cities VALUES(77, 'Saint Petersburg', 'Russia', 5581710);
INSERT INTO cities VALUES(73, 'Nairobi', 'Kenya', 5541170);
INSERT INTO cities VALUES(75, 'Chittagong', 'Bangladesh', 5513610);
INSERT INTO cities VALUES(78, 'Guadalajara', 'Mexico', 5499680);
INSERT INTO cities VALUES(80, 'Fukuoka', 'Japan', 5478080);
INSERT INTO cities VALUES(79, 'Ankara', 'Turkey', 5477090);
INSERT INTO cities VALUES(76, 'Hanoi', 'Vietnam', 5431800);
INSERT INTO cities VALUES(81, 'Melbourne', 'Australia', 5315600);
INSERT INTO cities VALUES(82, 'Monterrey', 'Mexico', 5195360);
INSERT INTO cities VALUES(83, 'Sydney', 'Australia', 5184900);
INSERT INTO cities VALUES(85, 'Changsha', 'China', 5027980);
INSERT INTO cities VALUES(84, 'Urumqi', 'China', 5005960);
INSERT INTO cities VALUES(86, 'Cape Town', 'South Africa', 4977830);
INSERT INTO cities VALUES(87, 'Jiddah', 'Saudi Arabia', 4943210);
INSERT INTO cities VALUES(88, 'Brasilia', 'Brazil', 4935270);
INSERT INTO cities VALUES(89, 'Kunming', 'China', 4861080);
INSERT INTO cities VALUES(90, 'Changchun', 'China', 4802450);
INSERT INTO cities VALUES(91, 'Kabul', 'Afghanistan', 4728380);
INSERT INTO cities VALUES(93, 'Hefei', 'China', 4727290);
INSERT INTO cities VALUES(92, 'Yaounde', 'Cameroon', 4681770);
INSERT INTO cities VALUES(94, 'Ningbo', 'China', 4659830);
INSERT INTO cities VALUES(95, 'Shantou', 'China', 4656520);
INSERT INTO cities VALUES(98, 'New Taipei', 'Taiwan', 4534880);
INSERT INTO cities VALUES(97, 'Tel Aviv', 'Israel', 4495730);
INSERT INTO cities VALUES(96, 'Kano', 'Nigeria', 4490730);
INSERT INTO cities VALUES(99, 'Shijiazhuang', 'China', 4454130);
INSERT INTO cities VALUES(103, 'Montreal', 'Canada', 4341640);