Mar 6, 2012 - Tugas Kuliah    No Comments

[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. (/^_^)/

Got anything to say? Go ahead and leave a comment!