Write an SQL query to retrieve the id,name, population, and continent from the country table (please retrieve these columns in this order), returning only rows with the 'North America' continent, and displaying the result in descending order by population.

Note that north america is not the same as North America. Be careful and write correctly: North America.

Here's a short example of the country table:

1JapanAsiaEastern Asia377829Tokyo126714000
3MexicoNorth AmericaCentral America1958201Mexico City98881000
15MaltaEuropeSouthern Europe316Valletta380200

Everything was clear?

Section 3. Chapter 2
toggle bottom row