ShowCode

 @@@@ 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;