以下是查询-

select count(*), number from <tableName> where number in (select number from <tableName> where area='three') group by number having count(*)>1;

select number from <tableName> group by number having count(*)>1 and sum(case when area='Three' then 1 else 0) = 1;