# Write your MySQL query statement below
select s.user_id, round(avg(if(c.action="confirmed",1,0)),2) as confirmation_rate
from Signups as s left join Confirmations as c on s.user_id= c.user_id group by user_id;
avg() function can be used to calculate the rate
and even we can round(avg(if (c.action='confirmed',1,0))) to set up the condition
1934.Confirmation Rate
avg() function can be used to calculate the rate and even we can round(avg(if (c.action='confirmed',1,0))) to set up the condition