某数据库中有商品表Table_Goods(GoodsName,GoodsClassID,SaleUnitPrice)和商品分类表 Table_Good

11 查阅

某数据库中有商品表Table_Goods(GoodsName,GoodsClassID,SaleUnitPrice)和商品分类表 Table_GoodsClass(GoodsClassID,GoodsClassName,City),查询单价高于家用电器类的商品平均价格的家用电器类商品:

SELECT GoodsName,SaleUnitPrice FROM

(5)

ON a.GoodsClassID=b.GoodsClassID

WHERE SaleUnitPrice>(

5.

参考答案:

Tabk_GoodsClass a JOIN(GoodsClass bTabk_GoodsClass a JOIN(GoodsClass b

计算机四级