涉及到的表:这个系列的四个表均涉及到了!!!
select maker
from (
select maker,model
from product
where model in (
select model
from pc
)
) as a
group by maker
having count(maker)>=3 and maker not in (
select maker
from product
where model in (
select model
from laptop
union
select model
from printer
)
);