title: Query that will match a non-unique id if there is data in two separate columns across multiple rows
body: <p>I'm stuck trying to figure out how to extract data from a single table. What I need a query that will match an id (non-unique) if there is data in two separate columns across multiple rows. Here is an example of the data.</p>
  
  <pre><code>+---------+---------------+-----------+
  |     id  |  Drivers      | Brands    |
  +---------+---------------+-----------+
  |    1    |               |  Brands   |
  |    2    |   Drivers     |           | 
  |    3    |   Drivers     |           | 
  |    1    |   Drivers     |           | 
  |    4    |               | Brands    | 
  |    2    |   Drivers     |           | 
  |    3    |               | Brands    | 
  |    4    |               | Brands    | 
  +---------+---------------+-----------+
  </code></pre>
  
  <p>Id 1 and 3 are the only rows that contain values in both Drivers and Brands. This is the data I need.</p>
  
  <p>Few things about the data:</p>
  
  <ul>
  <li>There will never be a row with both Drivers and Brands.</li>
  <li>Its possible an id will have multiple rows with just Driver or just Brands (cant use count to determine a match).</li>
  </ul>