I have attached the DDL for the database.

I do not have an example of the output data, but I'll see if I can explain it a little easier now that the DDL has been created.

We need to do a query for all duplicate studentID values. Once found, we need to then average all focus1, controlling1, reading1, etc. values for those duplicate studentIDs. Once the averages are done we then need to spit out the studentName, StudentID, focus1Average, controlling1Average, reading1Average, etc. to a csv file. I believe the export to a csv is easy after the rest of the query is done since I can just right click and save as a csv. It's the query that I am struggling with.