1.
select nim, nama, sex from master_mhs
where substr(2,1) = ('00','01') and tgl_lahir like '01-05' and sts_marital = upper('M');
2.
select count (nim) from master_mhs
where nim = ('%41010','39010') and nim = ('%01','%02');
3.
select a.nim, a.nama from a.master_mhs b.histori_mhs
where a.nim = b.nim and nim like ('02%')
order by a.nim
