required query

Hi

I have the table with following details.

 EMployee details
==================

s.no   empid  empname        comments             score

1           1            abc                     "hi man"              1

2           1             bbc                     "hi boy"              4

3            1             bbc                     "hi girl"              3

4             2             def                     "come here"     -2

5            2              ggf                     "go there"            4

6            2               dgf                       "go where"       -1


Here i have empid with  1 and 2  and go on... now for each and every employee

i want to get his last comment and Average of his score details and his least
score for which comment he got.


 for eg. i have to get as below for above table


s.no      empid            empname               comments             Averagescore     Least Score

3                 1                   bbc                          "hi girl"                       8/3= 2.666            1
 
6                  2                  dgf                            "go where"                +1/3= 0.333         -1

can you please guide me the query how to get it.