Weather Observation Station 3

Sort by

recency

|

1934 Discussions

|

  • + 1 comment

    I used ID%2=0;

  • + 0 comments

    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.

  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE MOD(ID, 2) = 0;

  • + 0 comments

    select distinct city from station where id%2=0;

  • + 0 comments

    select distinct city from station where mod(id, 2) = 0;