Test your knowledge of HAVING
The following query from the NBA Season 2017-2018
database returns the total points contribution, of a teams Centers, where total points are greater than 2500.
SELECT Team,
SUM(TotalPoints) AS TotalCPoints
FROM PlayerStats
WHERE Position = 'C'
GROUP BY Team
HAVING SUM(TotalPoints) > 2500;
Copy and paste the above query into the query console and select Run Code to check the results.
When using HAVING
in a query which one of the following statements is FALSE?
This exercise is part of the course
Improving Query Performance in SQL Server
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
