select distinct  p.Name "nazwa", year(OrderDate) "rok",
	sum(soh.SubTotal) over(partition by p.Name, year(OrderDate)) "suma",
	sum(SubTotal) over(partition by p.Name, year(OrderDate)) / sum(SubTotal) over()*100 "udział %"
from Sales.SalesOrderHeader soh
	join Sales.SalesOrderDetail sod on
	soh.SalesOrderID = sod.SalesOrderID
	join Sales.SpecialOfferProduct sop on
	sod.SpecialOfferID = sop.SpecialOfferID
	join Production.Product p on
	sop.ProductID = p.ProductID
	join Production.ProductSubcategory ps on
	p.ProductSubcategoryID = ps.ProductSubcategoryID
	join Production.ProductCategory pc on
	ps.ProductCategoryID = pc.ProductCategoryID
where pc.Name = 'Bikes'