SQL PLSQL Question

Please Use the following code and provide both SQL and PLSQL Statements Code 1(Step 1) https://codeshare.io/2EMK1o Code 2 (Step 2) https://codeshare.io/5PpZ0d Questions

Query 1: Produce a list of current salary, monthly salaries, new salaries (monthly with 20% increase) for all staff, showing staff number, first and last names, and salary details.

Query 2: List all staff whose salary is greater or equal than the average salary of staff working in Branch B010, and show by how much.

Query 3: Find name of owners that the rent of their property is larger than all properties handled by branch B010.

Query 4: For total rent collected for properties located in different cities, list the cities and property with the highest rent collected

Query 5: List properties handled by staff at Burmingham.