select ownerId, ownertype, useriD, min( reportDate ), max( reportDate ), count(*) xx from tbl_SYS_UserReportRequests urr where deleted = 'Y' and datediff( day, reportDate, getDate() ) > 30 and exists( select * from tbl_SYS_SavedReports sr where sr.savedReportId = urr.savedReportId ) GROUP BY ownerId, ownerType, USERiD ORDER BY COUNT(*) DESC