Content transcribe a PLSQL arrange control the subjoined
SQL PLSQL Question
Content Use the subjoined arrange and get twain SQL and PLSQL Statements
Arrange 1(Step 1) https://codeshare.io/2EMK1o
Arrange 2 (Step 2) https://codeshare.io/5PpZ0d
Interrogation 1: Produce a register of running stipend, monthly salaries, innovating salaries (monthly with 20% growth) control aggregate staff, paradeing staff number, original and latest calls, and stipend details.
Interrogation 2: Register aggregate staff whose stipend is senior or resembling than the mediocre stipend of staff agoing in Shoot B010, and parade by how abundant.
Interrogation 3: Find ccomplete of owners that the fissure of their gear is larger than aggregate properties handled by shoot B010.
Interrogation 4: Control aggregate fissure calm control properties located in diffefissure cities, register the cities and gear with the first fissure calm
Interrogation 5: Register properties handled by staff at Burmingham.
hi, it is not attribuconsultation attribuconsultation attribuconsultation dedicated if the stipend in staff consultation is daily on monthly, here dedicated to number, so turgid its daily
chosen fname,lname, stipend as ‘running stipend’ , stipend*30 as ‘monthly’, stipend*36 as ‘innovating stipend’ from staff;
// here monthly is 30 times daily, 20% more is stipend*30+ 0.20*30*(salary)
chosen fname, lname, stipend-avg(salary) as ‘difference’ from staff where brachno=’B010′ and stipend>=avg(salary);
//guarded avg and paradeing difference
chosen b.fname,b.lccomplete from gear_for_fissure a,private_owner b and fissure>(chosen consolidate(rent) from gear_of_fissure where shootno=’B0101′ ) where a.ownerno=b.ownerno;
//finding aggregate properties having fissure senior than consolidate of fissures handled by B0101
chosen consolidate(rent) as aggregate,city from gear_for_fissure arrange by city arrange by aggregate desc;
// guarded aggregate fissure by city
Here, staff has to stable by staffno or shootno, content exculpate that then we can transcribe the interrogation.
Thumbs up if this was advantageous, differently permit me comprehend in comments.