Column name

From SQLZoo
Jump to navigation Jump to search

How can I display a column name for an aggregate function?


Where one of the results returned is calculated (for example with an aggregate) the column name may be assigned arbitrarily.

You should be able to specify a column name.

SELECT region, SUM(population) AS x
  FROM bbc
GROUP BY region
DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects