З допомогою якої команди можна вивести прізвища викладачів та назви предметів, які вони викладають?

Question

Answer

SELECT student.stud_name, progress.mark FROM student INNER JOIN progress ON student.id_stud= progress. id_stud

Answer

SELECT id_subj, mark FROM progress WHERE mark> (SELECT AVG(mark) FROM progress)

Answer

SELECT AVG(mark) FROM progress GROUP BY id_stud

Answer

SELECT teacher.tch_name, subject.subj_name FROM teacher, subject WHERE teacher.id_tch= subject. id_tch

Answer

SELECT teacher.tch_name, subject.subj_name FROM teacher INNER JOIN subject ON teacher.id_tch= subject. id_tch

Crowdly