Computing new columns

The select can compute new columns base on what's already in the table. Here for example we're computing the population density. You can add an "as" command to rename the resulting column, here we're calling it population_density.

Give the name and the per capita GDP (name it gdp_per_capita) of all countries with a population of at least 200 million.

SELECT name, population/area as population_density FROM world