select a.EmpId as 'EmpId',sum(d.DiscountAmount*0.01) as 'Payout'from TaskEmployees a inner join OrderTask b on a.TaskId = b.Id inner join [Order] d on a.OrderId=d.Id inner join dbo.Employee e on a.EmpId=e.Id inner join OrderStepSet c on b.StepCode=c.Code group by a.EmpId...
