title: get min and max for a column plus all row data
body: <pre><code>CREATE TABLE users (
      users_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
      first_name VARCHAR( 20 ) NOT NULL,
      last_name VARCHAR( 40 ) NOT NULL,
      email VARCHAR( 60 ) NOT NULL,
      password CHAR( 40 ) NOT NULL,
      PRIMARY KEY ( users_id )
  );
  
  CREATE TABLE games (
      games_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
      locations_id MEDIUMINT UNSIGNED NOT NULL
      PRIMARY KEY (games_id )
  );
  
  CREATE TABLE games_users (
      users_id MEDIUMINT UNSIGNED NOT NULL,
      games_id MEDIUMINT UNSIGNED NOT NULL,
      score MEDIUMINT UNSIGNED NOT NULL,
      created DATETIME NOT NULL,
      last_updated DATETIME NOT NULL,
      PRIMARY KEY ( games_id, users_id )
  );
  </code></pre>
  
  <p>With the above tables, each game is between 2 users, so games_users has 2 rows for each game, one for each player, the winner will have the highest score (yes really!).</p>
  
  <p>I want a single row per game, I can get the winning and losing score (using the query below), but i also need to know the winner's and loser's id's.</p>
  
  <pre><code>SELECT 
      *, 
      min(score) as loser, 
      max(score) as winner 
  FROM games
  LEFT JOIN 
      games_members 
  ON 
      games_members.games_id = games.games_id
  GROUP BY 
      games_members.games_id
  </code></pre>