1-SELECT-name.md

Questions Index

• Ques 1

• Ques 2

• Ques 3

• Ques 4

• Ques 5

• Ques 6

• Ques 7

• Ques 8

• Ques 9

• Ques 10

• Ques 11

• Ques 12

• Ques 13

• Ques 14

• Ques 15

Ques 1. Find the country that start with Y

SELECT name FROM world
WHERE name LIKE 'Y%'

Ques 2. Find the countries that end with y

SELECT name FROM world
WHERE name LIKE '%y'

Ques 3. Find the countries that contain the letter x

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

Ques 4. Find the countries that end with land

SELECT name FROM world
WHERE name LIKE '%land'

Ques 5. Find the countries that start with C and end with ia

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

Ques 6. Find the country that has oo in the name

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

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

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

Ques 8. Find the countries that have "t" as the second character

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

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

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

Ques 10. Find the countries that have exactly four characters

SELECT name FROM world
WHERE name LIKE '____'

Ques 11. Find the country where the name is the capital city

SELECT name
FROM world
WHERE name = capital

Ques 12. Find the country where the capital is the country plus "City"

SELECT name
FROM world
WHERE capital LIKE '%City'

Ques 13. 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, '%')

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

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

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

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