Challenge: Find All Countries With Their IDsChallenge: Find All Countries With Their IDs

Task

Write an SQL query to get all the country name values and their id values.

Note

An ID is a unique identifier present for each field in a table.

Here's a short example of the country table:

idnamecontinentregionsurfaceareacapitalpopulation
1JapanAsiaEastern Asia377829Tokyo126714000
2LatviaEuropeNULL64589Riga2424200
3MexicoNorth AmericaCentral America1958201Mexico City98881000
.....................
15MaltaEuropeSouthern Europe316Valletta380200

Everything was clear?

Section 1. Chapter 8
toggle bottom row