力扣---高频SQL题---14---1934. 确认率

一、题目

二、代码

# Write your MySQL query statement below
-- select user_id,count(user_id) from Confirmations
-- group by  user_id

select table2.user_id, round(coalesce(table1.c1,0) / table2.c2,2) as  confirmation_rate from
(
select user_id,count(user_id) as c1 from Confirmations
where action = 'confirmed'
group by  user_id
) as table1
right join
(
select Signups.user_id ,count(Signups.user_id ) as c2 from Signups  
left join Confirmations 
on Signups.user_id  = Confirmations.user_id 
group by Signups.user_id
) as table2
on table1.user_id = table2.user_id

-- select Signups.user_id ,count(Signups.user_id )  from Signups 
-- left join Confirmations 
-- on Signups.user_id  = Confirmations.user_id 
-- group by Signups.user_id

三、运行结果