USE OLAP
--Total for each year
SELECT year,month,total_sales
       ,sum(total_sales) over(partition by year) as yearly_total
	   ,total_sales/(sum(total_sales) over(partition by year))*100 as percentage_of_year
FROM sales_by_year_and_month
ORDER BY year,month