You are viewing a single comment's thread. Return to all comments →
I am just trying out LIKE in this code snippet
SELECT SUM(city.population) FROM city INNER JOIN country ON city.countrycode = country.code WHERE country.continent LIKE '%sia';
Seems like cookies are disabled on this browser, please enable them to open this website
Population Census
You are viewing a single comment's thread. Return to all comments →
SELECT SUM(city.population) FROM city INNER JOIN country ON city.countrycode = country.code WHERE country.continent LIKE '%sia';