Skip to content
Advertisement

Tag: inner-join

Inner join and average in SQL

I’m new to SQL thus the question. I’m trying to query the following. Given the CITY and COUNTRY tables, query the names of all the continents (COUNTRY.Continent) and their respective average city populations (CITY.Population) rounded down to the nearest integer. The table schemas are City: id, name, countryside, population I’ve written the inner join, but can’t seem to figure out

Advertisement