HackerRank MySQL - Weather Observation Station 3


Query a list of CITY names from STATION with even ID numbers only. You may print the results in any order, but must exclude duplicates from your answer.

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

download android app