Fungsi agregat untuk laporan putri nur lestari

Juni 20, 2026
By Putri Nurlestari

Tantangan 1

Ketik

SELECT SUM (total) AS total_pendapatan FROM transaksi WHERE status_bayar = ‘lunas’ ;

Tantangan 2

Ketik

SELECT status bayar, COUNT (*) AS jumlah_transaksi FROM transaksi GROUP BY status_bayar ;