select count(1) num
from (select distinct author_id
from answer_tb as a left join issue_tb as i
on a.issue_id = i.issue_id
where issue_type ='Education') as a
join (select distinct author_id
from answer_tb as a left join issue_tb as i
on a.issue_id = i.issue_id
where issue_type ='Career') as b
on a.author_id = b.author_id



京公网安备 11010502036488号