中国大学MOOC: 创建视图sale_item_view，该视图中包含订单编号、订货日期、图书编号及数量。可以使用以下SQL语句实现：create view sale_item_view（order_no，order_date，book_no，qty） asselect sales.order_no,sales.order_date,book_no,qtyfrom sales,sale_itemwheresales.order_no=sale_item.order_no
举一反三
- 创建视图sale_item_view，该视图中包含订单编号、订货日期、图书编号及数量。
- 以下英文用词可译为跟单员的是（ )。 A: ORDER SUPERVISOR B: SALES CONTRACT C: ORDER FOLLOWER D: PURCHASE ORDER
- We have this item () and we will arrange the delivery within 24 hours once you () A: out of stock..make an order B: in stock..place an order C: on stock..make an order D: to stock..place an order
- 下面关于修改视图的SQL语句，那个是正确的（ ）。 A: alter view VIEW01 as select * from users order by age desc B: alter view VIEW02 as select name,avg(score) as avgScore from studentScore C: alter view VIEW03 as select top 10 id,name,password from admin order by id D: alter view VIEW04 as select * from stuent,class where student.classid=class.classid order by class.classid
- One among the following is an example of a pre-sales document() A: Inquiry B: Sales Order C: Bill D: Purchase Order