题解 | 请写出计算粉丝ctr的sql语句
请写出计算粉丝ctr的sql语句
https://www.nowcoder.com/practice/853a6567cf524f63bab0879b8d0bfe62
select sum(c.read_num)/sum(c.show_num) as fans_ctr from c left join b on c.content_id=b.content_id left join a on b.author_id=a.author_id where c.fans_id=a.fans_id
查看15道真题和解析