

[TUGAS] Pemrograman Basis Data 1 (Selasa, 6 Maret 2012)
============================
Mata Kuliah : Pemrograman Basis Data 1
NIM : 10.39010.0057
Nama : Rizal Miftahus Salmi
Link Tugas : http://blog.stikom.edu/nunuk/2012/03/06/tugas-individu/
============================
Sesuai dengan tugas dari blog Ibu Nunuk, saya posting jawaban saya.
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 ‘%39010%’ or nim like ‘%41010%’);
3.
select a.nim, b.nama
from master_mhs b, histori_mhs a
where a.nim = b.nim and nim like ’02%’
group by a.nim
order by a.nim;
4.
select a.nim, b.nama, a.kode_mk
from master_mhs b, histori_mhs a
where a.nim = b.nim and nim like ’02%’
group by a.nim, a.kode_mk
order by a.nim;
Terimakasih. (/^_^)/