search

RodneyShag / HackerRank_solutions

317 efficient solutions to HackerRank problems
MIT License
2.69k stars 1.44k forks source link

Solution of Weather Observation Station 8 seems wrong #17

Closed Soundug closed 5 years ago

Soundug commented 5 years ago

Hi @RodneyShag,

The solution for Weather Observation Station 8 in SQL is wrong. It wasn't printing anything on the output when I checked while solving the challenge on Hackerrank.

SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '^[aeiou].*[aeiou]$';

This worked for me.