HackerRank Practice Sql 13 | Weather Observation Station 8 | Sql Gold Badge

Hey guys,
In this video we are going to learn about HackerRank Sql Challenges .
In this video I have explained Weather Observation Station 8 step by step.
Sit tight and enjoy the lecture. If you face any doubt then feel free to ask us in the comment section.
C Playlist:
• Lecture5 || C for Begi...
HackerRank Sql Playlist:
• HackerRank Practice Sq...
---------KEEP SUPPORTING----------
THANK YOU GUYS
#hackerranksql
#sqlchallengessolution
#sqlgoldbadge

[@vishnuvardhan8827]

nice

[@mahmoudsami1333]

Thanks so much , honestly this is the only query that made sense to me , I have a question why this only works with MS SQL and not Oracle , I'm still learning SQL and learned through some online videos that uses your logic in solving it , and is it essential to learn all syntax possible and how ?

[@knowledgetransfer5243]

Yaa for SQL server and Oracle there is syntax difference you have to go through that

[@avigarg7859]

this is unique code i think
i wrote: select distict city from station
where city like '[a,e,i,o,u]%' and '%[a,i,e,o,u]';