Row filtering with HAVING
In some cases, using HAVING, instead of WHERE, as a filter condition will produce the same results. If filtering individual or ungrouped rows then it is more efficient to use WHERE.
In this exercise, you want to know the number of players from Latin American countries playing in the 2017-2018 NBA season.
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
Start Exercise