Укажите запрос (или запросы), который выведет имена преподавателей, даты экзамена и номер аудитории.

  • SELECT (SELECT TeacherName FROM TEACHER WHERE TEACHER.TeacherId = EXAM_RESULT.TeacherId) AS TeacherName, ExamDate, ClassRoom FROM EXAM_SHEET
  • SELECT (SELECT TeacherName FROM TEACHER WHERE TEACHER.TeacherId = EXAM_SHEET.TeacherId) AS TeacherName, ExamDate, ClassRoom FROM EXAM_SHEET
  • SELECT TeacherId AS TeacherName, ExamDate, ClassRoom FROM EXAM_SHEET
  • SELECT TeacherName AS TeacherName, ExamDate, ClassRoom FROM EXAM_SHEET
  • SELECT TeacherName, ExamDate, ClassRoom FROM TEACHER WHERE TeacherId IN (SELECT TeacherId FROM FROM EXAM_SHEET)
Для просмотра статистики ответов нужно войти.