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

|

394 Discussions

|

  • mayank9450612583
     + 0 comments

    SELECT SUM (POPULATION) FROM CITY WHERE COUNTRYCODE = 'JPN';

  • SVVBathini
     + 0 comments

    For MySQL

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

  • ousainouj
     + 0 comments

    For MySQL:

    SELECT SUM(POPULATION) FROM CITY WHERE COUNTRYCODE = 'JPN';

  • debjyoti_ghosh
     + 0 comments
    select 
    sum(population)
from
    CITY
where
    COUNTRYCODE = 'JPN';

  • contact_bhavukc1
     + 0 comments

    SELECT SUM(POPULATION) FROM CITY WHERE COUNTRYCODE = 'JPN'

    The SELECT function is used to select the population FROM city table. SUM function adds up the population. WHERE clause is used to filter the countrycode for Japan.