Weather Observation Station 12 | SQL Basic Select | HackerRank Solution

[@sohailhussain6203]

This code is not working pls check select city from station where city NOT REGEXP '^[aeiou].*[aeiou]$';

[@nbktechworld]

Hi, what is your SQL option? MySQL? You have to split your where into two to be correct. CITY NOT REGEXP '^[aeiou]' AND CITY NOT REGEXP '[aeiou]$'

[@Aabjjjjmja]

Hi it's in MySQL And I have written your code still showing error

[@nbktechworld]

@@Aabjjjjmja What error are you getting? Send screenshot of the error message, your code.

[@sohailhussain6203]

@@nbktechworld hi its working now may be some technical glitch on that day thank you so much for replying