Your GROUP BY will do nothing useful: since
is an incrementing number (and probably an IDENTITY column) including it in the GROUP BY list just menas that each group contains a single row.
Have a look here: SQL GROUP By and the "Column 'name' is invalid in the select list because..." error
] and think about exactly what you are trying to aggregate: if what you want is a count of items which have an ALLSTS value of 20 then make it part of the WHERE clause.
If you don't, then I have no idea exactly what you are trying to achieve ...
Remember that we can't see your screen, access your HDD, or read your mind - we only get exactly what you type to work with.