v create View vnilai as
Select
kuliah.nim,nama_mhs,kode_mk,sks,smt,tgs,quis,uts,uas from kuliah;
v create
View vskor as
Select
*,(0.15*tgs)+(0.15*quis)+(0.30*uts)+(0.40*uas)as skor from vnilai;
v .craete View vnh as
Select *, case
When skor>=86
then ‘A’
When skor>=70 then ‘B’
When
skor>=56then...
