Renaming SQL Column Names

You can also have a column name returned with spaces as the column title—just add quotes:

SELECT City,

2022 estimate AS ‘Population in 2022’,

2020 estimate AS ‘Population in 2020’,

100 * (2022 estimate - 2020 estimate ) / (2020 estimate) AS ‘Percent Change Between 2020 and 2022’

FROM database_table

  • This can be easier when exporting data for other members of the team and presenting column labels in a more professional format with proper capitalization/etc