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
|
SELECT name, continent, population FROM world;
SELECT name FROM world WHERE population >= 200000000;
select name, gdp/population from world where population >= 200000000;
select name, population from world where name in ('France', 'Germany', 'Italy');
select name from world where name like '%United%';
select name, population, area from world where area > 3000000 or population > 250000000;
select name, population, area from world where area > 3000000 xor population > 250000000;
select name, round(population / 1000000, 2), round(gdp/ 1000000000, 2) from world where continent = 'South America';
select name, round(gdp / population, -3) from world where gdp >= 1000000000000;
SELECT name, capital FROM world WHERE length(name) = length(capital);
SELECT name, capital FROM world where (left(name,1) = left(capital,1)) and (name <> capital);
SELECT name FROM world WHERE name LIKE '%a%' AND name LIKE '%e%' AND name LIKE '%i%' AND name LIKE '%o%' AND name LIKE '%u%' AND name NOT LIKE '% %'
|
近期评论