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

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

Answer: Option A