有一张电话表（telephones），id是主键，send_

SELECT 
t.date, 
ROUND(
SUM(
CASE WHEN t.type = 'no_completed' THEN 1 ELSE 0 END
) * 1.0 / COUNT(t.type), 
2
) AS p 
FROM 
telephones t 
JOIN users u1 ON t.send_id = u1.id 
AND u1.is_blacklist = 0 
JOIN users u2 ON t.receive_id = u2.id 
AND u2.is_blacklist = 0 
GROUP BY 
t.date 
ORDER BY 
t.date DESC;

SELECT 
t.date, 
ROUND(
SUM(
CASE t.type WHEN 'completed' THEN 0 ELSE 1 END
)* 1.0 / COUNT(t.type), 
2
) AS p 
FROM 
telephones AS t, 
users as u 
WHERE 
t.send_id = u.id 
AND t.receive_id = u.id 
AND u.is_blacklist = 0 
GROUP BY 
t.date 
ORDER BY 
t.date DESC;

SELECT 
t.date, 
ROUND(
SUM(
CASE WHEN t.type = 'no_completed' THEN 1 ELSE 0 END
) / COUNT(t.type), 
2
) AS p 
FROM 
telephones t 
JOIN users u1 ON t.send_id = u1.id 
AND u1.is_blacklist = 0 
JOIN users u2 ON t.receive_id = u2.id 
AND u2.is_blacklist = 0 
GROUP BY 
t.date 
ORDER BY 
t.date DESC;

SELECT 
t.date, 
ROUND(
SUM(
CASE WHEN t.type = 'no_completed' THEN 1 ELSE 0 END
) * 1.0 / COUNT(t.type), 
2
) AS p 
FROM 
telephones 
JOIN users u1 ON t.send_id = u1.id 
AND u1.is_blacklist = 0 
JOIN users u2 ON t.receive_id = u2.id 
AND u2.is_blacklist = 0 
GROUP BY 
t.date 
ORDER BY 
t.date DESC;