title: SQL query for top entries using multiple columns
body: <p>I’ve got a Sqlite Database I want to query. My basic SQL Knowledge enables me to query for most I need but I’m stuck here:</p>
  
  <p>The table looks like this (simplified!):</p>
  
  <pre><code>| Name            | Year | Title   | Musician 1 | Musician 2  |
  | --------------- | ---- | ------- | ---------- | ----------- |
  | Doe, Jon        | 2007 | Title 1 | Beatles    | The Stooges |
  | May, Peter      | 2001 | Title 2 |            | Beatles     |
  | Schmidt, Andrea | 1997 | Title 3 | Nick Cave  |             |
  </code></pre>
  
  <p>I’d like to be able to query for <code>Top Musician in the 2000s</code> and get an output like </p>
  
  <pre><code>| Name        | Count |
  | ----------- | ----- |
  | Beatles     | 2     |
  | The Stooges | 1     |
  </code></pre>
  
  <p>How would you archieve this? Thanks!</p>