How to INSERT, UPDATE, and DELETE Data in SQL

14/15 INSERT INTO ... SELECT with GROUP BY

1. Introduction

2. The student table

3. The exam table

4. Review: Inserting partial data

5. Insert NULL into a column

6. UPDATE with NULL in SET

7. IS NULL in UPDATE

8. IS NULL in DELETE

9. UPDATE with conditions: AND, OR

10. DELETE with conditions: AND, OR

11. Update using a value from another column

12. Change values between columns

13. INSERT INTO ... SELECT

14. INSERT INTO ... SELECT with GROUP BY

15. Summary

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

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.

Instruction

Exercise

Need assistance?

login:
password:
Remember me on this computer

Recipient's Name:
Recipient's Email:
Your Message (Optional):

Select your platform

Sign upand join a company account!

Log in

Your registration has been successfully finished

Wrap course as a gift

Instruction

Exercise

Need assistance?