列出订购后14天内未发货的订单 [英] List the orders that were not shipped within 14 days of ordering
本文介绍了列出订购后14天内未发货的订单的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
给出以下数据库方案:
CUSTOMER(Cust#,Cname,City)
ORDER(订单#,Odate,Cust#,Ord_Amt)
ORDER_ITEM(订单编号,项目编号,数量)
项目(项目编号,单位价格)
装运(订单号,仓库#,Ship_Date)>
WAREHOUSE(仓库#,城市)
(c)生成未下订单的Cname列表。
(d)列出订购后14天内未发货的订单。
Given the following database scheme:
CUSTOMER (Cust#, Cname, City)
ORDER (Order#, Odate, Cust#, Ord_Amt)
ORDER_ITEM (Order#, Item#, Qty)
ITEM (Item#, Unit_price)
SHIPMENT (Order#, Warehouse#, Ship_Date)
WAREHOUSE (Warehouse#, City)
(c)Produce a list of Cname who has not placed any orders.
(d) List the orders that were not shipped within 14 days of ordering.
推荐答案
我们不做功课。
但是我会给你一两个提示:
0)看看SQL JOIN使用两个表之间的链接。 />
1)使用WHERE子句查看SELECT。
We don't do your homework.
But I'll give you a hint or two:
0) look at SQL JOIN to use the links between two tables.
1) look at SELECT with a WHERE clause.
这篇关于列出订购后14天内未发货的订单的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文