Based on the code above,list the name of every student whose Zip code is 10113.
A)SELECT FirstName,LastName WHERE Zip='10113' ;
B)SELECT FirstName,LastName FROM Student WHERE Zip='10113' ;
C)SELECT FirstName,LastName FROM Student WHERE Zip='10113'
D)SELECT * FROM Student WHERE Zip='10113' ;

Question

Quizplus · Accepted Answer

The correct syntax for selecting specific columns is to use SELECT followed by the name of the desired column(s), separated by commas. The correct table to select from is the Student table. The correct condition to filter by is WHERE Zip='10113'. Therefore, the correct query is: 
SELECT FirstName,LastName FROM Student WHERE Zip='10113'.

Based on the Code Above,list the Name of Every Student