How many services has each resident requested? List the resident id, details, and the count in descending order of the count.
return residents ;return services requested of  #1 ;return number of  #2 for each  #1 ;return resident ids of  #1 ;return details of  #1 ;return #4 ,  #5 , #3 ;return #6 sorted by #3 in descending order
['select', 'project', 'group', 'project', 'project', 'union', 'sort']