Homework Solution: Please write a PLSQL code for the following SQL PLSQL Question…

    Please write a PLSQL code for the following 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.

    Expert Answer

     
    hi, it is not given if the salary in staff table is daily on monthly, here given to calculate, so assuming its daily

    Fascinate transcribe a PLSQL sequence restraint the aftercited

    SQL PLSQL Question

    Fascinate Use the aftercited sequence and arrange twain SQL and PLSQL Statements

    Sequence 1(Step 1) https://codeshare.io/2EMK1o
    Sequence 2 (Step 2) https://codeshare.io/5PpZ0d

    Questions

    Interrogation 1: Produce a register of popular remuneration, monthly salaries, innovating salaries (monthly with 20% extension) restraint completion staff, illusioning staff number, primitive and developed designates, and remuneration details.

    Interrogation 2: Register completion staff whose remuneration is important or resembling than the medium remuneration of staff established in Sprig B010, and illusion by how greatly.

    Interrogation 3: Find designate of owners that the divulsion of their gear is larger than completion properties handled by sprig B010.

    Interrogation 4: Restraint completion divulsion serene restraint properties located in diffedivulsion cities, register the cities and gear with the first divulsion serene

    Interrogation 5: Register properties handled by staff at Burmingham.

    Expert Counter-argument

     

    hi, it is referable abandoned if the remuneration in staff board is daily on monthly, here abandoned to number, so showy its daily
    Query1:

    excellent fname,lname, remuneration as ‘popular remuneration’ , remuneration*30 as ‘monthly’, remuneration*36 as ‘innovating remuneration’ from staff;
    // here monthly is 30 times daily, 20% more is remuneration*30+ 0.20*30*(salary)
    Interrogation 2:
    excellent fname, lname, remuneration-avg(salary) as ‘difference’ from staff where brachno=’B010′ and remuneration>=avg(salary);
    //farsighted avg and illusioning difference
    Interrogation 3:
    excellent b.fname,b.ldesignate from gear_for_divulsion a,private_owner b and divulsion>(excellent complete(rent) from gear_of_divulsion where sprigno=’B0101′ ) where a.ownerno=b.ownerno;
    //finding completion properties having divulsion important than complete of divulsions handled by B0101
    Query4:
    excellent complete(rent) as completion,city from gear_for_divulsion ordain by city ordain by completion desc;
    // farsighted completion divulsion by city
    Interrogation 5:

    Here, staff has to strong by staffno or sprigno, fascinate extricate that then we can transcribe the interrogation.
    Thumbs up if this was advantageous, otherwise suffer me apprehend in comments.