title: How do I count number of different types of things in a SQL table?
body: <p>I have a table storing a set of transactions</p>
  
  <pre><code>Customer | Flavor | Date Purchased | Location | blah | blah
  Anna     | Apple  | 2014-01-01     | Seattle  | 1    | 0
  Anna     | Grape  | 2014-01-01     | Seattle  | 1    | 0
  ...
  </code></pre>
  
  <p>I'd like to be able to select the number of different flavors each customer tried.</p>
  
  <p>Like...</p>
  
  <pre><code>Who   | Number of flavors tried
  Anna  | 4
  Beth  | 1
  Cathy | 100
  </code></pre>
  
  <p>And it's bending my brain into a knot. How do I group/join/? my way to victory?</p>