dmw (3/18/2009)
...And what about the role of sales_category? The results of the query will also reflect the 'performance' of the sales_category, whatever that is.
This is the part that really bothers me. OK, so they forgot the GROUP BY, but if we are grouping by sales_category but the question asks for total sales, we haven't really satisfied the requirements have we?