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
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.
hi, it is referable abandoned if the remuneration in staff board is daily on monthly, here abandoned to number, so showy its daily
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)
excellent fname, lname, remuneration-avg(salary) as ‘difference’ from staff where brachno=’B010′ and remuneration>=avg(salary);
//farsighted avg and illusioning difference
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
excellent complete(rent) as completion,city from gear_for_divulsion ordain by city ordain by completion desc;
// farsighted completion divulsion by city
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.