Another way to write HAVING EVERY and HAVING ANY in Mysql

Question

I am trying to find the enames of managers who manage only departments with budgets larger than 1 million, but at least one department with budget less than 5 million

I understand that the query should work like this but can not get it to run in Mysql. Im guessing because Every and Any in the having do not work in mysql. Is there any alternate way to write this? Also here is the schema

Emp(eid: integer, ename: string, age: integer, salary: real) 
Works(eid: integer, did: integer, pct_time: integer) 
Dept(did: integer, dname: string, budget: real, managerid: integer)

And here is the query:

select 
  e.ename 
from 
  emp e, dept d 
where 
  e.eid=d.managerid 
group by 
  e.eid, e.ename 
having 
  every(d.budget>1000000) and 
  any(d.budget<5000000); 

Answer 1

SELECT e.ename
FROM   emp e
       JOIN dept d
         ON e.eid = d.managerid
GROUP  BY e.eid,
          e.ename
HAVING MIN(d.budget) > 1000000
       AND MIN(d.budget) < 5000000;