June 23, 2017 Asian Population | SQL Given the CITY and COUNTRY tables, query the sum of the populations of all cities where the CONTINENT is 'Asia'. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. Input Format The CITY and COUNTRY tables are described as follows: Query: select sum(City.POPULATION) from Country INNER JOIN CITY ON City.CountryCode=Country.Code where Continent='Asia'; Share this:Click to share on Twitter (Opens in new window)Click to share on Facebook (Opens in new window)Click to share on Google+ (Opens in new window)MoreClick to share on LinkedIn (Opens in new window)Click to share on WhatsApp (Opens in new window)Click to email this to a friend (Opens in new window)Click to print (Opens in new window)Like this:Like Loading... Related Related Posts Collatz Sequence Sum Day 4: Class vs. Instance SQL – Select all 4th Year Students from IT department About The Author admin Add a Comment Cancel reply Your email address will not be published. Required fields are marked *Comment:*Name:* Email Address:* Website: Notify me of follow-up comments by email. Notify me of new posts by email.