We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Aggregation
  4. Japan Population
  5. Discussions

Japan Population

Sort by

recency

|

430 Discussions

|

  • fabricio_2310
     + 0 comments

    For MySQL

    SELECT SUM(
	CASE
		WHEN countrycode = "JPN" THEN population
		ELSE 0
	END) AS pop
FROM city;

  • vedanshchauhan
     + 0 comments

    select sum(population) from CITY where countrycode='JPN';

  • SVVBathini_w
     + 0 comments

    For MySQL Platform

    SELECT SUM(population) FROM city
WHERE countrycode = "JPN";

  • samuel2ayman
     + 0 comments
    SELECT SUM(POPULATION) FROM CITY
  WHERE COUNTRYCODE='JPN'

  • piyush_nikhade
     + 0 comments

    select sum(city.population) from city where city.COUNTRYCODE ='JPN';