涉及到的表:product、pc
select maker from(
select a.maker,b.speed
from product a join pc b on a.model=b.model
group by b.speed,a.maker
)as a
group by maker having count(*)>=3
这个涉及到了join on的用法,目前这种方法我还不太熟练
涉及到的表:product、pc
select maker from(
select a.maker,b.speed
from product a join pc b on a.model=b.model
group by b.speed,a.maker
)as a
group by maker having count(*)>=3
这个涉及到了join on的用法,目前这种方法我还不太熟练