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.
Weather Observation Station 3
Weather Observation Station 3
Sort by
recency
|
1934 Discussions
|
Please Login in order to post a comment
I used ID%2=0;
If you're working on the Weather Observation Station 3 problem (like in SQL practice), focus on using the DISTINCT keyword and filtering the right column. Make sure you're only selecting unique city names from the station table — that's usually the goal.
SELECT DISTINCT CITY FROM STATION WHERE MOD(ID, 2) = 0;
select distinct city from station where id%2=0;
select distinct city from station where mod(id, 2) = 0;