订单表order包含用户信息uid和产品信息pid等属性列,以下语句能够返回至少被订购过三次的pid是______。 A.
SELECT pid FROM order WHERE count(pid)>3; B.
SELECT pid FROM order WHERE max(pid)>=3; C.
SELECT pid FROM order GROUP BY pid HAVING count(pid)>3; D.
SELECT pid FROM order GROUP BY pid HAVING count(pid)>=3;