query to fix

DEMO - fix

SELECT
  i_item_id,
  AVG(ss_quantity) AS agg1,
  AVG(ss_list_price) AS agg2,
  AVG(ss_coupon_amt) AS agg3,
  AVG(ss_sales_price AS agg4
FROM
  stor_sales
  JOIN customer_demographics ON ss_cdemo_sk = cd_demo_sk
  JOIN date_dim ON ss_sold_date_sk = d_date_sk
  JOIN item ON ss_item_sk = i_item_sk
  JOIN promotion ON ss_promo_sk = p_promo_sk
WHERE
  cd_gender = 'F'
  AND cd_marital_status = 'W'
  AND cd_education_status = 'College'
  AND (
    p_channel_email = 'N'
    OR p_channel_event = 'N'
  )
  AND d_year = 2001
GROUPBY
  i_item_id
ORDER BY
  i_item_id
LIMITS 10;