title: SQL query same column twice
body: <p>I need to query the same column for different values depending on another relational value. </p>
  
  <p>Table is set up like this : athleteID, meetName, eventName, score</p>
  
  <p>Events are all the same but there are Different Meets and my query needs to return: aid, event, score from meetName = 'whatever1', score from meetname = 'whatever2'</p>
  
  <p>Ive tried every basic way about completeing this but cannot do it. I've lastly tried </p>
  
  <pre><code>SELECT distinct athleteID, event,
  (select score from performances where meetName='Snowflake') as SnowScore,
  (select score from performances where meetName='Valentine') as ValScore,
  from performances
  where event='high jump'
  </code></pre>
  
  <p>which returns: single-row subquery returns more than one row</p>
  
  <p>My expected result would be like this:</p>
  
  <pre><code>aid, event, SnowScore, ValScore
  1 , high jump, 6,  8
  2 , high jump, 3,  5
  3, high jump, 8, 10
  </code></pre>