title: SQL group in several columns
body: <p>I have 3 columns (column1, column2 and column3) and data like this</p>
  
  <pre><code>column1      column2      column3
  question1    question3    question5
  question2    question4    question6
  </code></pre>
  
  <p>I like to count and group for each columns and result like this</p>
  
  <pre><code>column1   countc1    column2    countc2     column3     countc3
  question1  10        question3    1         question5     12
  question2  5         question4    2         question6     20
  </code></pre>
  
  <p>For example column1 has several questions which have multiple exact the same questions and I like group and count. 10 question1 and 5 question2</p>
  
  <pre><code>County     Zip       Direct
  Lane       97230      west
  Lane       97230      west
  Medfore    97110      east
  </code></pre>
  
  <p>so the result (nc=new column count)</p>
  
  <pre><code>County  nc       ZIp   nc      Direct  nc 
  Lane     2      97230  2       west    2
  Medfore  1      97110  1       east    1
  </code></pre>
  
  <p>These columns will not relate to each other. </p>