50 Query Series-13th query: The "SC" table in the "cotyledons" teacher taught the results of the class are changed to the average performance of this course;

UPDATETblscoreSETTblscore. Score=(--Here we start with the average of cotyledons.SELECT AVG(TT.AA) from (SELECTTblscore. Score AA fromTblscoreWHERETblscore. CourseID=( SELECTTblcourse. CourseID fromTblcourseWHERETblcourse. CourseID=(SELECTTblteacher. Teaid fromTblteacherWHERETblteacher. Teaname='cotyledons')) TT--figure out the average of cotyledons courses    ) WHERETblscore. CourseID=  (SELECTTblcourse. CourseID fromTblcourseWHERETblcourse. CourseID=(SELECTTblteacher. Teaid fromTblteacherWHERETblteacher. Teaname='cotyledons'))--cotyledons The ID of the class

The wording of the answer:

Select *  intoSc fromTblscoreGo UpdateScSetScore=(Select AVG(score) fromTblscore S1WhereS1. CourseID=SC. CourseID)WhereCourseIDinch   (SelectCourseID fromTblcourse CSINNER JOINTblteacher TC onCs. Teaid=Tc. TeaidWHERETeaname='cotyledons')

50 Query Series-13th query: The "SC" table in the "cotyledons" teacher taught the results of the class are changed to the average performance of this course;