Query a list of CITY and STATE from the STATION table

Query a list of CITY and STATE from the STATION table

 

THE STATION TABLE IS DESCRIBED AS FLOOW 

 

SELECT 
    CITY, STATE
FROM 
    STATION;

 

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.

 

-- MSSQL

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

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