Tugas PBD

1.
select nim, nama, sex
from master_mhs
where nim like '00%' or nim like '01%' and nim like '%39010%' and tgllahir like '1-mei%' and sts_marital = "m";

2.
select count (*) jumlah_mhs
from master_mhs
where nim like '%41010%' or nim like '%39010%' and nim like '01%' or nim like '02%'

3.
select a.nim, b.nama
from histori_mhs a, master_mhs b
where a.nim = b.nim and a.nim like '02%'
order by a.nim;

4.
select a.nim, b.nama, c.kode_mk
from histori_mhs a, master_mhs b, jadwal c
where a.nim = b.nim and c.kode_mk = a.kode_mk and a.nim like '02%'
order by a.nim;