{"id":61638,"date":"2026-02-25T14:06:54","date_gmt":"2026-02-25T07:06:54","guid":{"rendered":"https:\/\/www.rumahweb.com\/journal\/?p=61638"},"modified":"2026-04-14T09:52:31","modified_gmt":"2026-04-14T02:52:31","slug":"belajar-sql-database-10","status":"publish","type":"post","link":"https:\/\/www.rumahweb.com\/journal\/belajar-sql-database-10\/","title":{"rendered":"Belajar SQL Database Bagian 10 \u2013 Fungsi Agregat dan Grouping"},"content":{"rendered":"\n<p>Di seri belajar SQL database <strong><a href=\"https:\/\/www.rumahweb.com\/journal\/belajar-sql-database-9\/\" target=\"_blank\" rel=\"noopener\" title=\"\">bagian 9<\/a><\/strong>, kita sudah belajar tentang <em>constraint <\/em>di MySQL yang berfungsi untuk menjaga agar data tetap valid dan terstruktur dengan baik di dalam tabel. Dengan constraint, database menjadi lebih aman dari kesalahan input data.<\/p>\n\n\n\n<p>Nah selanjutnya pada belajar SQL database bagian 10 kita akan beralih ke topik fungsi agregat dan grouping dalam SQL. Materi ini sangat penting karena dalam praktiknya kita tidak hanya membutuhkan data mentah, tetapi juga ringkasan dan analisis data, seperti rata-rata nilai mahasiswa, nilai tertinggi, atau jumlah mata kuliah yang diambil mahasiswa.<\/p>\n\n\n\n<p>Pada bagian ini, kita akan mempelajari pengertian fungsi agregat, cara kerja fungsi seperti COUNT, SUM, AVG, MIN, dan MAX, serta penggunaan GROUP BY dan HAVING untuk mengelompokkan dan memfilter hasil analisis data secara lebih efektif.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Apa Itu Fungsi Agregat?<\/h2>\n\n\n\n<p>Fungsi agregat adalah fungsi dalam SQL yang digunakan untuk menggabungkan banyak baris menjadi satu nilai ringkasan. Fungsi ini sangat berguna ketika kita ingin mendapatkan insight dari data dalam jumlah besar.<\/p>\n\n\n\n<p>Beberapa fungsi agregat utama dalam SQL adalah:<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-regular\"><table><tbody><tr><td><strong>Fungsi<\/strong><\/td><td><strong>Kegunaan<\/strong><\/td><\/tr><tr><td>COUNT()<\/td><td>Menghitung jumlah baris<\/td><\/tr><tr><td>SUM()<\/td><td>Menjumlahkan nilai<\/td><\/tr><tr><td>AVG()<\/td><td>Menghitung rata-rata<\/td><\/tr><tr><td>MIN()<\/td><td>Mencari nilai terkecil<\/td><\/tr><tr><td>MAX()<\/td><td>Mencari nilai terbesar<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Dalam konteks akademik, fungsi agregat sering digunakan untuk:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>menghitung jumlah mata kuliah yang diambil mahasiswa,<\/li>\n\n\n\n<li>melihat rata-rata nilai per mahasiswa,<\/li>\n\n\n\n<li>mencari nilai tertinggi dan terendah,<\/li>\n\n\n\n<li>mengidentifikasi mahasiswa berprestasi, dan<\/li>\n\n\n\n<li>membuat laporan akademik atau dashboard nilai.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Contoh Struktur Tabel<\/h2>\n\n\n\n<p>Agar pembahasan lebih mudah dipahami, kita akan menggunakan contoh tabel nilai_mahasiswa berikut:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-36.png\"><img loading=\"lazy\" decoding=\"async\" width=\"919\" height=\"349\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-36.png\" alt=\"Data dari tabel nilai_mahasiswa yang digunakan untuk belajar SQL saat ini\" class=\"wp-image-61653\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-36.png 919w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-36-300x114.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-36-768x292.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-36-370x141.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-36-270x103.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-36-570x216.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-36-740x281.png 740w\" sizes=\"auto, (max-width: 919px) 100vw, 919px\" \/><\/a><\/figure>\n\n\n\n<p>Tabel ini menyimpan data nilai mahasiswa untuk beberapa mata kuliah.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Fungsi COUNT() &#8211; Menghitung Jumlah Data<\/h2>\n\n\n\n<p>Fungsi COUNT() digunakan untuk menghitung jumlah baris dalam sebuah tabel.<\/p>\n\n\n\n<p>Contoh menghitung total data nilai:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT COUNT(*) AS total_data_nilai\nFROM nilai_mahasiswa;<\/code><\/pre>\n\n\n\n<p>Berikut hasil perhitungan total data nilainya:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-40.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"170\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-40-1024x170.png\" alt=\"Hasil query penggunaan fungsi count()\" class=\"wp-image-61657\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-40-1024x170.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-40-300x50.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-40-768x128.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-40-370x61.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-40-270x45.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-40-570x95.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-40-740x123.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-40.png 1054w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>Penjelasan:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>COUNT(*) menghitung semua baris tanpa memedulikan nilai NULL.<\/li>\n\n\n\n<li>Cocok untuk menghitung total data nilai, total mahasiswa, atau total mata kuliah.<\/li>\n<\/ul>\n\n\n\n<p>Perbedaan penting:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>COUNT(*) ? menghitung semua baris<\/li>\n\n\n\n<li>COUNT(kolom) ? hanya menghitung baris yang tidak NULL<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Fungsi SUM(), AVG(), MIN(), dan MAX()<\/h2>\n\n\n\n<p>Berikut penjelasan masing-masing fungsi:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SUM() \u2014 Total Nilai<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT SUM(nilai) AS total_semua_nilai\nFROM nilai_mahasiswa;<\/code><\/pre>\n\n\n\n<p>Query ini menjumlahkan seluruh nilai yang ada dalam tabel. Berikut hasilnya:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-44.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"172\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-44-1024x172.png\" alt=\"Hasil query penggunaan fungsi SUM()\" class=\"wp-image-61661\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-44-1024x172.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-44-300x50.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-44-768x129.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-44-370x62.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-44-270x45.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-44-570x96.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-44-740x124.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-44.png 1036w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">AVG() \u2014 Rata-rata<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT AVG(nilai) AS rata_rata_nilai\nFROM nilai_mahasiswa;<\/code><\/pre>\n\n\n\n<p>Berikut hasil rata &#8211; rata yang didapati :<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-42.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"168\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-42-1024x168.png\" alt=\"Hasil query penggunaan fungsi AVG()\" class=\"wp-image-61659\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-42-1024x168.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-42-300x49.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-42-768x126.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-42-370x61.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-42-270x44.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-42-570x93.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-42-740x121.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-42.png 1093w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>Biasanya dipakai untuk:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>melihat kualitas rata-rata mahasiswa,<\/li>\n\n\n\n<li>mengevaluasi performa kelas,<\/li>\n\n\n\n<li>menentukan standar kelulusan.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">MIN() &amp; MAX() \u2014 Nilai Terkecil dan Terbesar<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT&nbsp;\n&nbsp;&nbsp;MIN(nilai) AS nilai_terendah,\n&nbsp;&nbsp;MAX(nilai) AS nilai_tertinggi\nFROM nilai_mahasiswa;<\/code><\/pre>\n\n\n\n<p>Berikut nilai terendah dan tertingginya:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-46.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"157\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-46-1024x157.png\" alt=\"Hasil query penggunaan fungsi Min() &amp; MAX()\" class=\"wp-image-61663\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-46-1024x157.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-46-300x46.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-46-768x118.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-46-370x57.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-46-270x41.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-46-570x88.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-46-740x114.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-46.png 1185w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>Fungsi ini berguna untuk:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>mencari mahasiswa dengan nilai terendah,<\/li>\n\n\n\n<li>mencari mahasiswa dengan nilai tertinggi,<\/li>\n\n\n\n<li>membandingkan performa akademik.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">GROUP BY &#8211; Mengelompokkan Data<\/h2>\n\n\n\n<p>Fungsi agregat sering digunakan bersama GROUP BY, yaitu perintah untuk mengelompokkan data berdasarkan kolom tertentu.<\/p>\n\n\n\n<p>Contoh menghitung rata-rata nilai setiap mahasiswa menggunakan GROUP BY:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT mahasiswa_id, AVG(nilai) AS rata_rata_nilai\nFROM nilai_mahasiswa\nGROUP BY mahasiswa_id;<\/code><\/pre>\n\n\n\n<p>Query berikut digunakan untuk menghitung rata-rata nilai setiap mahasiswa dengan mengelompokkan data berdasarkan mahasiswa_id menggunakan GROUP BY. Berikut hasilnya :<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-47.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"185\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-47-1024x185.png\" alt=\"Hasil query penggunaan fungsi agregat GROUP BY \" class=\"wp-image-61664\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-47-1024x185.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-47-300x54.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-47-768x139.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-47-370x67.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-47-270x49.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-47-570x103.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-47-740x134.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-47.png 1244w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>Cara kerjanya:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>SQL mengelompokkan baris data berdasarkan nilai mahasiswa_id yang sama<\/li>\n\n\n\n<li>Lalu menghitung rata-rata nilai tiap mahasiswa<\/li>\n<\/ol>\n\n\n\n<p>Tanpa GROUP BY, query di atas akan menghasilkan error.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">WHERE vs HAVING<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>WHERE<\/strong><\/td><td><strong>HAVING<\/strong><\/td><\/tr><tr><td>Memfilter data sebelum proses GROUP BY<\/td><td>Dipakai setelah GROUP BY<\/td><\/tr><tr><td>Untuk filter baris biasa<\/td><td>Untuk filter hasil agregasi<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Contoh penggunaan HAVING:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT mahasiswa_id, AVG(nilai) AS rata_rata_nilai\nFROM nilai_mahasiswa\nGROUP BY mahasiswa_id\nHAVING AVG(nilai) &gt; 80;<\/code><\/pre>\n\n\n\n<p>Query diatas digunakan untuk menampilkan mahasiswa yang rata-rata nilainya di atas 80. Berikut hasil dari query diatas:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-48.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"169\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-48-1024x169.png\" alt=\"Hasil query penggunaan fungsi agregat HAVING\" class=\"wp-image-61665\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-48-1024x169.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-48-300x50.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-48-768x127.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-48-370x61.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-48-270x45.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-48-570x94.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-48-740x122.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-48.png 1217w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Studi Kasus Analisis Data<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. Menghitung rata-rata Nilai per Mata Kuliah<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT mata_kuliah, AVG(nilai) AS rata_rata_nilai\nFROM nilai_mahasiswa\nGROUP BY mata_kuliah;<\/code><\/pre>\n\n\n\n<p>Query ini menampilkan rata-rata nilai tiap mata kuliah. Dari hasil tersebut, dapat dianalisis mata kuliah mana yang memiliki rata-rata tertinggi atau terendah. Berikut hasilnya:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-49.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"168\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-49-1024x168.png\" alt=\"Hasil dari rata - rata nilai per mata kuliah\" class=\"wp-image-61666\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-49-1024x168.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-49-300x49.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-49-768x126.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-49-370x61.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-49-270x44.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-49-570x94.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-49-740x122.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-49.png 1241w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">2. Menghitung 3 Mahasiswa dengan Nilai Rata-rata Tertinggi<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT mahasiswa_id, AVG(nilai) AS rata_rata_nilai\nFROM nilai_mahasiswa\nGROUP BY mahasiswa_id\nORDER BY rata_rata_nilai DESC\nLIMIT 3;<\/code><\/pre>\n\n\n\n<p>Query di atas digunakan untuk menampilkan 3 mahasiswa dengan nilai rata-rata tertinggi. Berikut hasil query diatas :<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-50.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"191\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-50-1024x191.png\" alt=\"Hail query menghitung 3 mahasiswa dengan nilai rata-rata tertinggi - belajar sql database\" class=\"wp-image-61667\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-50-1024x191.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-50-300x56.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-50-768x143.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-50-370x69.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-50-270x50.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-50-570x106.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-50-740x138.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/image-50.png 1290w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>Berguna untuk:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>menentukan mahasiswa berprestasi,<\/li>\n\n\n\n<li>pemberian beasiswa,<\/li>\n\n\n\n<li>pemetaan kualitas akademik.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Kesalahan Umum Pada Pemula<\/h2>\n\n\n\n<p>Beberapa kesalahan yang sering terjadi:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Lupa pakai GROUP BY saat menggunakan fungsi agregat.<\/li>\n\n\n\n<li>Menggunakan WHERE untuk filter hasil agregasi (seharusnya HAVING).<\/li>\n\n\n\n<li>Tidak memahami perbedaan COUNT(*) dan COUNT(kolom).<\/li>\n\n\n\n<li>Mengelompokkan data tanpa tujuan analisis yang jelas.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Kesimpulan<\/h2>\n\n\n\n<p>Fungsi agregat dan GROUP BY adalah fitur penting dalam SQL untuk merangkum dan menganalisis data secara lebih terstruktur. Dengan fungsi seperti COUNT, SUM, AVG, MIN, dan MAX, data mentah dapat diubah menjadi informasi yang berguna untuk pengambilan keputusan akademik maupun bisnis.<\/p>\n\n\n\n<p>Melalui GROUP BY, data bisa dikelompokkan berdasarkan kategori tertentu, sementara HAVING digunakan untuk memfilter hasil agregasi. Dengan memahami konsep ini, pengolahan data dalam database menjadi lebih rapi dan efektif.<\/p>\n\n\n\n<p>Demikian tutorial Belajar SQL Database Bagian 10 tentang Fungsi Agregat dan Grouping dalam SQL. Selanjutnya dalam seri belajar SQL Database bagian 11, Anda bisa belajar tentang <a href=\"https:\/\/www.rumahweb.com\/journal\/belajar-sql-database-11\/\" target=\"_blank\" rel=\"noopener\" title=\"\">JOIN<\/a>. Semoga bermanfaat!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Di seri belajar SQL database bagian 9, kita sudah belajar tentang constraint di MySQL yang berfungsi untuk menjaga agar data tetap valid dan terstruktur dengan baik di dalam tabel. Dengan constraint, database menjadi lebih aman dari kesalahan input data. Nah selanjutnya pada belajar SQL database bagian 10 kita akan beralih ke topik fungsi agregat dan [&hellip;]<\/p>\n","protected":false},"author":358,"featured_media":62184,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[2294],"tags":[2133,135,134,1440],"class_list":{"0":"post-61638","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-database","8":"tag-belajar-sql","9":"tag-database","10":"tag-mysql","11":"tag-sql"},"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/02\/banner-Belajar-SQL-Database-bagian-10.webp","jetpack_shortlink":"https:\/\/wp.me\/p8n3G7-g2a","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/61638","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/users\/358"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/comments?post=61638"}],"version-history":[{"count":12,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/61638\/revisions"}],"predecessor-version":[{"id":63431,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/61638\/revisions\/63431"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media\/62184"}],"wp:attachment":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media?parent=61638"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/categories?post=61638"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/tags?post=61638"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}