Hi i need to create a SQL coding for orcale database please create a code for th

Question

Hi i need to create a SQL coding for orcale database

please create a code for the bellow 7 questions will reward 7,000 points to best anwser

can email me too if you have questions email is livingnightmare101 and it is at hotmail.com

thanks!

1. List the name of division that has highest total project budget

2. List the name of division that has more than 1 project that has budget below $4000

3.Among all employees who work on

List the name of division that has highest total project budget List the name of division that has more than 1 project that has budget below $4000 Among all employees who work on "DB development", list the name of employee who make least salary. List the name of the division that has more projects than division of marketing List the name of project that is sponsored by chen's division List the name of employee who do not work on a project with budget below $3500 ncrease the salary of an employee by 10% if he/she works on more than 2 projects (hint: use structure ... where 2> (select count(*) ...))

Explanation / Answer

1) List the name of division that has highest total project budget

select dname from division, budget

where division.did=project.did

and division.did in (

select did from(

select did, DENSE_RANK() OVER (PARTITION BY did ORDER BY sum_budget desc) rank

(select

select did,sum(BUDGET) sum_budget from project group by did

)

) where rank = 1);

2) List the name of division that has more than 1 project that has budget below $4000

select dname from division where did in

(

select did from

(select did from(

select did, count(did) OVER (PARTITION BY did) cnt

) where cnt> 1) more_1_proj,

(select did from(

select did, sum(budget) sum_budget from project group by did

) where sum_budget < 4000) bgt_blow_4000

where more_1_proj.did = bgt_blow_4000.did

);

3) Among all employees who work on

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.