Managers of High-Budget Departments

Given the same schema, which query finds names of managers who manage only departments with budgets > $1 million?

-- Option A
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;

-- Option B
SELECT e.ename
FROM Emp e
JOIN Dept d ON e.eid = d.managerid
WHERE d.budget > 1000000;

-- Option C
SELECT e.ename
FROM Emp e
JOIN Dept d ON e.eid = d.managerid
GROUP BY e.eid, e.ename
HAVING AVG(d.budget) > 1000000;