Okay, tell me the order ID of that tracking number.
select t1.order_id from orders as t1 join shipments as t2 on t1.order_id = t2.order_id where t2.shipment_tracking_number = 3452
Thank you, what is the shipment date of order id 5?
select shipment_date from shipments where order_id = 5
What was the date when order id 5 was placed?
select date_order_placed from orders where order_id = 5
How about the order with invoice number 13, when was that order placed?
select t1.date_order_placed from orders as t1 join shipments as t2 on t1.order_id = t2.order_id where t2.invoice_number = 13