Write the suitable SQL statement to answer the following questions based on the following tables

Write the suitable SQL statement to answer the following questions based on the following tables

A. Change Property’s (PNo= 101) type to house with 5 rooms. [1 mark]

B. By using Nesting Query, Retrieve Name and Salary of staff who works in Riyadh. [2 marks]

C. Retrieve number of property under each type. [1 mark]

D. List the name of staff, the branch they work in and the type of property they manage. (Use join) [1 marks]