Count the number of times a rider was not found during delivery attempts.

SELECT COUNT(*) AS total_rider_not_found_attempts
FROM order_transaction.transaction_detail_deprecated
WHERE rider_ridernotfoundtime IS NOT NULL;