title: Building a truth table in SQL
body: <p>I have the following sample table</p>
  
  <pre><code>User | Event 
  =============
  Bob    EventX
  Steve  EventA
  Bob    EventC
  Jane   EventB
  Jane   EventA
  Bob    EventC
  </code></pre>
  
  <p>I want to build a truth table that just tells me if a particular User has fired a particular event</p>
  
  <pre><code>User | EventA | EventB | Event C | Event X
  ===============================================
  Bob     False    False    True      True
  Steve   True     False    False     False
  Jane    True      True    False     False
  </code></pre>
  
  <p>Is there any way to this in SQL instead of having to write code to build this table?</p>
  
  <p>thank you</p>