mysql#3 完成如下基础增删改查#1 查询奖品名中带机的奖品SELECT name FROM prize WHERE name=机;#2 修改第二个奖品将剩余数量减10#3 查询等级低于3并且价格大于1000的奖品#4 查询表中有多少不同的奖品等级#5 查询每个等级奖品的总数量#6 查询1等奖、3等奖、5等奖的奖品信息

#2 UPDATE prize SET remain=remain-10 WHERE id=2; #3 SELECT * FROM prize WHERE level<3 AND price>1000; #4 SELECT COUNT(DISTINCT level) FROM prize; #5 SELECT level, SUM(total) AS total_quantity FROM prize GROUP BY level; #6 SELECT * FROM prize WHERE level IN (1,3,5);