SQL MS access 1.List the Faculty (First and Last Names) by Department. 2.What pe

Question

SQL MS access

1.List the Faculty (First and Last Names) by Department.

2.What percentage of the total budget does each department get?

StudentGrade OnlineCourse CourseID URL EnrollmentID CourseID StudentID Grade Course CourseID Title Credits DepartmentID Person PersonID LastName FirstName HireDate EnrollmentDate TraditionalCourse CourselD Location Days cTime Courselnstructor CourseID PersonID 0O Department DepartmentID Name Budget StartDate Administrator OfficeAssignment InstructorID Location Timestamp

Explanation / Answer

Here i am writing the queries to get the desired answers.

1. SELECT Person.FirstName,Person.LastName from Person INNER JOIN CourseInstructor where Person.PersonID = CourseInstructor.PersonID INNER JOIN Course where CourseInstructor.CourseID = Course.CourseID INNER JOIN Course.DepartmentID = Department.DepartmentID order by Department.Name group by Person.PersonID;

2. SELECT Department.Name,Department.budget/(select sum(budget) from Department) from Department;

3.
SELECT Person.FirstName,Person.LastName,(Now()-OfficeAssignment.Timestamp)/(365*24*60*60*1000) as YearsEmployed
FROM Person INNER JOIN OfficeAssignment where Person.PersonID = OfficeAssignment.InstructorID;

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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