Question

Mohon bantuannya MYSQL dengan perintah Select, soal pada gambar ... jujur gurunya cukup sulit dimengerti disaat menjelaskan

mohon bantuannya

Answer 1

1. Select * from karyawan

Answer 2

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