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;