select ASSIGNMENT, ASSIGNEE_NAME
from [dbo].[PROBSUMMARYM1] P
LEFT JOIN [dbo].[SCRELATIONM1] SC on P.NUMBER = SC.SOURCE
WHERE INF_TOWORK_TIME IS NOT NULL AND INF_TOACCEPT_TIME IS NOT NULL AND INF_TOWORK_TIME <> INF_TOACCEPT_TIME and  (IM.OPEN_TIME >=  (@StartDate) and IM.OPEN_TIME < (@EndDate + 1))
GROUP BY ASSIGNMENT, ASSIGNEE_NAME


select ASSIGNED_GROUP, ASSIGNED_TO
from [dbo].[REQUESTM1] R
LEFT JOIN [dbo].[SCRELATIONM1] SC on R.[NUMBER] = SC.[SOURCE]
WHERE INF_TOWORK_TIME IS NOT NULL and INF_TOACCEPT_TIME IS NOT NULL AND INF_TOWORK_TIME <> INF_TOACCEPT_TIME and  (IM.OPEN_TIME >=  (@StartDate) and IM.OPEN_TIME < (@EndDate + 1))
GROUP BY NUMBER,  ASSIGNED_GROUP, ASSIGNED_TO