在SQL中将多行组合成单行，并使用单独的列

I'm having the following table structure and the expected output is listed below how to achieve the resultI'm having the following table structure and th