Найти все оценки для предмета Информатика.

SELECT * FROM Progress WHERE IN (SELECT Subj_ID FROM Subject WHERE Subj_NAME = 'Информатика' )
SELECT * FROM Progress WHERE Subj_ID IN (SELECT * FROM Subject WHERE Subj_NAME = 'Информатика' )
SELECT * FROM Progress WHERE Subj_ID (SELECT Subj_ID FROM Subject WHERE Subj_NAME = 'Информатика' )
SELECT * FROM Progress WHERE Subj_ID IN (SELECT Subj_ID FROM Subject WHERE Subj_NAME = 'Информатика' )
SELECT * FROM Progress WHERE Subj_ID IN (SELECT Subj_ID FROM Subject WHERE Subj_NAME = “Информатика” )

К сожалению, у нас пока нет статистики ответов на данный вопрос, но мы работаем над этим.