In SQL, which of the following syntax is correct about order by name?

In SQL, which of the following syntax is correct about order by name?

• A. SELECT * FROM tblstudent ORDER BY name WHERE name = ‘sok’
• B. SELECT * FROM tblstudent WHERE name = ‘sok’ ORDER name
• C. SELECT * FROM tblstudent WHERE name = ‘sok’ ORDER BY name
• D. None correct

Answer: Option C