app25

with cl ( contry,client,koll) as
(select contry,client ,COUNT(*) over (partition by client,contry)
from orders
)
select distinct * from cl
where koll >=2

на MSSQL можно так попробывать

case в помощь