All fields in Group By must be aggregated. If you have a field whose records all have only one value, just use max(fieldname) and the largest value will appear -- in this...