Answer:
Check the explanation
Explanation:
As per requirement submitted above kindly find below solution.
This demonstration is using SQL Server.
Table Names used as
department
project
works_on
SQL query :
select proj_name,dept_name,count(emp_no) as 'most employees ' from
project,department,works_on
where
project.proj_no=works_on. proj_no and
department. dept_no=works_on. dept_no
group by proj_name,dept_name
having count(emp_no)=(
select max(empCount) from (
select proj_name,dept_name,count(emp_no) empCount from project,department,works_on where project. proj_no=works_on. proj_no and department. dept_no=works_on. dept_no
group by proj_name,dept_name) as emp);
