"Field of aggregated query neither grouped nor aggregated"

Questions ArchiveCategory: Programming"Field of aggregated query neither grouped nor aggregated"
David Bassett asked 4 months ago

I’m currently working on the SQL Project, specifically query 7. 
I seem to have it working but it keeps giving a  “Field of aggregated query neither grouped nor aggregated” message underneath.
 
Do I need to worry about this?

1 Answers
James Gaskin answered 4 months ago

Always remember that everything in the SELECT line needs to be in the GROUP BY line, except for the aggregate attribute. So, as a hypothetical example: if you are averaging sales across locations (e.g., AVG(sales)), and you’ve also included something like product_category in the SELECT line, then the GROUP BY line must include location and product_category.

Your Answer

12 + 5 =

css.php