I'm trying to make a statement that selects rows during a certain time period (working fine) and groups them by a certain category and displays them in the order of how many of each of that category. For example:

SELECT *
FROM `gameplays`
WHERE time >=1197442800
GROUP BY `gid`

I would like this statement to also return the results in the order of how many GID's for each grouping...Is that possible?