Weather Observation Station 3

Question Link

Query a list of CITY names from STATION for cities that have an even ID number. Print the results in any order, but exclude duplicates from the answer.

where LAT_N is the northern latitude and LONG_W is the western longitude.

SELECT DISTINCT city 
FROM Station 
WHERE id % 2 = 0 
ORDER BY city;

Last updated