easy5 pts · first answer countssql

WHERE vs HAVING

You want customers whose total order value is above 1000. Which clause should filter on SUM(amount) > 1000?

A.WHERE, because it always runs after GROUP BYB.ORDER BY, because it sees the aggregated valueC.HAVING, because it filters groups after aggregationD.ON, because it is part of the join

← What a foreign key enforces Data type for money →