Question: explain this again 1) Compute the category averages once and inspect Build a CTE/derived table of the averages and row counts by category to see
explain this again 1) Compute the category averages once and inspect Build a CTE/derived table of the averages and row counts by category to see what the comparison baseline should be. WITH cat_avg AS ( SELECT category_id, AVG(list_price) AS avg_price, COUNT() AS n_in_cat FROM products GROUP BY category_id ) SELECT FROM cat_avg ORDER BY category_id
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
