1.
Select no_order, Jumlah_order
From Order
Where Jumlah_order > 100 ;
2.
Select MAX(nilai) - MIN(nilai)
From Transkrip
3.
Select Nama_karyawan
From Department
Where Department_ID =
(Select Department_ID
From Department
Where Nama_Karyawan = "Ida") ;
4.
Select Nama_Mahasiswa
From Nilai
Where No_Mahasiswa = '434' and Nilai >
(Select AVG(Nilai)
From Nilai
Group By Nama_Mahasiswa);
0 Responses so far.
Langganan:
Posting Komentar (Atom)
Posting Komentar