Introduction
Quiz
13. INSERT INTO with CTE
Summary

Instruction

Perfect! How about a slightly more complicated example with INSERT INTO?

Exercise

We've created another table called ProjectWorktime. It has the following columns: ProjectId and AvgWorktime.

Your task is to use the table Allocation and insert the average number of hours spent on each project into the new table ProjectWorktime. Each time, insert the ProjectId and the average HoursSpent. Additionally, do not insert any data for ProjectId = 1.