Latihan PBD

1. select no_order, count(*) jumlah_order
from order
group by no_order
having count (*) > 100;


2. select mk, max ((nilai) – min (nilai))
from transkip
group by mk;


3. select nama, department_id
from employees
where department_id = (select department_id from employees where nama = ‘ida’);


4. select nama
from mk
where kode_mk = ’434′
having nilai > avg((0.3*uts)+(0.3*uas)+(0.4*tugas))
group by nama;

Tugas PDB

1. select NIM, NAMA, SEX
from MASTER_MHS
where NIM like '00%' or NIM like '01%'
and (substr (NIM, 3, 5)) = '39010'
and SRS_MARTIAL = 'M'
and TGL_LAHIR like '01-MAY%';


2. select count 
from MASTER_MHS
where (substr (NIM, 3, 5)) = '39010'
or (substr (NIM, 3, 5)) = '41010'
and NIM like '01%' or NIM like '02%'


3. select O.NIM, P.NAMA
from HISTORI_MHS O,  MASTER_MHS B
where O.NIM = P.NIM and A.NIM like '02%'
order by A.NIM;

4. select O.NIM, P.NAMA, Q.KODE_MK
from HISTORI_MHS O, MASTER_MHS P, JADWAL Q
where O.NIM = P.NIM and Q.KODE_MK = P.KODE_MK and O.NIM like '02%' 
order by P.NIM;