数据库原理实验测试2

碎碎念念脆脆鲨

于 2024-06-21 09:49:43 发布

阅读量311

点赞数 9

文章标签：数据库

本文链接：https://blog.csdn.net/m0_74769370/article/details/139851802

版权

本题目要求编写SQL语句，
在sh_goods表中，查询5星好评的商品库存增加850后的值，以及这些商品进行75折促销后的价格。查询结果显示字段依据输出样例设置。

提示：请使用SELECT语句作答。

select name, price old_price, stock old_stock, price*0.75 new_price, stock+850 new_stock
from sh_goods
where score = 5

insert into sh_goods
values
(2,3,'钢笔','001','练字必不可少',15.00,300,3.90,500);

insert into sh_goods
(id,category_id,name,keyword,content)
values
(1,3,'2B铅笔','001','考试专用');

delete from recorder
where cid=(select cid from customer where cname='马齐');

update good
set stock = stock-10
where gname like '%爱国者%';

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

select id,name,price 
from sh_goods 
where price between 2000 and 6000;

select id,name,price 
from sh_goods 
where category_id = 3 and score = 5

select sg.name,sgc.content 
from sh_goods sg, sh_goods_comment sgc
where sg.id = sgc.goods_id and score = 5

create view view_goods as
select id,name,price old_price,price*0.5 new_price
from sh_goods