select

sum(3daycnt)/sum(uidcnt) as trdays,

sum(7daycnt)/sum(uidcnt) as sedays

from ad_channel_register_retention_uid

where from_put = 'Oppo'

group by null