[TUGAS] - PBD - 1

NAMA : YUSUF BACHTIAR
NIM  : 10.39010.0034


1. SELECT NIM, NAMA, SEX
FROM MASTER_MHS
where NIM like '00%' or nim like '01%'
AND substr (NIM 3, 5) = '39010'
AND TGL_LAHIR like '01-MAY%'
AND SRS_MARTIAL = 'M';

2. SELECT COUNT (*) "JUMLAH MAHASISWA"
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 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;


atau bisa di download disini...