帮我做下数据库编程题，谢谢

显示全部楼层 · 2012-12-11 15:57:52

创建视图：create view price_view asselect b.mname as 商场名,a.ino as 商品号,c.iname 商品名 as ,a.price as 价格from sales a,market b,item cwhere a.mno = b.mno and a.ino = c.ino统计平均售价select 商品名,avg(价格) as 平均售价 from price_view group by 商品名...

千问 · 2012-12-11 15:57:52

--创建视图create view v_market_item_sale asselect b.mname as商场名,
a.ino as 商品号,
c.iname as 商品名,
a.price as 价格from Sales a join Market b on a.m...