Structure of the BOOKS Table

Multiple Choice

Structure of the BOOKS table
Structure of the PUBLISHER table
-Which of the following will display the title,publication date,and publisher name of each book in the BUSINESS category?​

A) SELECT title,pubdate,name
FROM publisher JOIN books USING (pubid)
WHERE category = 'BUSINESS';
B) SELECT title,pubdate,name
FROM publisher JOIN books ON (pubid)
WHERE category = 'BUSINESS';
C) SELECT title,pubdate,name
FROM publisher OUTER JOIN books USING (pubid)
WHERE category = 'BUSINESS';
D) SELECT title,pubdate,name
FROM publisher CROSS JOIN books USING (pubid)
WHERE category = 'BUSINESS';