Question: 37
(Choose 1 answer)
Regarding the difference between WHERE and HAVING in SQL, which of the following is true?
A. WHERE is used filter data in an SQL query on aggregated values, HAVING is used on non- the aggregated
ones.
B. WHERE is written after GROUP BY, while HAVING comes before GROUP BY.
C. WHERE is used filter data in an SQL query on non-aggregated values, HAVING is used on the aggregated
ones.
D. HAVING and WHERE is written before GROUP BY, while HAVING comes before WHERE.
