智慧职教: 假设商品表goods只有gdName，gdPrice两列，数据只有三行如下(‘篮球’,200),(‘排球’,100),(‘足球’,null)SELECT sum(gdPrice),avg(gdPrice),count(gdPrice) FROM goods； 返回的值是

下面将视图view_goods中商品名为“迷彩帽”的gdPrice值更新为30的语句中，正确的是（）。 A: alter view view_goods set gdprice=30 where gdname='迷彩帽'; B: alter view_goods set gdprice=30where gdname='迷彩帽'; C: update view_goods set gdprice=30where gdname='迷彩帽'; D: update view view_goods set gdprice=30where gdname='迷彩帽';

请查询出没有出现在购物车（scars）中的商品名称与价格(goods.gdname, goods.gdprice)，写出其SQL命令

A ccording to how people shop for the goods, consumer goods are divided into convenience goods, shopping goods and .

Which<br/>categories of goods are excludable? ( ) A: private<br/>goods and club goods B: private<br/>goods and common resources C: public<br/>goods and club goods D: public<br/>goods and common resources

The goods which pass through the territory by land is defined as ( ). A: transit goods B: transshipment goods C: through goods D: import and export goods

查询goods中所有记录。 A: select all from goods; B: select distinct from goods; C: select * from goods; D: select from goods;

Some goods can be classified as either public goods or private goods depending on the circumstances.

The income elasticity of a commodity is -2, then the commodity is ( <br/>) A: low-end goods B: General normal goods C: Luxury goods D: Giffen goods

What can a customer claim if the goods are faulty? A: The true-value goods B: The beautiful goods C: The right goods D: The right to his money back