Mar 18, 2012 - Tugas Kuliah    No Comments

[LATIHAN] Pemrograman Basis Data 1 (Sabtu, 17 Maret 2012)

============================
Mata Kuliah : Pemrograman Basis Data 1
NIM : 10.39010.0057
Nama : Rizal Miftahus Salmi
Link Latihan : http://blog.stikom.edu/nunuk/2012/03/17/latihan/
============================

Sesuai dengan latihan dari blog Ibu Nunuk, saya posting jawaban saya.

1.
SELECT no_order, count(*) jumlah_order
FROM order
GROUP BY no_order
HAVING count(*) > 100;

2.
SELECT kode_mk, max(nilai)-min(nilai)
FROM transkrip
GROUP BY kode_mk;

3.
SELECT department_id, nama
FROM employees
WHERE department_id =
(SELECT department_id
FROM employees
WHERE nama = ‘ida’);

4.
SELECT a.nama
FROM master_mhs a, histori_mhs b
WHERE a.nim = b.nim and b.kode_mk = ’434′ and ((0.3*n_uts)+(0.3*n_uas)+(0.4*n_tugas)) > AVG((0.3*n_uts)+(0.3*n_uas)+(0.4*n_tugas));

Terimakasih. (/^_^)/

Got anything to say? Go ahead and leave a comment!