-
Notifications
You must be signed in to change notification settings - Fork 0
/
1_Select_Name.sql
47 lines (36 loc) · 1.16 KB
/
1_Select_Name.sql
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
-- SELECT names
-- 1) Find the country that start with Y
SELECT name FROM world
WHERE name LIKE 'Y%'
-- 2) Find the countries that end with y
SELECT name FROM world
WHERE name LIKE '%y'
-- 3) Find the countries that contain the letter x
SELECT name FROM world
WHERE name LIKE '%x%'
-- 4) Find the countries that end with land
SELECT name FROM world
WHERE name LIKE '%land'
-- 5) Find the countries that start with C and end with ia
SELECT name FROM world
WHERE name LIKE 'C%ia'
-- 6) Find the country that has oo in the name
SELECT name FROM world
WHERE name LIKE '%oo%'
-- 7) Find the countries that have three or more a in the name
SELECT name FROM world
WHERE name LIKE '%a%a%a%'
-- 8) Find the countries that have "t" as the second character.
SELECT name FROM world
WHERE name LIKE '_t%'
ORDER BY name
-- 9) Find the countries that have two "o" characters separated by two others.
SELECT name FROM world
WHERE name LIKE '%o__o%'
-- 10) Find the countries that have exactly four characters.
SELECT name FROM world
WHERE name LIKE '____'
-- 11) Find the country where the name is the capital city.
SELECT capital
FROM world
WHERE name LIKE capital