Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.
The CITY table is described as follows:
SELECT *
FROM CITY
WHERE COUNTRYCODE = 'JPN';Weather Observation Station 4
Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the…