I want to select the highest `won` from my last 50 rows.
But why is that not working? 

I found that in other questions but i dont know why that doesnt work for me?

This is my query with that what i tried

```
SELECT max(won) from games WHERE game ='case' ORDER BY id DESC LIMIT 50

```

I want the highest won from the last 50 rows by DESC so i order by id DESC.

But than i get the highest won of everything won, not only from the last 50 rows.