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;
Note Order_Events and
Order_Line_Events, with line events presumably serving as
details for the order events.