pta mysql训练题集(361-380)

10-361 查询商品表中部分字段

select id,category_id,name from sh_goods;

10-362 简单条件查询数据

select * from sh_goods where id = 1;

10-363 修改商品表价格数据

update sh_goods set price = 30 where id = 2

10-364 删除商品表数据

delete from sh_goods where category_id != 3;

10-365 获取每个分类下商品的最高价格

select category_id,max(price) as max_price
from sh_goods
group by category_id;

10-366 查询商品表中商品库存的最高和最低值

select max(stock) as stock1,min(stock) as stock2
from sh_goods;

10-367 获取指定条件商品的平均价格