Untitled

My SQL query is not working [closed]
deptid (type: INT)
deptname (type: TEXT)
hours (type: INT)
active (type: BIT)

empid (type: INT)
empname (type: TEXT)
deptid (type: INT)
designation (type: TEXT)
salary (type: INT)

SELECT e.empname,d.deptname
FROM employee e,department d
WHERE e.deptid=d.deptid
      AND d.deptid
         IN
(
SELECT deptid
FROM employee
GROUP BY deptid
HAVING COUNT(*)>=4
)
ORDER BY e.empname;

SELECT employee.empname, department.deptname
FROM employee
INNER JOIN department ON employee.deptid = department.deptid
WHERE employee.deptid IN
(
  SELECT employee.deptid
  FROM employee
  GROUP BY employee.deptid
  HAVING COUNT(employee.deptid) >= 4
)
ORDER BY employee.empname ASC;