Pengantar Bahasa Query:UTS 2

sudo mysql -u root

CREATE DATABASE mustain;

use mustain;

CREATE TABLE nilai ( npm char(15), nama char(30), kelas char(10), nilai1 real, nilai2 real, nilai3 real );

INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.022','AGUS PUDJIONO','KBS-04.2','85','70','85');

INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.023','DHAMELIA MARTA SIWI','KBP-04.1','65','60','85');

INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.028','PERTIWI SARI','KBP-04.1','70','85','90');

INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.030','NGATINI','KBS-04.2','90','90','85');

INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.037','NUR BADRIYAH','KBS-04.2','95','90','85');

INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.039','NUR CAHYO NINGSIH','KBP-04.1','75','75','85');

INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.043','FITRIANTI','KBS-04.1','65','50','59');

INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.046','AGUSTINA VIRYANTI','KBS-04.2','80','80','70');

INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.056','NOVI ASMININGRUM','KBP-04.2','48','50','65');

INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.060','FRANGKY YOHANES TORAR','KBP-04.1','60','90','50');

INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.909','EKA MADYAWATI','KBS-04.2','75','70','70');

INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.988','NIKMAH WATI','KBS-04.1','75','50','50');

• Memperlihatkan data yang sudah di input

SELECT * FROM nilai