I am very new to SQL Queries. Recently I have joined new team and I am given below task
“Find the country that has all the vowels and no spaces in its name?”
I have written below query
WHERE country LIKE '%u'
and country LIKE '%a'
and country LIKE '%o'
and country LIKE '%i'
and country LIKE '%e'
and country NOT LIKE '% %'
But it is not giving expected answer which is "Mozambique"
I tried to do hard coding and it is like "where name like 'Moz' and it worked for me but can’t use it.
I have spent a lot of time in writing the correct query but still unable to do it. So I am looking for sql experts help in fixing my above query.