SELECT pid 产品ID, ocount 销售总量 FROM orders WHERE ocount > 50;
13. 查询表orders——统计销售总量大于50的各类商品的ID和销售总量
最新推荐文章于 2023-04-28 09:32:26 发布
SELECT pid 产品ID, ocount 销售总量 FROM orders WHERE ocount > 50;