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 publisher$-$publisherName, 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 book$-$publisherCode $=$ publisher publisherCode

GROUP BY publisher$-$publisherName

HAVING count$($author$.$ authorID$)2$

ORDER BY authorCount ASC;

$$ SELECT book$-$publisherName, count$(*)$ as authorCount

FROM author

INNER JOIN wrote ON author.authorID $=$ wrote.authorID

INNER JOIN book ON wrote.ISBN $=$ book.ISBN

GROUP BY book$-$publisherName

HAVING count$($author$.$authorID$)2$;

SELECT publisher$-$publisherName

FROM author

INNER JOIN wrote ON author.authorID $=$ wrote.authorID

INNER JOIN book ON wrote. ISBN $=$ book. ISBN

INNER JOIN publisher ON book$-$publisherCode $=$ publisher$-$publisherCode

GROUP BY publisher$-$publisherNameHAVING $($author$.$authorID$)2$

ORDER BY authorCount DESC;

SELECT publisher.publisherName, count$(*)$ as authorCount

FROM wrote

INNER JOIN book ON wrote. ISBN $=$ book. ISBN

INNER JOIN publisher ON book$-$publisherCode $=$ publisher$-$publisherCode

GROUP BY publisher$-$publisherName

HAVING count$($wrote$.$authorID$)2$

ORDER BY authorCount ASC;