select case when count(q1.device_id) = 0 then null else (count(q2.device_id)/count(q1.device_id)) end as avg_ret from ( select distinct device_id, date from question_practice_detail ) as q1 left join ( select di...