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

  

JOINT 

       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;