This doesn't make any sense. Your original query retrieves "misses" by selecting from FIND_CONCURRENT_REQUESTS. But you say also want to get total records from the same table. If they are both coming from the same table, then ther must be something like a type which distinguishes between a missed record and a successful record. Or is it the fact that there is a match in the sla_request_data which determines that something "missed" ?