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;