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

|

415 Discussions

|

  • rahulkumarjha961
     + 0 comments

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

  • kluiz5302
     + 0 comments

    MYSQL

    SELECT SUM(POPULATION)
FROM CITY
WHERE COUNTRYCODE LIKE '%JPN%'

  • vikasvidap21
     + 0 comments

    Select Sum(Population) as Population from city where CountryCode = 'JPN';

  • CRAZIE_SUZIE
     + 0 comments

    SELECT SUM(POPULATION)

    FROM CITY

    WHERE COUNTRYCODe = 'JPN';

  • datavidai
     + 0 comments

    My solution: 

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