title: SQL: Need help listing all the unique names and the number of times they appear in two columns
body: <p>I've got 2 columns filled with names. The list is seemingly random and a person's name could show up in column A or column B (but never in both at the same instance). I want to write a query that will tell me all the names and the number of times each person is in either list. Here's an example of what I'm talking about</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Col A</th>
  <th>Col B</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Mark</td>
  <td>Cheryl</td>
  </tr>
  <tr>
  <td>Andy</td>
  <td>Tom</td>
  </tr>
  <tr>
  <td>James</td>
  <td>Mark</td>
  </tr>
  <tr>
  <td>Tom</td>
  <td>Ann</td>
  </tr>
  <tr>
  <td>Cheryl</td>
  <td>Jeff</td>
  </tr>
  <tr>
  <td>Andy</td>
  <td>Mark</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I'm looking for a query/function that will give me the list of names and the number of times they were seen in either column.</p>
  <p>Any help is always appreciated!</p>