Scribd
Upload
4 views2 pages

SQL Queries for Student Data Management

The document contains a series of SQL queries for a database related to students, teachers, and grades. It includes SELECT statements to retrieve data based on specific conditions, as well as INSERT statements to add records to the 'mengajar' and 'tb_nilai' tables. The queries focus on filtering male students with scores below 70 and inserting various teaching assignments and student grades.

Uploaded by

Yohan Kim
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views2 pages

SQL Queries for Student Data Management

The document contains a series of SQL queries for a database related to students, teachers, and grades. It includes SELECT statements to retrieve data based on specific conditions, as well as INSERT statements to add records to the 'mengajar' and 'tb_nilai' tables. The queries focus on filtering male students with scores below 70 and inserting various teaching assignments and student grades.

Uploaded by

Yohan Kim
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

1 SELECT tb_siswa.*, tb_nilai.

* FROM tb_siswa JOIN tb_nilai WHERE jk = 'Laki-Laki' AND akhir <


'70'

2 SELECT * FROM tb_guru WHERE nama_guru LIKE 'A%' AND alamat='Samarinda'

3 INSERT INTO `mengajar` (`id_mengajar`, `id_kelas`, `id_guru`, `id_jurusan`, `id_mapel`)


VALUES (NULL, '9', '7', '3', '2')

4 INSERT INTO `mengajar` (`id_mengajar`, `id_kelas`, `id_guru`, `id_jurusan`, `id_mapel`)


VALUES (NULL, '9', '7', '3', '2'), (NULL, '9', '7', '3', '5')
5 INSERT INTO `mengajar` (`id_mengajar`, `id_kelas`, `id_guru`, `id_jurusan`, `id_mapel`)
VALUES (NULL, '9', '7', '3', '2'), (NULL, '10', '7', '3', '2')

6 INSERT INTO `mengajar` (`id_mengajar`, `id_kelas`, `id_guru`, `id_jurusan`, `id_mapel`)


VALUES (NULL, '9', '7', '3', '2'), (NULL, '9', '10', '3', '2')

7 INSERT INTO `mengajar` (`id_mengajar`, `id_kelas`, `id_guru`, `id_jurusan`, `id_mapel`)


VALUES (NULL, '9', '7', '3', '2'), (NULL, '9', '7', '4', '2')

8 INSERT INTO `tb_nilai` (`id_nilai`, `id_mapel`, `id_jurusan`, `id_siswa`, `id_guru`, `id_kelas`,


`nilai_tugas`, `nilai_uts`, `nilai_uas`, `nilai_akhir`) VALUES (NULL, '2', '3', '7', '7', '9', '87', '98',
'87', '88')

9
10 INSERT INTO `tb_nilai` (`id_nilai`, `id_mapel`, `id_jurusan`, `id_siswa`, `id_guru`, `id_kelas`,
`nilai_tugas`, `nilai_uts`, `nilai_uas`, `nilai_akhir`) VALUES (NULL, '2', '1', '7', '6', '6', '44', '23',
'64', '87'), (NULL, '2', '1', '7', '6', '8', '46', '98', '98', '77')

11

You might also like