In SQL, which of the following syntax is correct for filtering the sum?

In SQL, which of the following syntax is correct for filtering the sum?

• A. SELECT SUM(spend), gender FROM tblcustomer WHERE gender = ‘male’
• B. SELECT SUM(spend), gender FROM tblcustomer GROUP BY gender = ‘male’
• C. SELECT SUM(spend), gender FROM tblcustomer GROUP BY gender HAVING gender = ‘male’
• D. None correct

Answer: Option A