We use cookies to ensure you have the best browsing experience on our website. Please read our
cookie policy
for more information about how we use cookies.
Ok
HackerRank
|
Prepare
Certify
Compete
Apply
Hiring developers?
Log In
Sign Up
Prepare
SQL
Basic Select
Weather Observation Station 3
Discussions
Weather Observation Station 3
Problem
Submissions
Leaderboard
Discussions
You are viewing a single comment's thread.
Return to all comments →
Apanisile
6 years ago
+ 0 comments
The 'SELECT DISTINCT' takes care of duplicates
The 'WHERE (ID%2) = 0' makes sure that the id is even
The 'ORDER BY CITY ASC' takes care of the output being dispplayed in ascending order
Weather Observation Station 3
You are viewing a single comment's thread. Return to all comments →