Decimals and rounding

When you do a division of integers, the output is automatically rounded. To avoid this, add a .0 at the end of one of the numbers. 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(gdp/1000000000.0, 2) as gdp FROM world