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
|
364 Discussions
|
Please Login in order to post a comment
Using MySQL:
SELECT SUM(POPULATION) FROM CITY WHERE COUNTRYCODE = "JPN";
MySQL select sum(population) from city where countrycode ='JPN';
select round(avg(population),0) from city
For MySQL
SELECT SUM(Population) FROM City WHERE Countrycode like "JPN";