sql, join rows

[Janthine]

Hello, hope someone can help me out here

 

I have a table,

 

 

Table Scores

 

 

First I want to join the rows on ID when the score is the same, so that in the example below ID 2 has one row.

 

 

But is it also possible to remove the score column and put the score in the different year-columns as below?

 

Thank you