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.

Question

Copy the following query to the console and select Run Code to view the results. Why should HAVING not be used as a filter condition in this query?

SELECT Country, COUNT(*) CountOfPlayers 
FROM Players
GROUP BY Country
HAVING Country 
    IN ('Argentina','Brazil','Dominican Republic'
        ,'Puerto Rico');

Possible answers

An aggregate function must enclose the Country column in the HAVING filter.

The filter is on individual rows. Using HAVING here, for filtering, could increase the time a query takes to run.

The query returns an error because HAVING is processed before GROUP BY.

If a query is using HAVING for filtering it must also use WHERE.

Exercise

Row filtering with HAVING

Instructions 1/2

Question

Possible answers