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
Inserting and updating NULLs
Conditions in UPDATE and DELETE
Using values from another column
Inserting data from a query
14. INSERT INTO ... SELECT with GROUP BY
Summary

Instruction

Great! Now try to insert data using INSERT INTO ... SELECT with GROUP BY.

Exercise

This time, the university needs a list of average results of written and oral exams in each subject (from the exam table).

The new table, report_average_scores consists of the following columns: subject, avg_written_exam_score, and avg_oral_exam_score (which are of type DECIMAL(4,2)).

Help the university insert data into the report_average_scores table.