mysql_1

SELECT population FROM  world  WHERE name = 'Germany'

Correct answer

population
83149300

 SELECT name, gdp/population FROM world  WHERE area > 5000000

Correct answer

name	gdp/population
Australia	54833.5437
Brazil	9721.37
Canada	43337.0907
China	8724.3064
Russia	10431.3536
United States	59121.1921

SELECT name, population FROM world  WHERE name IN ('Ireland', 'Iceland', 'Denmark'); 

Correct answer

name	population
Denmark	5822763
Iceland	364260
Ireland	4921500

SELECT name, area FROM world  WHERE area BETWEEN 200000 AND 250000 

Correct answer

name	area
Belarus	207600
Ghana	238533
Guinea	245857
Guyana	214969
Laos	236800
Romania	238391
Uganda	241550
United Kingdom	242900

SELECT name FROM world  WHERE name LIKE 'F%' 

Correct answer

name
Fiji
Finland
France

SELECT name FROM world  WHERE name LIKE '%x%' 

Correct answer

name
Luxembourg
Mexico

SELECT name FROM world  WHERE name LIKE '%land' 

Correct answer

name
Thailand
Finland
Iceland
Ireland
Poland
Switzerland
New Zealand

SELECT name FROM world  WHERE name LIKE 'C%ia'

Correct answer

name
Cambodia
Colombia
Croatia

 SELECT name FROM world
 WHERE name LIKE '_t%'
ORDER BY name

Correct answer

name
Ethiopia
Italy

 SELECT name FROM world
 WHERE name LIKE '____'

Correct answer

name
Chad
Mali
Togo
Iran
Iraq
Laos
Oman
Cuba
Fiji
Peru

SELECT name, capital
  FROM world
 WHERE name=capital

Correct answer

name	capital
Djibouti	Djibouti
Luxembourg	Luxembourg
San Marino	San Marino
Singapore	Singapore

SELECT name
  FROM world
WHERE capital LIKE concat(name,' City')#LIKE换成=也可以

Correct answer

name
Guatemala
Kuwait
Mexico
Panama

SELECT capital,name
  FROM world
WHERE capital LIKE concat('%',name,'%')

Correct answer

capital	name
Andorra la Vella	Andorra
Djibouti	Djibouti
Guatemala City	Guatemala
Kuwait City	Kuwait
Luxembourg	Luxembourg
Mexico City	Mexico
Monaco-Ville	Monaco
Panama City	Panama
San Marino	San Marino
Singapore	Singapore

 SELECT name,capital
  FROM world
WHERE capital LIKE concat(name,'_%')

Correct answer

name	capital
Andorra	Andorra la Vella
Guatemala	Guatemala City
Kuwait	Kuwait City
Mexico	Mexico City
Monaco	Monaco-Ville
Panama	Panama City

 SELECT name,REPLACE(capital,name,'') as ext
  FROM world
WHERE capital LIKE concat(name,'_%')

Correct answer

name	ext
Andorra	la Vella
Guatemala	City
Kuwait	City
Mexico	City
Monaco	-Ville
Panama	City

https://sqlzoo.net/wiki/SELECT_names/zh