SELECT COUNT(DISTINCT q2.device_id,q2.date) / COUNT(DISTINCT q1.device_id,q1.date) AS avg_ret FROM question_practice_detail q1 LEFT JOIN question_practice_detail q2 ON q1.device_id=q2.device_id AND DATEDIFF(q2.date,q1.date);#这道题有点意思