Aggregate
BigQuery
AVG
BigQueryCalculates the average (mean) of numeric values in a column. Ignores NULL values and supports multiple numeric types in BigQuery.
Tipe hasil:
FLOAT64Diperbarui: 13 Jun 2026Syntax
SQL
AVG(expression) | AVG(DISTINCT expression)Parameter
expressionnumericwajib
A numeric column or expression to average
DISTINCTmodifieropsional
Calculates the average of only unique values
Contoh Penggunaan
Simple Average
SQL
1 SELECT AVG(price) as average_price 2 FROM `project.dataset.products`;
Calculates the average price of all products.
Hasil
249500.75
AVG with GROUP BY
SQL
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;
Calculates the average salary per department.
Hasil
| department | avg_salary | employee_count |
|---|---|---|
| Engineering | 15500000.00 | 45 |
| Marketing | 12000000.00 | 28 |
| Operations | 9500000.00 | 62 |
Conditional AVG
SQL
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`;
Compares the average rating between verified and unverified purchases.
Hasil
| overall_avg | verified_avg | unverified_avg |
|---|---|---|
| 4.2 | 4.5 | 3.8 |
Moving Average with Window Function
SQL
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;
Calculates a 7-day moving average of daily revenue.
Hasil
| sale_date | daily_revenue | moving_avg_7_days |
|---|---|---|
| 2024-01-07 | 2500000 | 2285714.29 |
| 2024-01-08 | 2800000 | 2414285.71 |
| 2024-01-09 | 2200000 | 2428571.43 |
Pertanyaan Umum tentang AVG
Apa itu fungsi AVG di BigQuery?
Calculates the average (mean) of numeric values in a column. Ignores NULL values and supports multiple numeric types in BigQuery. Di BigQuery, fungsi AVG termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.
Bagaimana cara menggunakan AVG di BigQuery?
Gunakan sintaks berikut: AVG(expression) | AVG(DISTINCT expression). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.
Apa nilai yang dikembalikan oleh fungsi AVG?
Fungsi AVG mengembalikan nilai bertipe FLOAT64. Pastikan tipe data hasil sudah sesuai dengan kebutuhan query atau formula kamu. Jika input mengandung nilai NULL, perilaku fungsi dapat berbeda — selalu periksa dokumentasi untuk memastikan hasilnya sesuai ekspektasi.
Apa saja parameter fungsi AVG?
Fungsi ini memiliki 1 parameter wajib dan 1 parameter opsional. Parameter yang digunakan: expression (numeric, wajib): A numeric column or expression to average; DISTINCT (modifier, opsional): Calculates the average of only unique values.
Ngulik Langsung
Latihan Langsung →Sudah paham AVG? Latih langsung di browser
Latihan interaktif, langsung di browser.