HSQLDB：由以下原因引起：使用MAX而不是Group By，并获取java.sql.SQLSyntaxErrorException：expression不在聚合或GROUP BY列中：

I am getting a JPQL syntax error message, and I am not sure how to fix the statement to get what I need. I am using HSQLDB 2.4.0, and Hibernate 5.2.7. I am getting a JPQL syntax error message, and I