Filtering before and after grouping

• A

  HAVING for both conditions, since both filter the result

• B

  WHERE for both conditions

• C

  WHERE active = true AND AVG(salary) > 50000, placing the GROUP BY afterwards

• D

  WHERE active = true for the rows, and HAVING AVG(salary) > 50000 for the groups