leetcode

0 SELECT S.user_id,

1 ROUND(AVG(if(C.action="confirmed", 1, 0)), 2) AS confirmation_rate

2 FROM Signups AS S

3 LEFT JOIN Confirmations AS C

4 ON S.user_id = C.user_id

5 GROUP BY user_id;