查询只卖三种不同型号PC的厂商 (10 分)
本题目要求编写SQL语句, 查询只卖三种不同型号PC的厂商。
注意:只卖pc 且只卖三种pc
SELECT maker
FROM (
SELECT maker,model
FROM product
WHERE product.type='个人电脑' and maker not in(
SELECT maker
FROM product
WHERE product.type!='个人电脑' #找出卖pc之外的maker
)
) a #挑出只卖pc的maker和它的model
GROUP BY maker
HAVING COUNT(maker)=3 #再挑只卖三种model的maker