<s>[INST] Write a SQL code to count the number of times a rider was not found during delivery attempts.  [/INST] SELECT COUNT(*) AS total_rider_not_found_attempts FROM order_transaction.transaction_detail_deprecated WHERE rider_ridernotfoundtime IS NOT NULL; </s>