with tb1 as(
select author_id, issue_type
from answer_tb left join issue_tb using(issue_id)
)
select count(distinct author_id)
from tb1
where issue_type='Career' and
author_id in (
select distinct author_id
from tb1
where issue_type='Education'
)



京公网安备 11010502036488号