You are viewing a single comment's thread. Return to all comments →
In this, we have to query a list of CITY names from STATION for cities that have an even ID number.
SELECT DISTINCT CITY FROM STATION WHERE ID % 2 = 0;
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 3
You are viewing a single comment's thread. Return to all comments →
In this, we have to query a list of CITY names from STATION for cities that have an even ID number.
SELECT DISTINCT CITY FROM STATION WHERE ID % 2 = 0;