devide and summarize sql result (all)

["Janek Sendrowski" <janek12@xxxxxx>]

Hi,
 
My sql query results sth. like this:
 
user percentage
franz 78%
smith 98%
franz 81%
jason 79%

smith 89%

smith 85%

smith 99%

 

Now I'd like to summarize the percentages oder every user like this.

smith

2 matches 95-100%

2 matches 85-95%

0 mathes 75-85%

 

franz

0 mathes 95-100%

...

 

Hope there is someone who can help me

 

Janek Sendrowksi