Question: Using the BOOKSTORE database, which is the simplest and most efficient query that will correctly find publishers that have published more than two authors (
Using the BOOKSTORE database, which is the simplest and most efficient query that will correctly find publishers that have published more than two authors from least to most
Group of answer choices SELECT publisherpublisherName, count as authorCount
FROM author
INNER JOIN wrote ON author.authorID wrote.authorID
INNER JOIN book ON wrote. ISBN book. ISBN
INNER JOIN publisher ON bookpublisherCode publisher publisherCode
GROUP BY publisherpublisherName
HAVING countauthor authorID
ORDER BY authorCount ASC;
SELECT bookpublisherName, count as authorCount
FROM author
INNER JOIN wrote ON author.authorID wrote.authorID
INNER JOIN book ON wrote.ISBN book.ISBN
GROUP BY bookpublisherName
HAVING countauthorauthorID;
SELECT publisherpublisherName
FROM author
INNER JOIN wrote ON author.authorID wrote.authorID
INNER JOIN book ON wrote. ISBN book. ISBN
INNER JOIN publisher ON bookpublisherCode publisherpublisherCode
GROUP BY publisherpublisherNameHAVING authorauthorID
ORDER BY authorCount DESC;
SELECT publisher.publisherName, count as authorCount
FROM wrote
INNER JOIN book ON wrote. ISBN book. ISBN
INNER JOIN publisher ON bookpublisherCode publisherpublisherCode
GROUP BY publisherpublisherName
HAVING countwroteauthorID
ORDER BY authorCount ASC;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help