Your client has a contract that started on 1/1/2016 and ends on 5/31/2030. The client signs a continuation of the contract with altered terms that starts on 4/1/2028 with an end date of 12/31/2040. Write the queries you would need to update the old contract and insert the new contract.

There is no table structure, this is a general question. There is for sure a startDate and endDate on the table. Could be written in mySQL