title: How Do I Count Occurrences in a Column in SQL?
body: <p>I have a table that lists the following values. Some of the values in column 1 show up twice for the same customer (for example <code>apple</code> could show up 2 or more times.)</p>
  
  <pre><code>Column 1
  Apples
  Oranges
  Bananas
  </code></pre>
  
  <p>I know I can use this to get the count for each of the values. </p>
  
  <pre><code>SELECT column 1, COUNT(*)
  FROM table
  GROUP BY column 1
  </code></pre>
  
  <p>Is there a way to write a SQL statement that looks at when the count of one of those values shows up twice for the same customer? </p>
  
  <p>For example, I want to find out how many times apple shows up twice for the same customer. </p>