Question

Aggregate functions can be used in the select list or the_______clause of a select statement or subquery. They cannot be used in a ______ clause.

(a) Where, having

(b) Having, where

(c) Group by, having

(d) Group by, where

I got this question in an interview for internship.

This interesting question is from Aggregate Functions and Nested Subqueries in chapter SQL : Queries, Constraints and Triggers of Database Management

Answer 1

Right option is (b) Having, where

To explain: To include aggregate functions having clause must be included after where.