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));

READ MORE - Tugas Pemrograman Basis Data1 (2)

Tugas Pemrograman Basis Data1

Nama : Adam Bagus Pujianto
NIM : 10.39010.0054


1. SELECT nim, nama, sex
FROM master_mhs
WHERE (nim like ’00%’ or nim like ’01%’) and nim like ‘%39010%’ and tgl_lahir like ’01-May%’ and sts_marital = ‘M’ ;

2. SELECT count(*)
FROM master_mhs
WHERE (nim like ’00%’ or nim like ’01%’) and (nim like ‘%41010%’ or nim like ‘%39010%’) ;

3. SELECT m.nim, m.nama
FROM master_mhs m, history_mhs h
WHERE h.nim = m.nim and nim like ’02%’
GROUP BY m.nim
ORDER BY m.nim asc ;

4. SELECT h.nim, m.nama, h.kode_mk
FROM master_mhs m, history_mhs h
where h.nim = m.nim and nim like ’02%’
GROUP BY m.nim, h.kode_mk
ORDER BY m.nim asc;

READ MORE - Tugas Pemrograman Basis Data1