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 Faculty.ProfName
From Faculty
Left Join Works
On Faculty.ProfName = Works.ProfID
Join Department
On Works.DepartID = Department.DepartId
Where Works.FullTime = 'T'
and Department.DepartID = 300

e) Question is not fully visible.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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