美文网首页
SQLZOO-SELECT NAME

SQLZOO-SELECT NAME

作者: Nuwww | 来源:发表于2018-11-02 15:55 被阅读0次
1. Show the name and the population for 'Sweden', 'Norway' and 'Denmark'.

SELECT name, population FROM world

  WHERE name IN ( 'Sweden', 'Norway' ,'Denmark');

2. Find the country that start with Y

SELECT name FROM world

  WHERE name LIKE 'Y%'

3. Find the countries that end with y

SELECT name FROM world

  WHERE name LIKE '%y'

4. Find the countries that contain the letter x

SELECT name FROM world

  WHERE name LIKE '%x%'

5. Find the countries that end with land

SELECT name FROM world

  WHERE name LIKE '%land'

6. Find the countries that start with C and end with ia

SELECT name FROM world

  WHERE name LIKE 'c%ia'

7. Find the country that has oo in the name

SELECT name FROM world

  WHERE name LIKE '%oo%'

8. Find the countries that have three or more a in the name

SELECT name FROM world

  WHERE name LIKE '%a%a%a%'

9. Find the countries that have "t" as the second character.

SELECT name FROM world

WHERE name LIKE '_t%'

ORDER BY name

10 . Find the countries that have two "o" characters separated by two others

SELECT name FROM world

WHERE name LIKE '%o__o%'

11. Find the countries that have exactly four characters.

SELECT name FROM world

WHERE length(name)=4

12. Find the country where the name is the capital city.

SELECT name

  FROM world

WHERE name = capital

13. Find the country where the capital is the country plus "City"

SELECT name

  FROM world

WHERE capital = concat(name,' City');

14. Find the capital and the name where the capital includes the name of the country.

select capital, name from world where capital like concat('%',name,'%')

15. Find the capital and the name where the capital is an extension of name of the country.

You should include Mexico City as it is longer than Mexico. You should not include Luxembourg as the capital is the same as the country.


select capital, name from world where capital like concat(name,'_%') and name != capital;

16. Show the name and the extension where the capital is an extension of name of the country.

For Monaco-Ville the name is Monaco and the extension is -Ville.


select name,replace(capital,name,'') as ext from world where capital like concat(name,'_%');

相关文章

  • SQLZOO-SELECT NAME

    1. Show the name and the population for 'Sweden', 'Norwa...

  • SQLZOO-SELECT基础

    SELECT基础2 介绍 Nobel表格(诺贝尔奖得主的数据表格,数据包含:获奖者姓名、获奖年份、专业领域) WH...

  • SQLZOO-SELECT from Nobel Tutoria

    http://sqlzoo.net/wiki/SELECT_from_Nobel_Tutorial 1、selec...

  • SQLZOO-SELECT from WORLD Tutoria

    1. show the name, continent and population of all count...

  • name

    你有我有,字画集中,人见人奇怪。 春秋时期屈夫子 怒沉汩罗殉故里 如今天下大一统 举国同悼忠烈魂

  • No name

  • Name

    Me From Ricky to Rikki/Rickie/RaeRae-chee Baby Rubin zhen...

  • Name

    薄子豪

  • Name

    我其实挺喜欢我的名字,毕竟是要陪伴我的一生呢,虽然说这并不是我所定下的,但是我能够与它相遇,相伴多年不也是...

  • No name

    Killing, And kissed me.

网友评论

      本文标题:SQLZOO-SELECT NAME

      本文链接:https://www.haomeiwen.com/subject/tsdcxqtx.html