Based on the code shown, which query lists the name of every student whose postal code is 10113???Student (StudentID, FirstName, LastName, Street, City, State, PostalCode)
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

Quizplus · Accepted Answer

The correct syntax for selecting specific columns from a table is to use the keyword "SELECT" followed by a list of column names separated by commas, followed by the keyword "FROM" followed by the table name. The correct query to select the first name and last name of every student whose postal code is 10113 should be: SELECT FirstName, LastName FROM Student WHERE PostalCode='10113';

Based on the Code Shown, Which Query Lists the Name