Compute video-call SQL metrics with edge cases

Part A: Initiators with more than 3 distinct callees For the sample data, this returns: Part B: Percent of French DAUs on a video call yesterday For the sample data, this returns: numerator denominator percentage_oncall_fr 0 3 0.00 Edge-case handling Duplicate participant rows / reconnects in the same call: Part A uses COUNT(DISTINCT callee_user_id). Part B first collapses rows to (call_id, user_id) with GROUP BY cp.call_id, cp.user_id, then selects distinct users. Failed…