ALJABAR RELATIONAL

SELECT nim,

COUNT (nilai) AS nilai_muncul,

SUM (nilai) AS total_nilai

FROM nilai1

WHERE nim='201291002'

group by nim;

SELECT nim,

COUNT (nilai) AS nilai_muncul,

SUM (nilai) AS total_nilai

FROM nilai1

WHERE nim='201291005'

group by nim;

SELECT nim,

COUNT (nilai) AS nilai_muncul,

SUM (nilai) AS total_nilai

FROM nilai1

WHERE nim='201291002'

group by nim

UNION

SELECT nim,

COUNT (nilai) AS nilai_muncul,

SUM (nilai) AS total_nilai

FROM nilai1

WHERE nim='201291005'

group by nim;

SELECT nim,

COUNT (nilai) AS nilai_muncul,

SUM (nilai) AS total_nilai

FROM nilai1

WHERE nim='201291002'

group by nim

INTERSECT

SELECT nim,

COUNT (nilai) AS nilai_muncul,

SUM (nilai) AS total_nilai

FROM nilai1

WHERE nim='201291005'

group by nim;

 

DISTICNT

Tampilkan nilai berdasarkan kode matakuliah, dengan menghilangkan data yang bernilai ganda

JOIN

       Dengan menggunakan sintax joint tampilkan nama matakuliah, SKS, dan nilai

       Tampilkan nama mahasiswa, kota, nilai

       Tampilkan nama matakuliah, nama mahasiswa, dan nilai

    SELECT nama_mk, sks, nilai

FROM matakuliah JOIN nilai1

ON matakuliah.kode_mk=nilai1.kode_mk;

  

   SELECT nama, kota, nilai

FROM mahasiswa JOIN nilai1

ON mahasiswa.nim=nilai1.nim;

      

       

    

    select nama, nama_MK, nilai
from mahasiswa join nilai1 on mahasiswa.nim = nilai1.nim
join matakuliah1 on matakuliah1.kode_MK = nilai1.kode_MK

CROSS PRODUCT