Based on the code above,find the name of the student whose ID is 1167.
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' ;

Question

Based on the code above,find the name of the student whose ID is 1167.​
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' ;

Quizplus · Accepted Answer

The code is querying the database using the table "Student" and searching for a record with a StudentID of 1167. Therefore, the correct query would be "SELECT FirstName, LastName FROM Student WHERE StudentID='1167'."

Based on the Code Above,find the Name of the Student