Contoh soal:1.Tampilkan semua data (nama) mahasiswa yg mengambil jadwal matakuliah Basis DataJawab:Menggunakan : tblmhs,tblnilai dan tbljadwal.Koding yg digunakan : Select tblmhs.nama, tblmkul.matakuliah from tblmhs, tblmkul where tblmkul.matakuliah = Basis Data;Screennya :

2. Tampilkan data dg susunan : NIM,Nama,KDMK,Matakuliah,uts,uas,totalDengan mencai nilai total >65Kodingnya : mysql> select tblmhs.nim, tblmhs.nama, tblmkul.kdmk, tblmkul.matakuliah, tblnilai.kdmk, tblnilai.nilai_uts, tblnilai.nilai_uas, (tblnilai.nilai_uts + tblnilai.nilai_uas) as Total from tblmhs,tblmkul,tblnilai where ((tblnilai.nilai_uts + tblnilai.nilai_uas) > 65) AND tblmhs.nim = tblnilai.nim AND tblmkul.kdmk = tblnilai.kdmk;Screen nya :

3.Tampilkan data dosen deg NID :01Tampilan : NID, Nama,Hari, Ruang,mata kuliah,Kelas, SKSKuerinya : mysql> select tbldosen.nid, tbldosen.Nama, tblmkul.kdmk, tblmkul.matakuliah, tbljadwal.Kelas,tbljadwal.Hari,tbljadwal.Jam,tbljadwal.Ruang from tbldosen,tblmkul,tbljadwal where tbldosen.nid = "DS001" and tbldosen.nid = tbljadwal.nid and tblmkul.kdmk=tbljadwal.kdmk;kuerinya :

4.Tampilkan jadwal kuliah kelas =K01.Tampilan :NIM,Nama,KDMK,Kelas,Hari,Jam,Ruang,Kuerinya : mysql> select tbljadwal.nid, tbldosen.Nama, tbljadwal.kdmk, tbljadwal.Kelas, tbljadwal.hari, tbljadwal.Jam, tbljadwal.ruang from tbljadwal,tbldosen,tblmkul where tbljadwal.nid = tbldosen.nid and tbljadwal.kdmk = tblmkul.kdmk ="K01";screennya :

5.Tampilkan jadwal kuliah basis dataTampilan : KDMK,matakuliah,Nama,Kelas,Jam,RuangKodingnya:select tbljadwal.KDMK, tblmkul.matakuliah, tbldosen.nama, tbljadwal.kelas, tbljadwal.jam, tbljadwal.Ruang from tbljadwal, tblmkul, tbldosen where tblmkul.kdmk = tbljadwal.kdmk and tbldosen.nid = tbljadwal.nid and tblmkul.matakuliah = "Basis Data";scrreennya :

6. screen tables all :

7. describe all tables structure :