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

  • A. SELECT AVG(age), gender FROM tblstudent
  • B. SELECT AVG(age), gender FROM tblstudent GROUP gender
  • C. SELECT AVG(age), gender FROM tblstudent GROUP BY gender
  • D. None correct

Answer: Option A