select date, 
round(count(if(type='no_completed',1,null))/count(type),3)
from email
where receive_id in (select id from user where is_blacklist=0) 
and 
send_id in (select id from user where is_blacklist=0)
group by date
order by date