select count(author_id) as num
from (
select author_id
from (
select distinct author_id,issue_type
from issue_tb i
right join answer_tb a
on i.issue_id=a.issue_id
where issue_type in('Education','Career')
) ia
group by author_id
having count(author_id) =2
) counts

京公网安备 11010502036488号