RSS
Write some words about you and your blog here

Jawaban Tugas PBD1

1.
SELECT NIM, NAMA, SEX
FROM MASTER_MHS
WHERE NIM LIKE '00%' AND NIM LIKE '01%'
AND NIM LIKE '__39010%'
AND TGL_LAHIR =(DD-MM(01-05))
AND STS_MARITAI = M;


2.
SELECT COUNT (NAMA)
FROM MASTER_MHS
WHERE NIM LIKE '__41010%' AND NIM LIKE '__39010%'
AND NIM LIKE '00%' AND NIM LIKE '01%';


3.
SELECT B.NIM, A.NAMA
FROM MASTER_MHS A, HISTORI_MHS B
WHERE A.NIM=B.NIM
AND NIM LIKE '02%'
ORDER BY B.NIM;


4.
SELECT B.NIM, A.NAMA, C.KODE_MK, C.KELAS, C.HARI, C.MULAI, C.SELESAI
FROM MASTER_MHS A, HISTORI_MHS B, JADWAL C
WHERE A.NIM=B.NIM AND B.KODE_MK=C.KODE_MK
AND NIM LIKE '02%'
ORDER BY B.NIM;


Nama : Cahyo Nugroho
NIM : 10.39010.0007
Prodi : DIII MI