Based on the Code Shown, Which Query Finds the Name

Multiple Choice

Based on the code shown, which query finds the name of the student whose ID is 1167???Student (StudentID, FirstName, LastName, Street, City, State, PostalCode)

A) SELECT FirstName, LastName FROM Course WHERE StudentID='1167' ;
B) SELECT FirstName, LastName FROM * WHERE StudentID='1167' ;
C) SELECT FirstName, LastName FROM Student WHERE StudentID='1167' ;
D) SELECT FirstName, LastName FROM Customer WHERE StudentID='1167' ;