Snatch any course you want for just \$15! Go to “Courses” and find a course ↓
Introduction
3. The exam table
Inserting and updating NULLs
Conditions in UPDATE and DELETE
Using values from another column
Inserting data from a query
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 (student_id).
• Has a related subject (subject).
• Has a date (written_exam_date and oral_exam_date).
• Has a score (written_exam_score and oral_exam_score).
• Has a date when it was scored by the instructor (written_score_date and oral_score_date).

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