SELECT 
PD.[Date],
PD.[Employee Name],
PD.Position,
PD.Department,
PD.Shift,
MINT.BusinessUnit,
case when isnull(MINT.CVQI_a,0) = 0 then 0
else MINT.CVQI_p/MINT.CVQI_a end as CVQI,
case when ISNULL(MINT.FG_p,0) = 0 then 0
else (MINT.FG_a/MINT.FG_p)end as Prod,
case when ISNULL(MINT.RJT_a, 0) = 0 then 0
else (MINT.RJT_p/RJT_a) end as Rej,
case when isnull(MINT.stop_a,0) = 0  or isnull(MINT.stop_a,0) = 0 then 0
else ((MINT.stop_p/stop_a)/FG_a) end as [Stop],
case when isnull(MINT.CVQI_a,0) = 0 or ISNULL(MINT.FG_p,0) = 0 or ISNULL(MINT.RJT_a, 0) = 0 or isnull(MINT.stop_a,0) = 0 then 0
else (((MINT.CVQI_p/CVQI_a) + (MINT.FG_a/MINT.FG_p) + (MINT.RJT_p/RJT_a) + ((MINT.stop_p/stop_a)/FG_a))/3) end as Koef
--MINT.FG_a,
--MINT.FG_p,
--MINT.CVQI_a,
--MINT.CVQI_p,
--MINT.RJT_a,
--MINT.RJT_p
 FROM
(
(SELECT
EMP.[FirstNameEn] + ' ' + EMP.LastNameEn as [Employee Name],
EMP.POSITION_NAME_EN as Position,
DEP.Alias as Department,
RD.ShiftScheduleID,
SS.[Date],
SS.[Shift],
[Key] = 'MA'+substring(RD.[MachineID],3,2)+'PA'+substring(RD.[MachineID],3,2)+ CONVERT ( varchar, SS.[Date], 5 )+ SS.[Shift]
FROM
dbo.tblRawData as RD
INNER JOIN
dbo.tblEmployee as EMP ON EMP.[EmployeeID]=RD.[EmployeeID]
INNER JOIN [dbo].[tblShiftSchedule] as SS
ON RD.[ShiftScheduleID] = SS.[ShiftScheduleID]
LEFT JOIN
dbo.tblDepartment AS DEP 
ON DEP.DepartmentID = EMP.DEPARTMENT_ID 
  ) AS PD
  INNER JOIN
  mint_to_pdp as MINT
  ON  MINT.pdpkey=PD.[Key] AND PD.[Date] BETWEEN @StartDate and @EndDate
  AND MINT.BusinessUnit = @BU
  AND Position = @Position
  AND Shift =@Shift
  AND MINT.WorkCenterName = @WorkCenter)
  order by Koef