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.
- Prepare
- SQL
- Aggregation
- Japan Population
- Discussions
Japan Population
Japan Population
Sort by
recency
|
400 Discussions
|
Please Login in order to post a comment
SELECT SUM(C.POPULATION) AS SUM_POP FROM CITY C WHERE C.COUNTRYCODE = 'JPN';
mysql:
SELECT SUM(POPULATION) AS JPN_POPULATIONS FROM CITY WHERE UPPER(COUNTRYCODE)='JPN';