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?
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.