Weather Observation Station 3

Sort by

recency

|

1973 Discussions

|

  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE ID%2=0 ORDER BY CITY;

  • + 0 comments

    SELECT DISTINCT city FROM station WHERE RIGHT(id,1) not in (1,3,5,7,9)

  • + 0 comments

    SELECT CITY FROM STATION WHERE ID%2=0 GROUP BY CITY;

  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE ID%2=0;

    Test cases here are for the DISTINCT keyword only and not ORDER BY

  • + 0 comments

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