Kickstart 2020 with new opportunities! - 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
Updating the list of columns in one query
Using values from another column
Return rows in INSERT, UPDATE, DELETE
Summary

Instruction

The other 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 exam 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).

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