列出订购后14天内未发货的订单。 [英] List the orders that were not shipped within 14 days of ordering.

问题描述

CUSTOMER（Cust＃，Cname，City）

ORDER（订单＃，Odate，Cust＃，Ord_Amt）

ORDER_ITEM（订单号，料号＃，数量）

ITEM（Item＃，Unit_price）

发货（订单＃，仓库＃，Ship_Date）

WAREHOUSE（仓库＃，城市）

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)

推荐答案

我推荐你这个问题的另一个副本：列出订购后14天内未发货的订单 [ ^ ] br />
我假设是来自一个同学...也许如果你们两个人在一起你可以做你的作业？

I refer you to the other copy of this question: List the orders that were not shipped within 14 days of ordering[^]
Which I assume is from a classmate...perhaps if the two of you got together you might be able to do your homework?

这篇关于列出订购后14天内未发货的订单。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！