select

school_type

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

from ad_channel_register_retention_uid

group by 1

order by 2 desc