select signups.user_id,
ifnull(round(sum(action='confirmed')/count(Confirmations.action),2),0.00) AS confirmation_rate
from signups left join confirmations on signups.user_id=Confirmations.user_id
Group by signups.user_id
select signups.user_id,
ifnull(round(sum(action='confirmed')/count(Confirmations.action),2),0.00) AS confirmation_rate
from signups left join confirmations on signups.user_id=Confirmations.user_id
Group by signups.user_id