Buat Latihan Dirumah , hahahhaha

Create database Dilan_Deswara

Create table Tabel_mahasiswa (Nim char (12)not null,Nama char (12)not null,Tlahir char(7)not null,IPK char(3)not null,kode_PS char (2)not null);

insert into tabel_mahasiswa values ("420090001","Hendra","Bandung","3","TI");
insert into tabel_mahasiswa values ("420100001","Aditya","Cimahi","2.7","SI");
insert into tabel_mahasiswa values ("420100002","Sabrina","Bandung","4","MN");
insert into tabel_mahasiswa values ("420110001","Tita","Jakarta","3.5","TI");




Create table Tabel_Prodi (Kode_PS char (2)not null,nama_Prodi char (19)not null)

Insert into tabel_prodi values ("TI","Tekhnik Informatika");
Insert into tabel_prodi values ("SI","Sistem Informasi");
Insert into tabel_prodi values ("MN ","Manajemen");
Insert into tabel_prodi values ("AK","Akuntansi");

Nomer 05
Update Tabel_mahasiswa set IPK="3.5"Where NIM="420090001"

nomer 04
insert into tabel_mahasiswa values ("420010002","Dewi","","","")
insert into tabel_mahasiswa values ("420120001","Dewi","","","")
Update Tabel_mahasiswa set nama="Jaka"where NIM="420090001")

nomer 03
Select nama , AVG (IPK) as rerata_IPK_per_PS
from tabel_mahasiswa
group by kode_PS
having AVG (IPK)>=3;

nomer 02
Select Kode_PS,AvG(IPK) as rerata_IPK_Per_PS
From tabel_Mahasiswa
group by Kode_PS

Nomer01
select NIM, Nama from tabel_mahasiswa where KoDe_PS = "TI" or KoDe_PS = "SI"
order by NIM