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.