Assuming all tables and columns exist, in which of the following SQL can the HAVING clause be written as a WHERE clause? SELECT a, count(*) FROM xyz GROUP BY a HAVING a = 34 SELECT a, count(*) FROM...

Assuming all tables and columns exist, in which of the following SQL can the HAVING clause be written as a WHERE clause?

SELECT a, count(*) FROM xyz GROUP BY a HAVING a = 34

SELECT a, count(*) FROM xyz GROUP BY a HAVING count(*) = 34

SELECT a, sum(c) FROM xyz GROUP BY b HAVING sum(c) <>

SELECT c, min(a), max(b) FROM xyz GROUP BY c HAVING min(a) =max(b)