Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

How to INSERT, UPDATE, and DELETE Data in SQL

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.