I feel pretty confident about this one. I remember the rule is that you can use single-row functions in the WHERE clause without a subquery, but you do need a subquery if you want to use them in the HAVING clause. For aggregate functions, it's the opposite - you need a subquery in the WHERE clause but not in the HAVING clause.
Chana
7 months agoPortia
7 months agoMicah
7 months agoRolland
7 months agoDerick
8 months agoLajuana
8 months agoIesha
8 months agoBlair
8 months agoFreeman
8 months ago