count(*)    keyword     max(value)
1   chicken     20
1   chicken     30
1   hamster     10
3   hamster     20

The database is this:

id  keyword     value
1   hamster     10
2   hamster     20
4   chicken     20
5   hamster     20
6   chicken     30
7   hamster     20