Add to Chrome
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
З допомогою якої команди можна вивести прізвища викладачів та назви предметів, які вони викладають?
SELECT student.stud_name, progress.mark FROM student INNER JOIN progress ON student.id_stud= progress. id_stud
SELECT id_subj, mark FROM progress WHERE mark> (SELECT AVG(mark) FROM progress)
SELECT AVG(mark) FROM progress GROUP BY id_stud
SELECT teacher.tch_name, subject.subj_name FROM teacher, subject WHERE teacher.id_tch= subject. id_tch
SELECT teacher.tch_name, subject.subj_name FROM teacher INNER JOIN subject ON teacher.id_tch= subject. id_tch
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!