select r.rank, r.releaseName, r.requestType, r.trackingId, r.description, m.lastName as assignedTo, m2.lastName requestedBy, ceiling( sum( tl.scrumTimeUpdateHour )) hours, count( distinct r.requestId ) scrums from tbl_SCRUM_TimeLog tl inner join tbl_SCRUM_Requests r on r.requestId = tl.requestId inner join tbl_Fspro_members m on m.fspro_userid = tl.scrumTimeUpdateUserId inner join tbl_fspro_members m2 on m2.fspro_userId = r.requestor where 1 = 1 and r.releaseName = and r.description <> 'Sales Team Portal DNS and IIS Bindings Setup' group by r.rank, r.releaseName, r.requestType, r.trackingId, r.description, m.lastName, m2.lastName select distinct assignedTo from qmd_scrumStats order by assignedTo select distinct requestedBy from qmd_scrumStats order by requestedBy select r.rank, count( distinct r.requestId ) as scrums from tbl_SCRUM_TimeLog tl inner join tbl_SCRUM_Requests r on r.requestId = tl.requestId inner join tbl_Fspro_members m on m.fspro_userid = tl.scrumTimeUpdateUserId inner join tbl_fspro_members m2 on m2.fspro_userId = r.requestor where r.releaseName = and r.description <> 'Sales Team Portal DNS and IIS Bindings Setup' group by r.rank order by r.rank select rank, releaseName as Release, trackingId SCRUM, Description, requestedBy Requestor, sum( hours ) as Hours, assignedTo Developer from qmd_scrumStats where 1 = 1 and requestedBy = and assignedTo = group by rank, releaseName, trackingId, description, requestedBy, assignedTo order by rank, hours desc select Requestor, sum( hours) as Hours, count( distinct SCRUM ) as SCRUMs from qmd_filtered group by Requestor order by Requestor select r.rank, count( distinct r.requestId ) as scrums from tbl_SCRUM_TimeLog tl inner join tbl_SCRUM_Requests r on r.requestId = tl.requestId inner join tbl_Fspro_members m on m.fspro_userid = tl.scrumTimeUpdateUserId inner join tbl_fspro_members m2 on m2.fspro_userId = r.requestor where r.releaseName = and r.dateCreated > dateadd( month, -1, ) and r.description <> 'Sales Team Portal DNS and IIS Bindings Setup' group by r.rank order by r.rank select Developer, sum( hours) as Hours, count( distinct SCRUM ) as SCRUMs from qmd_filtered group by Developer order by Developer