Leetcode 2238. Number of Times a Driver Was a Passenger

Given a list/table of rides with driver_id and passenger_id, compute for each person who has driven how many times they appear as a passenger by counting passenger entries for IDs that also occur as drivers; the task is essentially set membership plus grouping/counting at scale.