欧美1区2区3区激情无套,两个女人互添下身视频在线观看,久久av无码精品人妻系列,久久精品噜噜噜成人,末发育娇小性色xxxx

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')

輸出

a1
a2
a4
加載中...