1934. 确认率
题目链接:1934. 确认率
代码如下:
# Write your MySQL query statement below
select a.user_id,
round(count(if(b.action='confirmed',1,null))/count(*),2) as confirmation_rate
from Signups as a left join Confirmations as b
on a.user_id=b.user_id
group by a.user_id