vincentiadk
1. SELECT * FROM Karyawan 2. SELECT NIP, Nama FROM karyawan ORDER BY Nama ASC, NIP DESC 3. SELECT nama, alamat FROM karyawan WHERE ... 4. SELECT COUNT(*) FROM Karyawan 5. SELECT pendidikan, count(pendidikan) FROM karyawan Group By pendidikan 6. SELECT MAX(Nilai) FROM nilai WHERE kdkriteria=1 7. SELECT NIP, AVG(Nilai) FROM nilai WHERE (kdkriteria=1 OR kdkriteria=3 OR kdkriteria=7 ) AND (AVG(NILAI) > 3) GROUP BY NIP ORDER BY NIP DESC
2. SELECT NIP, Nama FROM karyawan ORDER BY Nama ASC, NIP DESC
3. SELECT nama, alamat FROM karyawan WHERE ...
4. SELECT COUNT(*) FROM Karyawan
5. SELECT pendidikan, count(pendidikan) FROM karyawan Group By pendidikan
6. SELECT MAX(Nilai) FROM nilai WHERE kdkriteria=1
7. SELECT NIP, AVG(Nilai) FROM nilai WHERE (kdkriteria=1 OR kdkriteria=3 OR kdkriteria=7 ) AND (AVG(NILAI) > 3) GROUP BY NIP ORDER BY NIP DESC