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

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

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

Answer: Option C