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

  • A. SELECT SUM(spend), gender FROM tblcustomer
  • B. SELECT SUM(spend), gender FROM tblcustomer GROUP gender
  • C. SELECT SUM(spend), gender FROM tblcustomer GROUP BY gender
  • D. None correct

Answer: Option A