Problem 9
SELECT O.Order_ID,
O.Due_Date, E.First_Notification_Date, L.Item_ID
FROM Orders O, Order_Lines L, Order_Events E, Order_Line_Events
LE
WHERE O.Customer_ID =
:B1
AND O.Order_ID = L.Order_ID
AND O.Order_ID = E.Order_ID
AND E.Event_Type = 'LATE_SHIPMENT'
AND L.Line_ID = LE.Line_ID
ORDER BY O.Due_Date;
Assumptions (These may be valid, today, but tomorrow?):
1.There is at most one event of type 'LATE_SHIPMENT' per order.
2.There are no line event details for any event types
other than the 'LATE_SHIPMENT' event.
3.There is at most one order with any given due date per customer.