Агрегатные функции¶
AVG¶
-
AVG
()¶ Среднее значение в указанном поле
select sex , avg(age) age_avg from table group by sex order by age_avg desc
select user_id , avg(rating) avg_rating from ratings group by user_id having avg(rating) < 4.5
AVG
()¶Среднее значение в указанном поле
select
sex
, avg(age) age_avg
from
table
group by
sex
order by
age_avg desc
select
user_id
, avg(rating) avg_rating
from
ratings
group by
user_id
having
avg(rating) < 4.5