Renaming columns

You can SELECT a AS b to rename columns. Here, we're missing some units for the area column.

List the "name" and "area in square kilometer" for all countries

SELECT name, area as "area in square kilometer" FROM world

NEXT EXERCISE

This website only cares about the values and not the column names when checking your results.