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?
Este exercício faz parte do curso
Improving Query Performance in SQL Server
Exercício interativo prático
Transforme a teoria em ação com um de nossos exercícios interativos
