Doesnt necessarily have to be in sort order but just grouped together.
In database parlance that's not grouping, that's ordering. You want the rows with the same values to occur together.
ORDER BY is a twenty-nine-cent word for "sorting."
GROUP BY refers to the concept of finding the unique combinations of field-values and calculating statistics of some kind for each group of rows having the same values. For example, "SELECT NAME, SYSTEM_NAME, COUNT(*)...GROUP BY NAME, SYSTEM-NAME" would list each combination of these columns and the number of rows found in each one.