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

Question

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

Quizplus · Accepted Answer

The Answer of  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

Structure of the BOOKS Table