SELECT Row_number()
     OVER (
       partition BY createddate
       ORDER BY Count(loggedrecid)) AS Col_group,
   Count(loggedrecid),
   createddate,
   ownerteam
FROM   @allrequests
WHERE  faculty IN ( @faculty )
GROUP  BY createddate,
      ownerteam
ORDER  BY createddate ASC