How do I make the most efficient statement in MySQL?

SItuation:





Table containing many rows that each include a GameID and a Unix Timestamp (for when the game is played). What's the most efficient way to select all rows after a certain date (I know how to do that part) that orders by the GameID's that are most prevalant for that time period (not sure)? Can this be done in a single statement?|||Not sure about this...but try





SELECT * FROM games WHERE date %26gt; startdate ORDER BY COUNT(gameid)