除了不使用嵌入式SQL查询

I'm having this problem, and it really grinds my gears, because I really cannot find a solution. I'm working in SQL Server Management Studio. Here, I select distinct data and the average of another column's values for each distinct data, like this:I'm having this problem, and it really grinds m