# 链式关联
select
    round(sum(read_num) / sum(show_num), 4) as fans_ctr
from
    c 
    inner join b on c.content_id = b.content_id
    inner join a on b.author_id = a.author_id
where a.fans_id = c.fans_id
;