Basic SQL Topics
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