Jawaban TP Modul 3 Basis Data CommonLabz

4

SELECT NO_FORMULIR,TGL_PENGEMBALIAN FROM FORMULIR F
WHERE EXISTS
(SELECT NAMA FROM FORMULIR_STORE
WHERE ID_TEMPAT=F.ID_TEMPAT
AND FORMULIR_STORE.NAMA LIKE'%JAKARTA%');

5

CREATE TABLE calonPeserta AS
SELECT SUBSTR(Calon_Peserta.Nama,2) "NAMA_PESERTA", Sekolah.Nama "NAMA_SEKOLAH"
FROM Calon_Peserta, Sekolah
WHERE Sekolah.ID_Sekolah=Calon_Peserta.ID_Sekolah
AND Calon_Peserta.Nama LIKE '%i';

6

SELECT nvl(jns_kelamin,'Total:') GENDER,
ROUND(MONTHS_BETWEEN(SYSDATE,tgl_lahir)/12,0) UMUR,COUNT(*) Jumlah
FROM calon_peserta
GROUP BY CUBE(jns_kelamin,ROUND(MONTHS_BETWEEN(SYSDATE,tgl_lahir)/12,0))
ORDER BY jns_kelamin,umur;