select transactionDate, scriptName, cleanQueryString, requestTimeMs from fslogging..tbl_STP_Activity a with (nolock) where cleanQueryString is not null and scriptName = '/apps/RPT/index.cfm' and cleanQueryString = 'ajax=userReportRequests&maxRows=' and transactionDate > '04/17/2019' order by transactionDate desc select avg( requestTimeMs ) oneHourAverage, count(*) oneHourInstances from qmd_data where transactionDate between and