题解 | 某乎问答回答过教育类问题的用户里有多少用户回答过职场类问题
某乎问答回答过教育类问题的用户里有多少用户回答过职场类问题
https://www.nowcoder.com/practice/b02cf9ee7b9f4cdda308f8155ff3415d
select count(*) as num from answer_tb a join issue_tb i on a.issue_id = i.issue_id where a.author_id in ( select distinct a.author_id from answer_tb a join issue_tb i on a.issue_id = i.issue_id where issue_type='Education') and issue_type='Career'
简单
上海稀宇极智科技有限公司公司福利 2人发布
投递美团等公司10个岗位
