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

Question

Answer

SELECT (SELECT TeacherName FROM TEACHER WHERE  
  TEACHER.TeacherId = EXAM_RESULT.TeacherId) AS  
 TeacherName, ExamDate, ClassRoom FROM EXAM_SHEET

Answer

SELECT (SELECT TeacherName FROM TEACHER WHERE  
  TEACHER.TeacherId = EXAM_SHEET.TeacherId) AS  
 TeacherName, ExamDate, ClassRoom FROM EXAM_SHEET

Answer

SELECT TeacherName  AS TeacherName, ExamDate, ClassRoom FROM EXAM_SHEET

Answer

SELECT TeacherId AS TeacherName, ExamDate, ClassRoom FROM EXAM_SHEET

Answer

SELECT TeacherName,  ExamDate, ClassRoom FROM TEACHER WHERE  
  TeacherId IN (SELECT TeacherId FROM FROM EXAM_SHEET)

Crowdly