No Group By Function

From SQLZoo
Jump to navigation Jump to search
schema:gisq

Problem

Usually we must have a GROUP BY clause if in aggregate function (such as SUM or COUNT) is used.

The exception is when only aggregate functions are used on the SELECT clause. If we mix aggregate and non-aggregate values then there must be a GROUP BY clause.

Solutions

  • Remove the offending field from the SELECT line
  • Add the field to the GROUP BY clause
  • Aggregate the offending field
SELECT name, MAX(population)
  FROM bbc
DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects