1.次日留存率
SELECT
SUM(if((tomorrowdate is NULL),0,1))/count(*) as avg_ret
FROM(
SELECT
distinct a.device_id,
a.date,
b.tomorrowdate
FROM question_practice_detail a
LEFT JOIN(
SELECT
device_id,
date,
date_add(date