title: Selecting multiple max() values using a single SQL statement
body: <p>I have a table that has data that looks something like this:</p>
  
  <pre><code>data_type, value
  World of Warcraft, 500
  Quake 3, 1500
  Quake 3, 1400
  World of Warcraft, 1200
  Final Fantasy, 100
  Final Fantasy, 500
  </code></pre>
  
  <p>What I want to do is select the maximum of each of these values in a single statement. I know I can easily do something like</p>
  
  <pre><code>select data_type, max(value)
  from table
  where data_type = [insert each data type here for separate queries]
  group by data_type
  </code></pre>
  
  <p>But what I want it to display is is</p>
  
  <pre><code>select data_type, 
    max(value) as 'World of Warcraft', 
    max(value) as 'Quake 3', 
    max(value) as 'Final Fantasy'
  </code></pre>
  
  <p>So I get the max value of each of these in a single statement. How would I go about doing this?</p>