select count(distinct c.author_id) num from (select author_id,issue_type, case when issue_type = "Education" then 1 else 0 end jiaoyu from issue_tb a join answer_tb b on a.issue_id=b.issue_id ) as c where c.jiaoyu=1 and c.issue_type="Career"
点赞

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务