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?
Diese Übung ist Teil des Kurses
Improving Query Performance in SQL Server
Interaktive Übung
In dieser interaktiven Übung kannst du die Theorie in die Praxis umsetzen.
