In SQL, which of the following syntax is correct about group by sid of tblseller?

  • A. SELECT COUNT(sid), gender FROM tblseller
  • B. SELECT COUNT(sid), gender FROM tblseller IN GROUP gender
  • C. SELECT COUNT(sid), gender FROM tblseller GROUP BY gender
  • D. None correct

Answer: Option C