Get count of same id with multiple status

Given rules_pass_status table

Expected output

• request_id is foreign key of request_list table.
• In expected output 'Total request count' is unique count of request_id containing the type

any ideas? Thanks