仅Hibernate错误：“列必须出现在GROUP BY子句中或在聚合函数中使用”

@Entity
@Table(name = "products")
public class Product {
    @Id
    @Column(name = "product_id")
    private Long productId;

    @Column(name = "category")
    private String category;

    @Column(name = "sales_amount")
    private Double salesAmount;

    // Getters and setters
}

String hql = "SELECT p.category, SUM(p.salesAmount) FROM Product p GROUP BY p.category";
Query query = session.createQuery(hql);
List<Object[]> results = query.list();
for (Object[] row : results) {
    String category = (String) row[0];
    Double totalSales = (Double) row[1];
    System.out.println("Category: " + category + ", Total Sales: " + totalSales);
}