3826200232

Zapytanie do hurtowni danych

Group by

SELECT Academic_year, Name, AVG(Grade)

FROM Students_grades G, Academic_year A, Professor P

WHERE G.Professor = P.ID and G.Academic_year = A. ID

GROUP BY Academic_year, Name;

Odpowiedź
Academic_year	Surname	AVG(Grade)
2001/2	Stefanowski	4.2
2002/3	Stefanowski	4.0
2003/4	Stefanowski	3.9
2001/2	Słowiński	4.1
2002/3	Słowiński	3.8
2003/4	Słowiński	3.6
2003/4	Dembczyński	4.8

Systemy OLAP