SELECT o.Name AS [Library], COUNT(*) AS [Items Withdrawn]
FROM Polaris.Polaris.CircItemRecords AS [cir] WITH (NOLOCK)
INNER JOIN Polaris.Polaris.Organizations AS [o] WITH (NOLOCK)
ON cir.AssignedBranchID = o.OrganizationID
WHERE cir.ItemStatusID = '11'
AND cir.ItemStatusDate BETWEEN @StartDate AND DATEADD(day,1,@EndDate)
GROUP BY o.Name
ORDER BY o.Name