有订单表orders，包含用户信息userid,产品信息productid,以下（）语句能够返回至少被订购过两回的productid

140. A.selectproductidfromorderswherecount(productid)>1 B.selectproductidfromorderswheremax(productid)>1 C.selectproductidfromorderswherehavingcount(productid)>1groupbyproductid D.selectproductidfromordersgroupbyproductidhavingcount(productid)>1