@NamedQuery(name = "Produits.findTop", query = "SELECT a.produit FROM Avis a GROUP BY a.produit ORDER BY avg(a.note) DESC")})

Caused by: Exception [EclipseLink-8025] (Eclipse Persistence Services - 2.0.1.v20100213-r6600): org.eclipse.persistence.exceptions.JPQLException
Exception Description: Syntax error parsing the query [Produits.findTop: SELECT a.produit FROM Avis a GROUP BY a.produit ORDER BY avg(a.note) DESC], line 1, column 57: unexpected token [avg].
Internal Exception: NoViableAltException(10!=[1328:1: orderByItem returns [Object node] : (n= stateFieldPathExpression (a= ASC | d= DESC | ) | i= IDENT (a= ASC | d= DESC | ) );])

SELECT avg(a.note) FROM Avis a GROUP BY a.produit
SELECT a.produit FROM Avis a GROUP BY a.produit ORDER BY a.note DESC