Nonaggregated column 'customer_category_sum.category'

Course Q&A Data Engineering Data Storage and Queries
,
1

In the Advanced SQL Queries lab > Exercise 6, I’m getting the following SQL error. It seems to be referring to the CTE which work correctly in the previous exercise.

(pymsql.err.OperationalError) (1055, "Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'customer_category_sum.category' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group by")
2

Hello @mkorangestripe
Did you use the column category in the group by statement? Please, share your answer to this exercise so that we can see where the problem is stemming from.

3

Yes, I used GROUP BY full_name and category.

(pymysql.err.OperationalError) (1055, "Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘customer_category_sum.category’ which is functionally dependent on columns in GROUP BY clause

4

@mkorangestripe please, attach your answer to the exercise.