HomePagev2 Forums SQL Discussions sql assignment1 Reply To: sql assignment1

  • Karri Bindu Madhavi

    Member
    April 21, 2021 at 2:29 pm

    Hello everyone,

    In sql practice1,i found this question

    “Find the country that has all the vowels and no spaces in its name?”

    and i wrote a query like this

    “””

    select name from country

    where name like ‘%a%’ and

    name like ‘%e%’ and

    name like ‘%i%’ and

    name like ‘%o%’ and

    name like ‘%u%’ and

    name not like ‘% %’

    “””

    the correct output is the “mozambique”,which is a country name include all vowels and no spaces in it ,but after executing the above query it doesn’t give any output

    can anyone help with this query?

    Thank you