Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
3. The exam table
Inserting and updating NULLs
Conditions in UPDATE and DELETE
Using values from another column
Inserting data from a query


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


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.