Якою командою можна що вивести прізвища студентів та їх оцінки?

Question

Accepted Answer

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

Accepted Answer

SELECT student.stud_name, progress.mark FROM student, progress WHERE student.id_stud= progress.id_stud

Answer

SELECT AVG(mark) FROM progress GROUP BY id_stud

Answer

SELECT stud_name FROM student WHERE stip IN (1200, 1300, 1500)

Answer

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

Crowdly