Use the RIGHT JOIN to find all countries in the table world.country which are missing a capital! Expected result:

HINT

First figure out the order of the tables in the join.

Since it will be the RIGHT JOIN, the table world.country needs to be on the right.

So, write an INNER JOIN of the two tables world.city and world.country.

Alias the two tables, for example, as co and ci, respectively.

Use capital in world.country and id in world.city as the matching columns.

After you are sure that it works correctly, replace the INNER JOIN with the RIGHT JOIN.

Finally, add a suitable condition to filter countries which do not have a capital city.

\begin{tabular}{l|l} country_name & city_name \\ \hline Antarctica & NULL \\ Bouvet Island & NULL \\ British Indian Ocean Territory & NULL \\ South Georgia and the South Sandwich Islands & NULL \\ Heard Island and McDonald Islands & NULL \end{tabular}