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

Question

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

Quizplus · Accepted Answer

Option B is the correct one because it selects the first name and last name of the student from the Student table where the PostalCode is equal to '10113'. The SELECT statement is used to retrieve data from the specified columns in the table. The WHERE clause filters out the rows that do not meet the specified criteria. This statement will only return the required information for the specified criteria.

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