AVG

1
SELECT AVG(price) as average_price
2
FROM `project.dataset.products`;

1
SELECT
2
  department,
3
  AVG(salary) as avg_salary,
4
  COUNT(*) as employee_count
5
FROM `project.dataset.employees`
6
GROUP BY department
7
ORDER BY avg_salary DESC;

1
SELECT
2
  AVG(rating) as overall_avg,
3
  AVG(IF(verified_purchase = TRUE, rating, NULL)) as verified_avg,
4
  AVG(IF(verified_purchase = FALSE, rating, NULL)) as unverified_avg
5
FROM `project.dataset.reviews`;

1
SELECT
2
  sale_date,
3
  daily_revenue,
4
  AVG(daily_revenue) OVER (
5
    ORDER BY sale_date
6
    ROWS BETWEEN 6 PRECEDING AND CURRENT ROW
7
  ) as moving_avg_7_days
8
FROM `project.dataset.daily_sales`
9
ORDER BY sale_date;