sql - get the average of data in sqlite android -

i wanted following query executed,

  string selectquery = "select  max(score),name " + table_score                         +" group name"; 

i output random values. wanted data maximum values least. please let me know, how write query.

actually wanted data maximum values least

you mean order max min value? try this:

  select sum(score), name      mytable group name order sum(score) desc; 

see sqlfiddle

so query should this:

string selectquery = "select sum(score), name " + table_score                         +" group name order sum(score) desc";