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

图片说明

以上是部门员工数据

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%

SELECT departmentname AS 部门名称,COUNT(1) AS 人数,AVG(salary) AS 平均工资,MAX(salary) AS 最高工资
FROM tab1
GROUP BY departmentname

SELECT departmentname AS 部门名称
FROM tab1
GROUP BY departmentname
HAVING COUNT(1)>3

SELECT *
FROM tab1
WHERE gender='F' AND maritalStatus='M' AND birthdate>'1984-01-01'