HackerRank Practice Sql 08 | weather observation station 3 | Sql Gold Badge |

Hyy friends
In this video i have explained Sql challenge weather observation station 03 step by step
If you guys have any doubt then please comment on this video
C Playlists👇
• Lecture 7 || C for Beg...
Hackerrank practice sql playlist👇
• HackerRank Practice SQ...
C Programme playlist👇
• C for Beginners || Swa...
keep supporting
THANK YOU

[@inderpanda]

Thanks a lot for uploading all solution

[@inderpanda]

SELECT DISTINCT (city) FROM station
WHERE ID%2=0;

[@bhavanasaraswat7808]

select distinct CITY
from STATION
where id % 2=0;
why showing error

[@knowledgetransfer5243]

enclose city in paranthesis after distinct

[@inderpanda]

SELECT DISTINCT (city) FROM station
WHERE ID%2=0;

[@kiranprasad1276]

solution for ms sql server

[@knowledgetransfer5243]

same query will work