Question

Which of the following will display the title, publication date, and publisher name of each book in the BUSINESS category?

A. SELECT title, publication_date, publisher FROM books WHERE category = 'BUSINESS';
B. SELECT title, publication_date, publisher FROM books GROUP BY category HAVING category = 'BUSINESS';
C. SELECT title, publication_date, publisher FROM books ORDER BY category = 'BUSINESS';
D. SELECT title, publication_date, publisher FROM books JOIN categories ON books.category_id = categories.category_id WHERE categories.category_name = 'BUSINESS';

Answer 1

The correct SQL query to display the title, publication date, and publisher name of each book in the BUSINESS category is A. This choice correctly filters the rows based on the BUSINESS category and selects the specified columns.

Step-by-step explanation:

The correct choice to display the title, publication date, and publisher name of each book in the BUSINESS category from a database is:

A. SELECT title, publication_date, publisher FROM books WHERE category = 'BUSINESS';

This SQL query will retrieve all the rows from the books table where the value of the category column matches 'BUSINESS'. It specifically selects the columns title, publication_date, and publisher as requested. Choice B is incorrect because GROUP BY is used for aggregating data, not for selecting specific rows. Choice C is incorrect because ORDER BY is used for sorting data, not for filtering by category. Choice D suggests a more complex scenario where the book's category information is stored in a separate categories table. If this were the case and the category names were stored in a different table linked by a category_id, then this query would be correct. However, based on the question as asked, there is not enough information to determine if a JOIN is necessary, making choice A the best answer based on the information provided.