It's Autumn! Prices fall like leaves! - hours only!Up to 80% off on all courses and bundles.-Close
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.