select nim,
count (nilai) as cacah_nilai,
sum (nilai) as total_nilai
from nilai
where nim = '201591002'
group by nim
UNION
select nim,
count (nilai) as cacah_nilai,
sum (nilai) as total_nilai
from nilai
where nim = '201591005'
group by nim
select *from nilai
dan berikut ini adalah hasilnya (screenshoot)
Tidak ada komentar:
Posting Komentar