[TUGAS] PBD 1

Tugas PBD 1

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 h.nim, m.nama
from master_mhs m, histori_mhs h
where h.nim = m.nim and nim like ‘02%’
group by m.nim
order by m.nim ASC;

4.
select h.nim, m.nama, h.kode_mk
from master_mhs m, histori_mhs h
where h.nim = m.nim and nim like ‘02%’
group by m.nim, h.kode_mk
order by m.nim ASC;
by…

Nama : Novan Andrianto

NIM : 10390100048

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s