Structure of the BOOKS Table

Multiple Choice

Structure of the BOOKS table
Structure of the PUBLISHER table
-Which of the following SQL statements will display the name of each publisher that publishes a book classified in the COMPUTER category?​

A) SELECT UNIQUE name
FROM books,publisher;
B) SELECT UNIQUE name
FROM books NATURAL JOIN publisher
WHERE category = 'COMPUTER';
C) SELECT DISTINCT name
FROM books JOIN publisher
WHERE category = 'COMPUTER';
D) ​both b and c