Introduction
3. The Exam table
Inserting and updating NULLs
Conditions in UPDATE and DELETE
Using values from another column
Return rows in INSERT, UPDATE, DELETE
Summary

Instruction

The last table, Exam, contains information about all the exams taken by each student at the university.

Exercise

Select all columns from the Exam table. Each exam in the table:

  • Has an identifier (Id).
  • Corresponds to a student (StudentId).
  • Has a related subject (Subject).
  • Has a date (WrittenExamDate and OralExamDate).
  • Has a score (WrittenExamScore and OralExamScore).
  • Has a date when it was scored by the instructor (WrittenScoreDate and OralScoreDate).

Subjects can have a written exam only, an oral exam only, or both written and oral exams.