CABE !!!!!

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);

Tugas PBD 1

Rahardiyan Arya Yudha (10.39010.0025)
06-03-2012

1.
select nim, nama, sex
from master_mhs
where (nim like '00%' or nim like '01%') and nim like

'%39010%' and tgl_lahir like '01-May%' and

sts_marital='M';

2.
select count(*) as "Jumlah Mahasiswa"
from master_mhs
where (nim like '01%' or nim like '02%') and (nim like

'%41010%' or nim like '%39010%');

3.
select y.nim, z.nama
from master_mhs z, histori_mhs y
where y.nim = z.nim and nim like '02%'
group by a.nim
order by a.nim;

4.
select y.nim, z.nama, y.kode_mk
from master_mhs z, histori_mhs y
where y.nim = z.nim and nim like '02%'
group by y.nim, z.kode_mk