Explanation:To include aggregate functions having clause must be included after where. 4. The ________ keyword is used to access attributes of preceding tables or subqueries in the from clause.
A. In
B. Lateral
C. Having
D. With
Answer:A
Explanation:To include aggregate functions having clause must be included after where. 4. The ________ keyword is used to access attributes of preceding tables or subqueries in the from clause.
A. In B. Lateral C. Having D. With
Explanation:Eg : Select name, salary, avg salary