Create A SQL code. Which purchase orders are closed? A purchase order is closed if each and every purchase order line has been fully received or overshipped. A purchase order is still open if any one purchase order line has not been fully received or overshipped. Note that there is an additional column called DateMoved in the result table. This column contains the current date and time from the GETDATE() function. The Result table will have 8 Columns: (POnumber, podateplaced, podateneeded, terms, conditions, buyerempid, vendorid & DateMoved)