OrderItems表含有:訂單號(hào)order_num,quantity產(chǎn)品數(shù)量 order_num quantity a1 105 a2 1100 a2 200 a4 1121 a5 10 a2 19 a7 5 【問(wèn)題】從OrderItems表中檢索出不重復(fù)的訂單號(hào)(order_num),其中每個(gè)訂單都要包含 100 個(gè)或更多的產(chǎn)品。 【示例結(jié)果】返回訂單號(hào)列order_num order_num a1 a2 a4
示例1
輸入
DROP TABLE IF EXISTS `OrderItems`;
CREATE TABLE IF NOT EXISTS `OrderItems`(
order_num VARCHAR(255) NOT NULL COMMENT '商品訂單號(hào)',
quantity VARCHAR(255) NOT NULL COMMENT '商品數(shù)量'
);
INSERT `OrderItems` VALUES ('a1','105'),('a2','1100'),('a2','200'),('a4','1121'),('a5','10'),('a2','19'),('a7','5')
加載中...