select
    sum(read_num) / sum(show_num) as fans_ctr
from
    c c
    left join b b on b.content_id = c.content_id
where
    (b.author_id, c.fans_id) in (
        select
            author_id,
            fans_id
        from
            a
    )