Selasa, 06 Maret 2012

Tugas PBD Selasa 06 maret 2012 (Ibu Nunuk)

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(*)
 from master_mhs
 where (nim like '00%' or nim like '01%') and (nim like '%41010%' or nim like '%39010%');

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

4.
 select x.nim, y.nama, x.kode_mk
 from master_mhs x, histori_mhs y
 where h.nim = m.nim and nim like '02%'
 group by x.nim, y.kode_mk
 order by x.nim asc;
 

Nama : Muhamat Soleh
NIM: 10390100039