您需要将聚合仅限于标题为“失落的世界”的书籍：

jdbcTemplate.queryForList("SELECT author, COUNT(*) AS count FROM Quote WHERE title = 'The Lost World' GROUP BY author")

实际上，由于 GROUP BY 问题。以下是原始查询：

SELECT author, COUNT(*) AS count
FROM Quote
WHERE title = 'The Lost World'
GROUP BY author;

这就是你要找的吗？从你的问题很难理解你的文本领域是什么？什么样的数据？你在数什么？我的理解是：

SELECT author, title, ROUND ((LENGTH(text) - LENGTH(REPLACE(text, 
                            title, "") )) / LENGTH(title))  AS count
FROM Quote

然后您可以添加此选项以仅选择所需的标题：

where title = 'The Lost World'

所以你得到这个：

SELECT author, title, ROUND ((LENGTH(text) - LENGTH(REPLACE(text, 
                            title, "") ) 
        ) / LENGTH(title)        
    )  AS count
FROM Quote
where title = 'The Lost World'

这是一个演示
第二次读你的问题时，我发现你可能需要这个：

SELECT author, title, COUNT(*) as count 
FROM Quote 
where title = 'The Lost World'
GROUP BY author, title

或者像这样：

jdbcTemplate.queryForList("SELECT author, title, COUNT(*) as count FROM Quote 
where title = 'The Lost World'
GROUP BY author, title")