SELECT 
          e.employeeId, 
          e.firstname, 
          e.lastname, 
          od.productId, 
          SUM(od.quantity*od.unitprice)-SUM(od.quantity*od.unitprice*od.discount) AS toplamsatis
 
FROM products AS p INNER JOIN ((employees AS e 
                                 INNER JOIN orders AS o ON e.employeeId = o.employeeId) 
                                 INNER JOIN [ORDER details] AS od ON o.orderId = od.orderId) ON p.productId = od.productId
 
GROUP BY e.employeeId, e.firstname, e.lastname, od.productId
 
HAVING (((SUM([od].[quantity]*[od].[unitprice])-SUM([od].[quantity]*[od].[unitprice]*[od].[discount])) 
             IN (
                    SELECT top 1 (toplamsatis) 
                    FROM (
                          SELECT o.employeeId, od.productId, 
                             SUM([od].[quantity]*[od].[unitprice])-
                             SUM([od].[quantity]*[od].[unitprice]*
                                     [od].[discount]) AS toplamsatis
                           FROM products AS p INNER JOIN (orders AS o 
                           INNER JOIN [ORDER details] AS od 
                           ON o.orderId = od.orderId) 
                           ON p.productId = od.productId
                           GROUP BY o.employeeId, od.productId
                           ORDER BY SUM([od].[quantity]*[od].[unitprice])-
                                          SUM([od].[quantity]*[od].[unitprice]*[od].[discount])  DESC
 
 
) AS trz WHERE e.employeeId=trz.employeeId
 
 )))
ORDER BY e.employeeId, SUM(od.quantity*od.unitprice)-SUM(od.quantity*od.unitprice*od.discount) DESC