Gce Model Questions Vol1 2024 Computer Studies Question 40

Consider the following relational schema:\n\nEmployees(EmpID, Name, DeptID, Salary)\nDepartments(DeptID, DeptName, ManagerID)\nProjects(ProjectID, DeptID, Budget)\n\nEach employee belongs to one department; each department may have several projects; ManagerID references an employee.\n\nWrite an SQL query that returns the names of employees who earn more than the average salary of employees in their own department **and** whose department has at least two projects whose combined budget exceeds ₦5 000 000. Using the data below, how many employees satisfy the query?\n\nEmployees\n1 | Alice | 10 | 800 000\n2 | Bob | 10 | 600 000\n3 | Carol | 20 | 900 000\n4 | Dave | 20 | 700 000\n5 | Eve | 20 | 500 000\n6 | Frank | 30 | 1 200 000\n7 | Grace | 30 | 1 100 000\n\nDepartments\n10 | Sales | 1\n20 | Marketing | 3\n30 | R&D | 6\n\nProjects\n101 | 10 | 2 000 000\n102 | 10 | 3 500 000\n103 | 20 | 1 000 000\n104 | 20 | 4 200 000\n105 | 20 | 500 000\n106 | 30 | 2 500 000\n107 | 30 | 2 600 000