use AdventureWorks2017
go
select SOD.ProductID, COUNT(SOD.ProductID) AS 'Ukupno', Round(SUM(SOD.OrderQty*SOD.UnitPrice),2) AS 'Zarada', ST.Name, SO.Description
from Production.Product as P INNER JOIN Sales.SalesOrderDetail as SOD
    ON P.ProductID = SOD.ProductID INNER JOIN Sales.SalesOrderHeader AS SOH
    ON SOD.SalesOrderID = SOH.SalesOrderID INNER JOIN Sales.SalesTerritory AS ST
    ON SOH.TerritoryID = ST.TerritoryID INNER JOIN Sales.SpecialOffer AS SO
    ON SOD.SpecialOfferID = SO.SpecialOfferID
Where SO.Description LIKE 'Volume Discount 11 to 14'
Group by SOD.ProductID, ST.Name, SO.Description
Having COUNT(SOD.ProductID) > 100
Order by Zarada Desc