mysql - SQLzoo 教程 | GROUP BY 和 HAVING

Question

我无法正确回答以下问题

Show the years in which three prizes were given for Physics.

我编写了以下脚本，但它返回错误。

SELECT yr, COUNT(subject) FROM nobel
WHERE subject = 'Physics'
GROUP BY yr
HAVING COUNT(subject) = 3

感谢您的宝贵时间

Answer 1

该查询看起来正确，但如果没有指向 SqlZoo 页面的链接，我无法确定。

尝试

SELECT yr FROM nobel
WHERE subject = 'Physics'
GROUP BY yr
HAVING COUNT(subject) = 3

——您返回的结果的确切格式可能很挑剔。它只要求年份。