Consider the World database that contains the City, Country and CountryLanguage

tables:

City $($id $->$ name, countrycode, district, population, $...)$

Country $($code $->$ name, continent, region, surfaceArea, totalPopulation, $...)$

Countrylanguage $($countrycode$,$ language $->$ isOfficial, percentage, $...)$

Consider a SQL query that lists all countries on the African continent, including the name

of the country, its surface area, and the total population of its cities, with the results sorted

by surface area in descending order.

Explain how you would obtain the execution plan for this query, presented above, describe

the execution plan and the result analysis and draw the execution plan tree.$|$