Task 4. {3 marks} The vendor of the property under property ID '23' is in the market for too king. and the vendor feels that property needs bu undergo some renovations be bring it back to the market again. Write a MySQL statement to update the property status of the property to 'o market\". Task 5. {2 marks} The Real Estate management would like to receive a llst of propenles whlth have been sold In the last quarter. July 2021 to September 2021{incluslve}. Write one MYSQL query statement he select property information to show this information. Your query should return a teole in the following format. Property ID FIREFLADDRESS SUBURB HATE TYPE m 5. (rs = 6 marks] The Real Estate management has asked you to provide some insights into number of properties Isred in each state. erte one {1) M5601 query statement that returns the number propertles Ilsted In each state. state Number MSW \\I'IC Wk