Contents of BOOKS Table

Multiple Choice

Contents of BOOKS table
​
-​Based upon the contents of the BOOKS table in the accompanying figure,which of the following SQL statements will retrieve all books published by the publisher assigned Pubid 1?

A) ​SELECT * FROM books WHERE pubid LIKE "1";
B) ​SELECT * FROM books WHERE pubid = 1;
C) ​SELECT * FROM books WHERE pubid > 1;
D) ​both a and b