--CREATE OR REPLACE VIEW cv7_cum_sum(channel_desc, calendar_month_name, calendar_year, amount_sold, cum_sum) AS
SELECT
  channel_desc,
  calendar_month_name,
  calendar_year,
  amount_sold,
  SUM(amount_sold) OVER (PARTITION BY channel_desc, calendar_year ORDER BY     to_date(calendar_month_name, 'mm', 'NLS_DATE_LANGUAGE=ENGLISH')   ) AS cum_sum
FROM(
SELECT
  channel_desc,
  calendar_month_name,
   calendar_year ,
  SUM(amount_sold) AS amount_sold
FROM
  sh.sales JOIN sh.customers USING(cust_id)
  JOIN sh.countries USING(country_id)
  JOIN sh.times USING(time_id)
  JOIN sh.channels USING(channel_id)
  JOIN sh.promotions USING(promo_id)
  JOIN sh.products USING(prod_id)
WHERE
  TIME_ID  BETWEEN '01.01.2000' AND '31.12.2001'
  GROUP BY channel_desc, calendar_month_name, calendar_year
  )
 ORDER BY calendar_year;