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