Tugas PBD
1.
Select nim,nama,sex
From master_mhs
Where nim like ‘00%’ or nim like ‘01%’
And substr(nim,3,5)=’39010’
And sts_marital=’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 x.nim,y.nama
From histori_mhs x, master_mhs y
Where x.nim=y.nim
And x.nimlike’02%’
Order by x. nim;
4.
Select x.nim,y.nama,z.kode_mk
From histori_mhs x, master_mhs y,jadwal z
Where x.nim=y.nim
And z.kode_mk=x.kode_mk
And x.nimlike’02%’
Order by x.nim;
nim :10390100056
