SELECT date ,Round(sum(if(type='no_completed',1,0)) / sum(if(type='completed',1,1)),3)FROM emailWHERE send_id NOT IN(select id FROM user where is_blacklist = 1)and receive_id NOT IN(select id FROM user where is_blacklist = 1)GROUP BY date