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

  • A. SELECT COUNT(cid), gender FROM tblstudent WHERE gender = ‘male’
  • B. SELECT COUNT(cid), gender FROM tblstudent GROUP BY gender = ‘male’
  • C. SELECT COUNT(cid), gender FROM tblstudent GROUP BY gender HAVING gender = ‘male’
  • D. None correct

Answer: Option A