SELECT NIS, KELAS FROM NILAI WHERE NILAI_ANGKA > 50 AND KODE_MAPEL = 'BHS'

SELECT * FROM SISWA WHERE jenis_kel = 'P' AND tempat_alamat = 'Jogja' OR alamat = 'Jogja'

SELECT nis FROM NILAI

SELECT kode_mapel FROM NILAI where thn_ajaran = '2014/2015' AND semester = 'Genap'

SELECT TOP 5 nis FROM NILAI WHERE kelas = '9A' AND kode_mapel = 'BHS' ORDER BY nilai_angka DESC

////

SELECT COUNT (DISTINCT(kode_mapel) FROM NILAI WHERE NIP = 'G19020340'

SELECT COUNT (DISTINCT(jenis_kel) FROM SISWA WHERE NAMA LIKE '_A_A%'

SELECT AVG (nilai_angka) FROM NILAI WHERE kelas = '9A' AND thn_ajaran = '2014/2015' AND semester = 'Ganjil'

SELECT TOP 1 nis, kelas FROM NILAI where kode_mapel = 'BHS'

SELECT nis, SUM(nilai_angka) FROM NILAI GROUP BY nis