mysql - SQL 查询故障 : "Invalid use of group function"

Question

注意:我知道查询不完整，我正在尝试一次将其拼凑起来。我此时遇到了错误

基本上，我遇到了 MySQL 错误

Invalid use of group function

我不知道为什么。

这是我正在查询的数据库的图表:

问题是:

“显示已出版两本书以上的出版商的出版商名称和出版书籍数量。记录应按出版书籍数量降序排序，然后按出版商名称升序排序。您的输出应匹配下面给出的显示(包括列标题)。”

输出应该是这样的:

这是我正在尝试的查询:

select publisher.name as "Publisher Name", count(book.isbn)
from publisher as "Book Count"
join book using (publisherID)
where count(book.isbn) > 2
group by publisher.name;

Answer 1

尝试

SELECT MIN(p.name) AS `Publisher Name`, COUNT(b.isbn) AS `Book Count`
  FROM publisher AS p INNER JOIN 
       book      AS b ON p.PublisherID = b.PublisherID
GROUP BY p.publisherID
HAVING COUNT(b.isbn) > 2

这里是 sqlfiddle