SQL:尝试SELECT COUNT一列，同时显示另一列

Question

对于家庭作业，我需要搜索IMDb数据库，找出纪录片最多的年份。所以我得到了这个查询：

SELECT  START_YEAR, COUNT(*)
FROM MOVIE
WHERE GENRE = 'Documentary'
GROUP BY START_YEAR
ORDER BY COUNT(*) DESC

这是查询的结果：

START_YEAR  | COUNT
____________|_________
2017        | 52
2018        | 43
2015        | 39
...         | ...

但我需要表格来显示：

GENRE      |  START_YEAR  |  COUNT
___________|______________|_________
Documentary| 2017         | 52
Documentary| 2018         | 43
Documentary| 2015         | 39
...        | ...          | ...

当我向SELECT子句添加某些内容时，我不断地遇到错误。我不知道该怎么办，我是SQL的初学者，上面查询中的所有内容都是我对SQL的全部了解。哈哈谢谢你帮我！！

Answer 1

还将其添加到GROUP BY:

SELECT GENRE, START_YEAR, COUNT(*)
FROM MOVIE
WHERE GENRE = 'Documentary'
GROUP BY GENRE, START_YEAR
ORDER BY COUNT(*) DESC;

或者使用常数：

SELECT 'Documentary' as GENRE, START_YEAR, COUNT(*)
FROM MOVIE
WHERE GENRE = 'Documentary'
GROUP BY START_YEAR
ORDER BY COUNT(*) DESC;

或者使用聚合函数：

SELECT MAX(GENRE) as GENRE, START_YEAR, COUNT(*)
FROM MOVIE
WHERE GENRE = 'Documentary'
GROUP BY START_YEAR
ORDER BY COUNT(*) DESC;