Soe ilanner. Faculty (ProfID: integer, ProfName: string, Age: integer, Salary: r

Question

Soe ilanner. Faculty (ProfID: integer, ProfName: string, Age: integer, Salary: real) Works (ProfID: integer, DepartID: integer, FullTime: boolean) Department (DepartID: integer, DepartName: string, Budget: real, ChairlD: integer) a. (10 points) Names of all professors. b. (10 points) Names of departments whose budgets are greater than 500. c. (10 points) Names of professors who earns more than $60,000. d. (5 points) Names of full time professors who work in the department 300 (departme (5 points) Names of professors who work in the "Computer Science" department, a more than 80,000. e.

Explanation / Answer

a. select ProfName from Faculty;

b. select DepartName from Department where Budget > 500 ;

c. select ProfName from Faculty where Salary > 60000 ;

d. select ProfName from Faculty f

inner join Works w

on f.ProfID = w.ProfID

inner join Department d

on d.DepartID = w.DepartID

where d.DepartID = 300;

f. select ProfName from Faculty f

inner join Works w

on f.ProfID = w.ProfID

inner join Department d

on d.DepartID = w.DepartID

where d.DepartName = 'Computer Science'

and f.Salary > 80000 ;

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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