Samantha was tasked with calculating the average monthly salaries for all employees in the EMPLOYEES table, but did not realize her keyboard's 0 key was broken until after completing the calculation. She wants your help finding the difference between her miscalculation (using salaries with any zeros removed), and the actual average salary.Write a query calculating the amount of error (i.e.:  ave..

Query the difference between the maximum and minimum populations in CITY.Input FormatThe CITY table is described as follows: SELECT MAX(POPULATION) - MIN(POPULATION)FROM CITY

Query the sum of the populations for all Japanese cities in CITY. The COUNTRYCODE for Japan is JPN.Input FormatThe CITY table is described as follows: SELECT SUM(POPULATION)FROM CITYWHERE COUNTRYCODE='JPN'

Query the average population for all cities in CITY, rounded down to the nearest integer.Input FormatThe CITY table is described as follows: SELECT ROUND(AVG(POPULATION), 0)FROM CITY

Query the average population of all cities in CITY where District is California.Input FormatThe CITY table is described as follows:  SELECT AVG(POPULATION)FROM CITYWHERE DISTRICT = 'California'

Query the total population of all cities in CITY where District is California.Input FormatThe CITY table is described as follows:  SELECT SUM(POPULATION)FROM CITYWHERE DISTRICT = 'California'