Sign in

Search for:

Kontak
Register
Login

Search for:

Kuis Filter, Sorting dan Agregasi Data

0% Complete

0/0 Steps

Kuis 1 of 0

Kuis Filter, Sorting dan Agregasi Data

Garda Dafi 13/05/2025

Time limit: 0

Kuis Summary

0 of 5 Pertanyaan completed

Questions:

Information

You have already completed the kuis before. Hence you can not start it again.

Kuis is loading…

You must sign in or sign up to start the kuis.

You must first complete the following:

Results

Kuis complete. Results are being recorded.

Results

0 of 5 Pertanyaan answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

1
2
3
4
5

Current
Review
Answered
Correct
Incorrect

Pertanyaan 1 of 5

1. Question
Apa perintah SQL pada tabel buku yang menampilkan kode, judul dan harga buku yg memiliki kategori “CA01” (Pemrograman)
- SELECT kode, judul, harga from buku WHERE category_id = CA01
- SELECT kode, judul, harga from buku WHERE category_id >= “CA01”
- SELECT kode, judul, harga from buku WHERE category_id = “CA01”
- SELECT kode, judul, harga from buku WHERE category_id EQUAL “CA01”
Correct

Incorrect
Pertanyaan 2 of 5

2. Question
Apa perintah SQL pada tabel buku yang menampilkan seluruh buku yang diurutkan berdasarkan harga tertinggi?
- SELECT * FROM buku GROUP BY harga
- SELECT * FROM buku GROUP BY harga DESC
- SELECT * FROM buku ORDER BY harga ASC
- SELECT * FROM buku ORDER BY harga DESC
Correct

Incorrect
Pertanyaan 3 of 5

3. Question
Buatlah perintah SQL yang berfungsi untuk menghitung total penjualan buku dari masing-masing KODE_BUKU pada tabel penjualan
- SELECT kode_buku, COUNT(kode_buku) FROM penjualan GROUP BY kode_buku
- SELECT kode_buku, SUM(kode_buku) FROM penjualan GROUP BY kode_buku
- SELECT kode_buku, COUNT(kode_buku) FROM penjualan ORDER BY kode_buku
- SELECT kode_buku, SUM(kode_buku) FROM penjualan ORDER BY kode_buku
Correct

Incorrect
Pertanyaan 4 of 5

4. Question
Buatlah perintah SQL yang berfungsi untuk menghitung rata-rata jumlah buku dalam setiap pembelian dari masing-masing KODE_BUKU pada tabel penjualan
- SELECT kode_buku, AVG(jumlah) FROM penjualan GROUP BY kode_buku
- SELECT kode_buku, AVG(jumlah) FROM penjualan GROUP BY jumlah
- SELECT kode_buku, AVG(jumlah) FROM penjualan ORDER BY kode_buku
- SELECT kode_buku, AVG(jumlah) FROM penjualan ORDER BY jumlah
Correct

Incorrect
Pertanyaan 5 of 5

5. Question
Buatlah perintah SQL yang berfungsi untuk menghitung seluruh jumlah buku yang sudah terjual pada tabel penjualan dan diurutkan dari yang terkecil
- SELECT COUNT(jumlah) as total FROM penjualan ORDER BY total ASC
- SELECT COUNT(jumlah) as total FROM penjualan ORDER BY total DESC
- SELECT SUM(jumlah) as total FROM penjualan ORDER BY total ASC
- SELECT SUM(jumlah) as total FROM penjualan ORDER BY total DESC
Correct

Incorrect

Report

There was a problem reporting this post.

Harassment Harassment or bullying behavior

Inappropriate Contains mature or sensitive content

Misinformation Contains misleading or false information

Offensive Contains abusive or derogatory content

Suspicious Contains spam, fake content or potential malware

Other

Report note

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

See blocked member's posts
Mention this member in posts
Invite this member to groups
Message this member
Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .