hey, i need help with this
i have table world(name, continent, capital) and i dont know how to do this :
- Find the country where the capital is the country plus "City".
- Find the countries that have two "o" characters separated by two others.
- Find the countries that have three or more a in the name.
- Find the capital and the name where the capital is an extension of name of the country.
Thanks a lot