Referring to the scenario above, what clause or command do you use in the query to help avoid a costly tablescan?
GROUP BY clause
INDEX command
HAVING clause
FROM clause
WHERE clause