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;