Decimals and rounding

When you do a division here, the output is automatically rounded down, that's because we are diving two integers. To avoid this, add a floating point number (for example 1.0) to the mix. You may want to round results a bit though, the ROUND function can remove decimals to make the output look cleaner.

Show the name and population in millions (with 2 decimals, named "pop") for the countries of the continent 'South America'.

SELECT name, ROUND( population / 1000000.0, 2) as pop FROM world