求问大佬用第 4,5题哪里出错了？

Question

以上是部门员工数据

4.部门员工数超过5人的部门，工资排名前3 的女性员工 列：（部门名称、员工工号）
5.非 Marketing 部门，男性未婚数量超过其部门总人数 30% 的部门号 列：（部门名称）

4.
select DepartmentName,EmployeeId from Data t
where Gender='F'
select top 3 Salary from Data t
group by DepartmentName,EmployeeId,Salary
having COUNT(Name)>5

5.
select DepartmentName from Data t
where DepartmentName!= 'Marketing' and MaritalStatus='S' and Gender='M'
group by DepartmentName
having (COUNT(Name)/COUNT*)>30%

Answer 1

第4个问题可以用下面的试下

select  DepartmentName,EmployeeId from Data t
where Gender='F'
and  3>(SELECT count(*) FROM Data 
where DepartmentName=t.DepartmentName and Salary<t.Salary )

and  DepartmentName in ( select DepartmentName from DATA
where Gender='F' group by DepartmentName HAVING(count(Name)>5) );

ORDER BY DepartmentName,Salary desc;