Tugas Pemrograman Basis Data1 (2)

Nama : Adam Bagus Pujianto
NIM : 10.39010.0054


1.select no_order,jumlah_order
from order
where jumlah_order>100;

2.select matakuliah, max(nilai)-min(nilai)
from transkrip;

3.select nama_karyawan
from employees
where department_id= (select department_id from employees where nama_karyawan=’ida’);

4.select nm_mahasiswa
from nilai
where no_peserta=’434′ And nilai>avg((0.3*uts)+ (0.3*uas)+(0.4*tugas));