AVG

1
SELECT AVG(price) as avg_price
2
FROM products;

1
SELECT ROUND(AVG(rating), 2) as avg_rating
2
FROM reviews
3
WHERE product_id = 'PROD-001';

1
SELECT
2
  category,
3
  ROUND(AVG(price), 0) as avg_price,
4
  COUNT(*) as product_count
5
FROM products
6
GROUP BY category
7
ORDER BY avg_price DESC;

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