Query 2

1. SELECT KBM.NIM,Mahasiswa.Nama,KBM.Nilai
FROM KBM, Mahasiswa
WHERE KBM.NIM=Mahasiswa.NIM

2. SELECT Mahasiswa.Nama,MataKuliah.Nama,KBM.Nilai
FROM Mahasiswa,MataKuliah,KBM
WHERE KBM.NIM=Mahasiswa.NIM AND KBM.KodeMK=MataKuliah.KodeMK

3. SELECT NIM,Nama, IIF(Nama="Budi","laki-laki","perempuan") AS JenisKelamin
FROM Mahasiswa

4. SELECT IIf(DATEDIFF("m",TanggalLahir,Now()) > 11,DATEDIFF("yyyy",TanggalLahir,Now()),"belum genap 1 tahun")
FROM Mahasiswa;