SELECT round(count(DISTINCT b.uid) / count(DISTINCT a.uid), 2) AS '7日留存率' FROM TableA a JOIN TableA b ON a.uid = b.uid WHERE a.p_date = '2021-08-01' AND b.p_date BETWEEN '2021-08-01' AND '2021-08-07'