1. SELECT name

1. SELECT name FROM world
     WHERE name LIKE 'Y%'
   

2.

SELECT name FROM world
  WHERE name LIKE '%y'

3.

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

4.

SELECT name FROM world
  WHERE name LIKE '%land'

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

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

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

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

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

6. SELECT name FROM world
    WHERE name LIKE '____'
   

7. SELECT name
     FROM world
    WHERE name = capital
   

8. SELECT name
     FROM world
    WHERE capital = concat(name, ' City')
   

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

10. SELECT
      capital, name
    FROM
      world
    WHERE
      capital LIKE concat('%', name, '%')
      AND capital != name
    

11. SELECT
      name,  REPLACE(capital,name,'')
    FROM
      world
    WHERE
      capital LIKE concat(name, '%')
      AND capital != name