title: MySQL SELECT multiple rows with same column value based on value from another column
body: <p>I am just getting started with MySQL queries, and have been fighting this for days with no luck finding a solution, so here goes.</p>
  
  <p>Table structure as follows:</p>
  
  <pre><code>|         ID         |   TAG
  | 111909684134416384 | WesternU
  | 111909684134416384 | ldnon
  | 111910470428008448 | ldnont
  | 111910470428008448 | fb
  | 111910605249712128 | LTC
  | 111910605249712128 | ldnon
  | 111911886139826176 | ldnont
  | 111911886139826176 | WesternU
  </code></pre>
  
  <p>I would like to select, count, and list the TAG(s) where one TAG of the same ID has 'ldnont' or 'ldnon' listed.</p>
  
  <p>Essentially, from this data set, I would like to list and count:</p>
  
  <pre><code>WesternU (2)
  fb (1)
  LTC (1)
  </code></pre>
  
  <p>I've been able to select and count, but only the first row of rows with duplicate ID.
  Thank-you in advance for any assistance.</p>