postgreSQL -> Aggregate in where-Klausel

[Axel Richter]

Hallo,

Abfrage: select avg(rating) as rating from rating where rating>=8 and rating <=10

GROUP BY vergessen?

SELECT thema, Avg(rating) AS MW_rating
FROM Tabelle2
GROUP BY thema
HAVING (((Avg(rating))>=8 And (Avg(rating))<=9));

Gruß

Axel