I'm working with MySQL, and I have the following schema:

```
id school          round score win loss tie
2  My School Name  1     10    1   0    0
3  My School Name  2     20    0   1    0
4  My School Name  3     30    1   0    0
5  My School Name  4     40    1   0    0
6  My School Name  5     50    1   0    0
7  My School Name  6     60    0   0    1

```

And I need the following output, grouped by school name

```
School         Round1 Round2 Round3 Round4 Round5 Round6 wins losses ties
My School Name 10     20     30     40     50     60     4    1      1

```

So far I feel like I can use `GROUP BY School` and `SUM(win) as wins` to get most of the functionality out of it. The hard part, though, is to get those `Round_` fields.

Does anyone know how to do this? Thanks in advance, any help would be much appreciated!

Edit: to clarify, I know I have 10 rounds exactly.