@@@@

• Submissions
• Leaderboard
• Discussions

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.

== SELECT DISTINCT CITY FROM STATION 

     WHERE MOD(ID,2)=0;

Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table.

=SELECT COUNT(*) - COUNT(DISTINCT CITY) AS DIFFERENCE FROM STATION;