title: SQL select distinct when one column in and another column greater than
body: <p>Consider the following dataset:</p>
  
  <pre><code>+---------------------+
  | ID | NAME  | VALUE  |
  +---------------------+
  | 1  | a     | 0.2    |
  | 1  | b     | 8      |  
  | 1  | c     | 3.5    |
  | 1  | d     | 2.2    |
  | 2  | b     | 4      |
  | 2  | c     | 0.5    |
  | 2  | d     | 6      |
  | 3  | a     | 2      |
  | 3  | b     | 4      |
  | 3  | c     | 3.6    |
  | 3  | d     | 0.2    |
  +---------------------+
  </code></pre>
  
  <p>I'm tying to develop a <code>sql</code> select statement that returns the top or distinct ID where NAME 'a' and 'b' both exist and both of the corresponding VALUE's are >= '1'.  Thus, the desired output would be:</p>
  
  <pre><code>+---------------------+
  | ID | NAME  | VALUE  |
  +---------------------+
  | 3  | a     | 2      |
  +----+-------+--------+
  </code></pre>
  
  <p>Appreciate any assistance anyone can provide.</p>