1. What projects in the PROJECT table have not been completed? 2. What is the to

Question

1. What projects in the PROJECT table have not been completed?
2. What is the total MaxHours of projects being run by the Marketing Department? Be sure to assign an appropriate column name to the computed results.
3. What is the average MaxHours of projects being run by the Marketing Department? Be sure to assign an appropriate column name to the computed results. 1. What projects in the PROJECT table have not been completed?
2. What is the total MaxHours of projects being run by the Marketing Department? Be sure to assign an appropriate column name to the computed results.
3. What is the average MaxHours of projects being run by the Marketing Department? Be sure to assign an appropriate column name to the computed results.
PROJECT rojedtiD FirstName Department Phont Emal MaxHours StartDate EndDate DepartmentHame Budget Code Office Number Phone

Explanation / Answer

1.

Select * from PROJECT where EndDate IS NULL;

2.

Select sum(MaxHours) as TotalTimeForMarketingProjects from PROJECT inner join ASSIGNEMENT on PROJECT.ProjectID = ASSIGNMENT.ProjectID inner join EMPLOYEE on ASSIGNMENT.EmployeeNumber = EMPLOYEE.EmployeeNumber inner join DEPARTMENT on EMPLOYEE.Department = DEPARTMENT.DepartmentName where DEPARTMENT.DepartmentName = 'Marketing' ;

3.

Select avg(MaxHours) as AverageTimeForMarketingProjects from PROJECT inner join ASSIGNEMENT on PROJECT.ProjectID = ASSIGNMENT.ProjectID inner join EMPLOYEE on ASSIGNMENT.EmployeeNumber = EMPLOYEE.EmployeeNumber inner join DEPARTMENT on EMPLOYEE.Department = DEPARTMENT.DepartmentName where DEPARTMENT.DepartmentName = 'Marketing' ;

Do ask if any doubt. Please upvote.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

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