1934-confirmation-rate.sql

# Write your MySQL query statement below
select s.user_id,round((sum(case when action="confirmed" then 1 else 0 end)/count(*)),2) as confirmation_rate from #s as s left join Confirmations as c on c.user_id=s.user_id group by s.user_id;