Question: Given the tables Order _ Timeline ( schema id , order _ id , message, created ) & Order _ Shipment Table ( schema id
Given the tables OrderTimelineschema idorderid message, created & OrderShipment Tableschema id orderidactualdispatchdate,created write a SQL Query to find: orders shipped on first message dateOTIF OrderTimeline contains the message for the expected dispatch date, and Ordershipment gives you the real dispatch date. They are combined using orderid
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
